[AccessD] Update or Cancel Update without Addnew or Edit

Rocky Smolin rockysmolin at bchacc.com
Mon Jun 8 23:12:50 CDT 2009


Legacy app - redesign is not a practical option - the form is hugely
complex.  Hugely.  If this is the problem, I'll have to find a work-around.

Rocky

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Hindman
Sent: Monday, June 08, 2009 8:34 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Update or Cancel Update without Addnew or Edit

...lol ...redesign the form to have a single data source ...I've seen this
happen when a subform is bound to a different query based on the same
table/query as the main form record source ...if one is dirty, an update to
the other can give you strange feedback depending on your cb.

William

--------------------------------------------------
From: "Rocky Smolin" <rockysmolin at bchacc.com>
Sent: Monday, June 08, 2009 11:04 PM
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Update or Cancel Update without Addnew or Edit

> Possible.  Work-around?
>
> Rocky
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William 
> Hindman
> Sent: Monday, June 08, 2009 5:57 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Update or Cancel Update without Addnew or Edit
>
> ...sub-query/form hitting the same record as the main?
>
> William
>
> --------------------------------------------------
> From: "Rocky Smolin" <rockysmolin at bchacc.com>
> Sent: Monday, June 08, 2009 7:04 PM
> To: "'Access Developers discussion and problem solving'"
> <accessd at databaseadvisors.com>
> Subject: [AccessD] Update or Cancel Update without Addnew or Edit
>
>> Dear List:
>>
>> I am getting a mysterious message in a client app "Update or Cancel 
>> Update without Addnew or Edit", mysterious because, first there's no 
>> Debug button so I can't see where it's happening, second, it's a 
>> bound form - no DAO, no recordsets, no Update or Cancel Update 
>> instructions in the code, third, it's not reproducible, but it 
>> happens enough that I've got to figure out what's causing it.
>>
>> I have a feeling the error message is not telling me what the real 
>> error is
>> - like the one that says "you cancelled the previous operation" which 
>> I didn't but it usually means there's a problem in the SQL that being 
>> run.
>>
>> Anyway, anything at this point would be welcome.  It's a stumper.
>>
>>
>>
>> MTIA
>>
>>
>>
>> Rocky Smolin
>>
>> Beach Access Software
>>
>> 858-259-4334
>>
>> www.e-z-mrp.com <http://www.e-z-mrp.com/>
>>
>> www.bchacc.com <http://www.bchacc.com/>
>>
>>
>>
>>
>>
>>
>
>
>
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list