John W. Colby
jcolby at colbyconsulting.com
Thu Dec 4 15:26:07 CST 2003
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