[AccessD] Disable undo function from VBA.

StaRKeY starkey at wanadoo.nl
Fri Dec 5 14:36:40 CST 2003


(Very big grin)
Always nice to see developers being pummeled around with an Access issue:-)

Erwin, I've seen solutions for 'problems' you couldn't imagine but despite
the fact there might be a better solution... if it works it works!
(Especially if time is breathing in your neck)

Glad to hear you have a working solution.


Regards,
Eric Starkenburg


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Erwin Craps -
IT Helps
Sent: vrijdag 5 december 2003 15:28
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Disable undo function from VBA.


I came up with this

With Me.Recordset
	.Edit
      .Fields("Description") = Time 'just for test
	(and other fields
      .Update
End With
DoCmd.RunCommand acCmdSaveRecord


It looks a bit redundant but you all know that me.description is a
reference to the control on the form and
Me.Recordset.fields("Description") is a direct reference to the
recordset.

The dirty thing does not work, because I already did a accmdsaverecord,
so you cant save twice.
Unless there is a clear_the_undo_cache command, this is the best I can
come up with.

I don't wanna create my own menu/toolbars have been busy in the past
with that and I hate it...
I have to make them tree times in different languages....

Erwin






-----Oorspronkelijk bericht-----
Van: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] Namens Erwin Craps - IT
Helps
Verzonden: vrijdag 5 december 2003 8:24
Aan: Access Developers discussion and problem solving
Onderwerp: RE: [AccessD] Disable undo function from VBA.


Hum

Please note that this "undo saved record" behavior I experiance is in
both A97 and AXP. And in a FORM.

I'll try the dirty form, but as it wlll save the record I don't believe
this will solve the problem.

Even dooing a me.recordset.edit, fields ("")="jkj";.update does not seem
to help, but I'm not totaly out of that due to lack of time. I find this
pretty heavy stuff....

The undo event neither helps.
Undo event (form) only seems to occur when a field is undood. Not when
clicking "undo saved record".

Erwin



-----Oorspronkelijk bericht-----
Van: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] Namens David McAfee
Verzonden: vrijdag 5 december 2003 1:49
Aan: 'Access Developers discussion and problem solving'
Onderwerp: RE: [AccessD] Disable undo function from VBA.

Not that I ever do this either... :P but... undo is not multi level.

As Charlotte said, you can move to any record, but you can only undo the
last change.

both tables and queries (non snap shot of course)

D

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Charlotte
Foust
Sent: Thursday, December 04, 2003 4:38 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Disable undo function from VBA.


I never use it myself or let my users near the tables, so I don't have
any answers.  I don't know about multi-level, but you can move to a
different record and the undo will undo the edited one.

Charlotte Foust

-----Original Message-----
From: John W. Colby [mailto:jcolby at colbyconsulting.com]
Sent: Thursday, December 04, 2003 4:23 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Disable undo function from VBA.


WOW.  Constantly amazed, though that would explain it.  I occasionally
edit records directly in tables myself but my users are NEVER allowed in
tables. Thus I just never noticed that.

Does it apply if you have edited the record via a form, or only through
the table?  Through a query?  Through a recordset?  What happens if a
second record was edited?  Multi-level undo?

John W. Colby
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Charlotte
Foust
Sent: Thursday, December 04, 2003 4:51 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Disable undo function from VBA.


You'll see it in the edit menu from a table, John, if the full menus are
available and you have edited a record.

Charlotte Foust

-----Original Message-----
From: John W. Colby [mailto:jcolby at colbyconsulting.com]
Sent: Thursday, December 04, 2003 1:26 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Disable undo function from VBA.


Eric,

I'm not sure what you are referring to.  Dirty is a property of a form.
It is set when the record is first modified and cleared when the save
occurs. If you set it false in code, it saves the record.

Of all that I am sure because I use it.

Now what exactly is "Undo saved record"?  I know of no such thing in
Access.

John W. Colby
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of StaRKeY
Sent: Thursday, December 04, 2003 4:02 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Disable undo function from VBA.


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



_______________________________________________
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


---
avast! Antivirus: Outbound message clean.
Virus Database (VPS): 5-12-2003
Tested on: 5-12-2003 21:36:38
avast! is copyright (c) 2000-2003 ALWIL Software.
http://www.avast.com





More information about the AccessD mailing list