William Hindman
wdhindman at dejpolsystems.com
Tue Jun 9 00:05:55 CDT 2009
...if you have overlapping, updatable record sources there won't be a work around ...you have to fix it ...is this a new problem without any changes? ...or has there been some recent changes to the app by you or someone else? ...if new without any changes, I'd approach it as corruption ...if there have been changes, I'd look at all of the record sources on the form and its subs including those for any controls or lookups ...looking to see if they are using the same source. ...and worst case with an intermittent type problem ...consider line numbering your code and re-doing your error codes to feed you the line producing the error ...I've used the mztools add-in to do this. William -------------------------------------------------- From: "Rocky Smolin" <rockysmolin at bchacc.com> Sent: Tuesday, June 09, 2009 12:12 AM To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Subject: Re: [AccessD] Update or Cancel Update without Addnew or Edit > 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 > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >