Rocky Smolin
rockysmolin at bchacc.com
Mon Jun 8 22:07:48 CDT 2009
Ooh, not a trivial task. In any event the On error statement is executed on condition of a Boolean global which is set to true only if the file is an mde. If an mdb - no error traps so I can debug. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins Sent: Monday, June 08, 2009 6:05 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Update or Cancel Update without Addnew or Edit Rocky, I'd comment out the error code until it's resolved. Susan H. > Error traps are in every module, but it's not hitting any of those. > > Resume next only in snips like this: > > OutWeGo: > > On Error Resume Next > > rstMatterAction.Close > Set rstMatterAction = Nothing > rstMatterActionPersons.Close > Set rstMatterActionPersons = Nothing > > db.Close > Set db = Nothing > > > > Exit_AttyMatter_AfterUpdate: > Exit Sub > > > Rocky > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mike Mattys > Sent: Monday, June 08, 2009 5:37 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Update or Cancel Update without Addnew or Edit > > On Error GoTo (or Resume Next) ? > > - > Michael R Mattys > MapPoint and Database Dev > www.mattysconsulting.com > - > ----- Original Message ----- > From: "Charlotte Foust" <cfoust at infostatsystems.com> > To: "Access Developers discussion and problem solving" > <accessd at databaseadvisors.com> > Sent: Monday, June 08, 2009 8:17 PM > Subject: Re: [AccessD] Update or Cancel Update without Addnew or Edit > > >> Any transactions that might be rolled back? >> >> Charlotte Foust >> >> -----Original Message----- >> From: accessd-bounces at databaseadvisors.com >> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky >> Smolin >> Sent: Monday, June 08, 2009 5:09 PM >> To: 'Access Developers discussion and problem solving' >> Subject: Re: [AccessD] Update or Cancel Update without Addnew or Edit >> >> Oops - wrong about the DAO - there are recordsets being opened and >> closed. >> Let me take a look at the .Updates and see if there's a .Update >> without a .Addnew or .Edit... >> >> Ok, Checked - no .Update without am .Edit or .AddNew in line with no >> possibility of reaching the .Update without executing the .AddNew or >> .Edit first. No .CancelUpdates. >> >> Rocky >> >> >> -----Original Message----- >> From: accessd-bounces at databaseadvisors.com >> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan >> Harkins >> Sent: Monday, June 08, 2009 4:20 PM >> To: Access Developers discussion and problem solving >> Subject: Re: [AccessD] Update or Cancel Update without Addnew or Edit >> >>> 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. >>> >> >> =======Got a Recordset object? >> >> Susan >> >> -- >> 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com