[AccessD] Update or Cancel Update without Addnew or Edit

Rocky Smolin rockysmolin at bchacc.com
Mon Jun 8 22:15:46 CDT 2009


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




More information about the AccessD mailing list