Jim Lawrence
accessd at shaw.ca
Mon Jun 8 21:03:35 CDT 2009
Hi Rocky: Why not turn off the error handling and comment out the 'On Error Resume Next' line and then step though the code and see where it bales. Jim -----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:57 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Update or Cancel Update without Addnew or Edit 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