William Hindman
wdhindman at bellsouth.net
Thu Dec 4 16:06:25 CST 2003
...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
>