Rocky Smolin
rockysmolin at bchacc.com
Tue Jun 9 00:43:04 CDT 2009
Ah yes there it is. Was looking in the access options. Thanks 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 10:13 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Update or Cancel Update without Addnew or Edit ...open the VBE ...then tools/options/general William -------------------------------------------------- From: "Rocky Smolin" <rockysmolin at bchacc.com> Sent: Monday, June 08, 2009 11:59 PM To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Subject: Re: [AccessD] Update or Cancel Update without Addnew or Edit > That sounds promising. Can't find the switch though. Where do you > set that option (A2K3)? > > 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 8:29 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Update or Cancel Update without Addnew or Edit > > I believe you have to set the option to break on all/unhandled errors > - > Michael R Mattys > MapPoint and Database Dev > www.mattysconsulting.com > - > ----- Original Message ----- > From: "Rocky Smolin" <rockysmolin at bchacc.com> > To: "'Access Developers discussion and problem solving'" > <accessd at databaseadvisors.com> > Sent: Monday, June 08, 2009 11:15 PM > Subject: Re: [AccessD] Update or Cancel Update without Addnew or Edit > > >> The error message is not being trapped in a line of code. Ctrl-break >> doesn't drop me into the VBA. And the on error statement only gets >> executed if the file is an mde. >> >> Rocky >> >> >> -----Original Message----- >> From: accessd-bounces at databaseadvisors.com >> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim >> Lawrence >> Sent: Monday, June 08, 2009 7:04 PM >> To: 'Access Developers discussion and problem solving' >> Subject: Re: [AccessD] Update or Cancel Update without Addnew or Edit >> >> 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 >> >> -- >> 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