[AccessD] Disable undo function from VBA.

StaRKeY starkey at wanadoo.nl
Thu Dec 4 15:01:34 CST 2003


Have you checked this John?:-)

I ask because I played with a table, adding a new record, hop onto another
old/new record and the undo saved record feature still worked.
Isn't dirty true if the record isn't saved yet?


Regards,
Eric Starkenburg

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John W. Colby
Sent: donderdag 4 december 2003 21:46
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Disable undo function from VBA.


Setting dirty to false saves the record so there would definitely be no undo
available after that!

John W. Colby
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Rocky Smolin -
Beach Access Software
Sent: Thursday, December 04, 2003 3:38 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Disable undo function from VBA.


What happens if you set dirty to false?  Then wouldn't the undo fail ('undo
not available at this time' or some such error which you could trap)?

Rocky

----- Original Message -----
From: "Erwin Craps - IT Helps" <Erwin.Craps at ithelps.be>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Thursday, December 04, 2003 4:58 AM
Subject: RE: [AccessD] Disable undo function from VBA.


> I'm busy testing some stuff, like using the me.recordset and edit/update
> the fields instead of the controls on a form.
>
> I also looked at the undo event of the form, but that doesn't work
> neither...
>
> What I really would like to have is some kind of "Clear the undo cache"
> function.
>
> I'll let you know what.
> Closing form and opening again is not an option for me.
>
> Erwin
>
>
> -----Oorspronkelijk bericht-----
> Van: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] Namens Ervin Brindza
> Verzonden: donderdag 4 december 2003 13:35
> Aan: Access Developers discussion and problem solving
> Onderwerp: Re: [AccessD] Disable undo function from VBA.
>
>
>
> ----- Original Message -----
> From: "StaRKeY" <starkey at wanadoo.nl>
> To: "Access Developers discussion and problem solving"
> <accessd at databaseadvisors.com>
> Sent: 04 December, 2003 12:42 PM
> Subject: RE: [AccessD] Disable undo function from VBA.
>
>
> > Correct me if I'm wrong but wouldn't this imply that you close and
> > open
> the
> > form every time a new value in a record is changed?:-)
> >
> Erwin wrote:
> "When printing I programaticaly give the invoice a number and save the
> record." So, I think to close the form, only in the OnClick event of a
> command button. And that have to be rarely... And after the printing I
> suppose that the invoice is finished so the code can be even simpler:
> DoCmd.RunCommand acCmdSave
> DoCmd.Close
>
> but Erwin will decide :)
> Ervin
>
>
>
> _______________________________________________
> 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


---
avast! Antivirus: Outbound message clean.
Virus Database (VPS): 2-12-2003
Tested on: 4-12-2003 22:01:32
avast! is copyright (c) 2000-2003 ALWIL Software.
http://www.avast.com





More information about the AccessD mailing list