Go Back   Access World Forums > Microsoft Access Discussion > General

 
 
 
Thread Tools Rate Thread Display Modes
Prev Previous Post   Next Post Next
Old 10-12-2018, 09:11 AM   #1
AvantGuy
neophyte
 
AvantGuy's Avatar
 
Join Date: Mar 2018
Location: Pueblo, Colorado USA
Posts: 22
Thanks: 13
Thanked 0 Times in 0 Posts
AvantGuy is on a distinguished road
In a Tab Control moving thru Recordset, dirty/undo questions

[I'm still an Access neophyte, so feel free to treat me as such :-)]

I'm seeking advice on how to architect my in-progress, bound form design containing a tabControl. Whichever page of the tabControl is active, the user will move through the Recordset and may make edits to some records and only view others. Via a single operation, they may wish to save all edits or undo all edits*. A bound form default behavior seems to be to save an update whenever an edited control loses focus. Because in my case dirty status must be determined at the Recordset level (controls-dirty is out of the question, seems to me, because the controls on a given tabPage are shared among all records), I'm finding several potential alternatives to handle Undo, such as:
  • ​​an in-code temp array to compare against the recordset for changes ​​​​
  • ​​​​use of clone recordse​​t​ for comparisons​ ​
  • a TRANSACTION​​
Have I discovered all the relevant alternatives?
Any suggestions as to the pitfalls and merits of each of these?
* Additionally, I may implement a per record save if such would not conflict with the batch save/undo; this is not yet in the spec and I consider it optional at this time.
Thanks, Bob

__________________
COME COME and cull me bonny bony doublebed cony swiftly my springal and my thin Kerry twingle-twangler comfort my days of roses days of beauty week of redness with mad shame to my lips of shame to my shamehill for the newest news the shemost of shenews is I'm lust-beleperd and unwell..." --Samuel Beckett
AvantGuy is offline   Reply With Quote
 

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Form Control still 'saving' after Undo/Cancel David R Forms 3 07-09-2014 08:28 AM
[SOLVED] Pencil/Triangle Dirty/Undo caferacer Forms 2 05-19-2014 01:46 PM
Unable to undo changes when control lost focus JenSGT Forms 1 08-05-2009 06:42 AM
Need to Save a Dirty Record without moving to another Record ions Forms 2 04-01-2009 09:09 AM
[SOLVED] Moving to subform when ME Dirty bmunk Forms 4 09-29-2003 03:23 PM




All times are GMT -8. The time now is 07:47 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World