[AccessD] Update or Cancel Update without Addnew or Edit

Rocky Smolin rockysmolin at bchacc.com
Mon Jun 8 22:07:48 CDT 2009


Ooh, not a trivial task.  In any event the On error statement is executed on
condition of a Boolean global which is set to true only if the file is an
mde.  If an mdb - no error traps so I can debug.

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 6:05 PM
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




More information about the AccessD mailing list