[AccessD] Update or Cancel Update without Addnew or Edit

Mike Mattys mmattys at rochester.rr.com
Mon Jun 8 22:29:26 CDT 2009


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 




More information about the AccessD mailing list