[AccessD] Update or Cancel Update without Addnew or Edit

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.





More information about the AccessD mailing list