Software

Ask something
Discussion Locked

Access 97 Forms

0 helpful
5 replies

by bowjangles

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I was wondering if it is possible and how to eliminate all the ways that Access saves records except for a Save button which i created. Because, for example: When you tab through all the controls on form it saves the current record. Is it possible to stop all these saves except a coded Save button. Thanks.

5 replies

by donq

It is inherent to Microsoft's Jet Engine that current field values are saved each time the record changes. I beiieve youwould need a new database engine, but of course you could always close a session and say NO to the Save Changes?" propmt.

by larry h.

You could add a "dummy" field to the form's underlying table and make it a mandatory field. Don't add a control to the form for this field, but edit the OnClick code for the SAVE button to add a value to the dummy field. Thus, the only way to savethe record is to put a value in the dummy field, and the only way to do that would be to click the SAVE button.

The dummy field could be a totally meaningless item, or you could use it to track the date/time the record was added.

This discussion is closed to new replies.