[AccessD] Update or Cancel Update without Addnew or Edit

William Hindman wdhindman at dejpolsystems.com
Tue Jun 9 00:12:44 CDT 2009


...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
> 





More information about the AccessD mailing list