[AccessD] Disable undo function from VBA.

Ah, but I'm on the developers side.  If only we could get a better class
of users ... <VBG>

Charlotte Foust

-----Original Message-----
From: William Hindman [mailto:wdhindman at bellsouth.net] 
Sent: Thursday, December 04, 2003 2:06 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Disable undo function from VBA.


...pummel the developer ...scold the user ...makes for better client
relations :)

William Hindman
Government is not reason, government is not persuasion, government is
force. It is a dangerous servant." G. Washington

----- Original Message ----- 
From: "Charlotte Foust" <cfoust at infostatsystems.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Thursday, December 04, 2003 5:02 PM
Subject: RE: [AccessD] Disable undo function from VBA.


> Does that option show up in the forms' menubar?  I don't ever recall 
> seeing it there, and users should NOT be working directly in tables.  
> If they are, they should be pummeled soundly until they break the 
> habit. And the developer should be scolded for enabling that behavior.
>
> Charlotte Foust
>
> -----Original Message-----
> From: StaRKeY [mailto:starkey at wanadoo.nl]
> Sent: Thursday, December 04, 2003 2:04 PM
> To: Access Developers discussion and problem solving
> Subject: RE: [AccessD] Disable undo function from VBA.
>
>
> John,
>
> check this: in Access 2000, pick any existing table in a database, 
> open the table and add a new record. Move the cursor to a new or other

> record and have a look at the menubar 'Edit' -> 'Undo Saved Record 
> (Ctrl-Z)'. Despite you saved the new record this option still enables 
> you to undo the addition. I posted a referral to Access help about 
> this feature earlier, that information should enable one to figure out

> a solution under the given circumstances.
>
> I imagine Erwin could also build a copy of the existing menubar he 
> uses without this 'Undo' button and have the Ctrl-Z turn into a beep 
> using the autokeys macro.
>
> Ohwell, almost friday here = almost weekend!:-)
>
> Have a nice dinner,
> Eric
>
>
>
> -----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 22:26
> 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
>
>
> ---
> avast! Antivirus: Outbound message clean.
> Virus Database (VPS): 2-12-2003
> Tested on: 4-12-2003 23:03:35
> 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