Can Commit / Rollback be added to a form to prevent update on Close [X] ?

[S400]

I have a form which allows only INSERT of a single row into a table.



Problem is that it seems to write a record (as dirty data) as soon as it is loaded.
The user is required to enter some fields for which there is validation coded.

BUT.... if the user clicks on [X] (or does a right-click Close) then the dirty data stays in the table.

Can I incorporate a Commit/Rollback function in the DoCmd Close event ?

So that I can revalidate the data in the Close event, and if it is invalid then cancel the insert into the table?

[June7]

Usual approach is to use form BeforeUpdate event to validate data and to cancel if it is not valid.

Also, can disable form X close and shortcut menu with form properties. Disabling app X close and ribbon File>Close is more complicated.

[Welshgasman]

@June7
O/P was asking what appears to be the same question and had assistance in this thread?
https://www.accessforums.net/showthread.php?t=83679

[S400]

Hi @June7,
Not the same question as in earlier thread, but similar, as we were looking for options on how to prevent an update if a user closes a Form window without the data being entered & valid.
Most development platforms I work on support a Transaction Integrity system in SQL with Commit/Rollback functions.
So this question was to see if such an approach would be valid in MS Access.

As it so happens, we have coded a solution which works without needing to employ Transaction Integrity - so this question is now moot.

[Minty]

To answer your question directly, yes transactions are available;
https://codekabinett.com/rdumps.php?...ss-transaction

but not normally required, except in very specific situations, normally when updating multiple records.
In your example of a single insert I can't see the point of adding the complexity.

Assuming it is a small dataset it would probably be easier to create a small unbound form, only writing the insert when confirmed.
Or much simpler using the form's before update as per the other thread.