Darryl Collins
Darryl.Collins at coles.com.au
Mon Jun 8 20:54:06 CDT 2009
I agree with this approach. Sometimes the error traps can hide problems. good luck regards Darryl -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins Sent: Tuesday, 9 June 2009 11:05 AM 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 This email and any attachments may contain privileged and confidential information and are intended for the named addressee only. If you have received this e-mail in error, please notify the sender and delete this e-mail immediately. Any confidentiality, privilege or copyright is not waived or lost because this e-mail has been sent to you in error. It is your responsibility to check this e-mail and any attachments for viruses. No warranty is made that this material is free from computer virus or any other defect or error. Any loss/damage incurred by using this material is not the sender's responsibility. The sender's entire liability will be limited to resupplying the material.