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