Automatic Save

[HOT FLASH]

I was told in the General Forum that there is no auto-save function in Access
that will allow setting time increments, but instead, there exists a built-in
function that saves work in Access. Does anyone know the time increment that
Access uses for its built-in auto saves?
As I intend the forms I am developing to be used by computer novices, I
would like to have a way for their answers to be saved as the data to be
captured is very long. (At the end of each section would be ideal) I wonder
if every time the user goes to a sub form or another form, the preceding data
is automatically saved? Information, ideas, or suggestions very welcome.
Thanks

 

[Jeff Boyce]

Access attempts to save a record when that record (or form) loses focus. If
you have main form/sub-form construction, putting the focus on a control in
the subform will "save" the main form record.

If you are using a tab control, you could use the Change event of that
control to determine that the tab page was changed, and write code to force
a save there.

Hopefully this helps...

Jeff Boyce
<Access MVP>

 

[HOT FLASH]

Hi Jeff, Thank you for replying. How would I do that, exactly? How do I put
focus on a contol in a subform? I will be using tabs, but I do not know
that code for what you described. Thanks again.

 

[Jeff Boyce]

Clicking on something in a form puts the focus there.

Adding code to an event of a control (or a form) could be used to set the
focus (See Access HELP on .SetFocus).

Have you written any VB code before? If not, you might find it easier to
work with macros. Either way, the generic approach would be to add code to
save the record.

If you'd like to see an example of such code, open your form in design mode,
make sure your Toolbar's "wizard" button is clicked on, and add a command
button control. The wizard will step you through what you can do, and if
you pick saving a record, the code will be written for you.

Good luck

Jeff Boyce
<Access MVP>