VBA, Way to undo changes at a table level?

Way to undo changes at a table level?

Author	Message
Vin Mille #1 / 4	Way to undo changes at a table level? (Please forgive the number of questions I have had in the past few days _ I am fumbling through a project using Access as a front and a back end, having worked with it in the past via VB). Is there a way to undo changes to a datasheet? It seems to be that records are automatically saved when you move from record to record. This is driving my client, who wants it to feel more like Excel, unfortunately, crazy.... And to be honest, I feel like I must be missing something. Isn't there some way to open a datasheet, save ten records, and then revert those changes? Any advice much appreciated. An email in addition to a group reply gets ya -- --------------------------------------- www.vinmiller.com
Mon, 10 Feb 2003 03:00:00 GMT

Paul Browe #2 / 4	Way to undo changes at a table level? Once you move from one record to another in a bound form, the record is saved. You may want to look in VSFlexGrid 7 (if you're using Access 2000). Otherwise, you may want to write code that checks if the record has been edited, and forces the user to save or undo his changes. Paul Brower http://www.browerconsulting.com Quote: > (Please forgive the number of questions I have had in the past few days _ I > am fumbling through a project using Access as a front and a back end, having > worked with it in the past via VB). > Is there a way to undo changes to a datasheet? It seems to be that records > are automatically saved when you move from record to record. This is > driving my client, who wants it to feel more like Excel, unfortunately, > crazy.... And to be honest, I feel like I must be missing something. Isn't > there some way to open a datasheet, save ten records, and then revert those > changes? > Any advice much appreciated. An email in addition to a group reply gets ya > -- > --------------------------------------- > www.vinmiller.com
Mon, 10 Feb 2003 03:00:00 GMT

Peter Walke #3 / 4	Way to undo changes at a table level? Create a form based on the table, plop all the relevant fields on it. Set the default view and views allowed properties to 'datasheet', and save it off. When opened, the form will look the same as a table, but will allow code the be executed in the before update events etc. You will have greater control in this situation than by opening a table (which supports almost nothing) hth -- peter walker ...don't forget to 'duck and cover'... ICQ 85542363 various things available from http://www.users.bigpond.com/papwalker/#Downloads . Quote: > (Please forgive the number of questions I have had in the past few days _ I > am fumbling through a project using Access as a front and a back end, having > worked with it in the past via VB). > Is there a way to undo changes to a datasheet? It seems to be that records > are automatically saved when you move from record to record. This is > driving my client, who wants it to feel more like Excel, unfortunately, > crazy.... And to be honest, I feel like I must be missing something. Isn't > there some way to open a datasheet, save ten records, and then revert those > changes? > Any advice much appreciated. An email in addition to a group reply gets ya > -- > --------------------------------------- > www.vinmiller.com
Mon, 10 Feb 2003 03:00:00 GMT

Brendan Reynold #4 / 4	Way to undo changes at a table level? You would need to base the form on a temporary table, and provide a means to copy the records from that table to the main table. You'd probably also want to delete the records from the temporary table after they had been copied. You'd probably want to use an append query and a delete query, and wrap them in a transaction, so that the delete query will not run if the append query fails. -- Brendan Reynolds Quote: > (Please forgive the number of questions I have had in the past few days _ I > am fumbling through a project using Access as a front and a back end, having > worked with it in the past via VB). > Is there a way to undo changes to a datasheet? It seems to be that records > are automatically saved when you move from record to record. This is > driving my client, who wants it to feel more like Excel, unfortunately, > crazy.... And to be honest, I feel like I must be missing something. Isn't > there some way to open a datasheet, save ten records, and then revert those > changes? > Any advice much appreciated. An email in addition to a group reply gets ya > -- > --------------------------------------- > www.vinmiller.com
Tue, 11 Feb 2003 03:00:00 GMT

Page 1 of 1

[ 4 post ]