Results 1 to 3 of 3

Thread: autosave in ms access

  1. #1
    Join Date
    Mar 2004
    Posts
    1

    Post autosave in ms access

    I must develop a MS Access database that will NOT automatically save any entered data in form fields until someone actually presses a Save button on the form.

    MS Access automatically saves data entered as a default. How do I get around this for multiple forms and fields?

  2. #2
    Join Date
    Feb 2003
    Location
    Earth, USA
    Posts
    81

    Unbound Fields

    Create a form with the bound fields Visible property set to False. You can use the OnCurrent Event to populate your unbound fields, make changes or additions in the unbound fields. Create a command button to transfer the data in the unbound fields to the bound fields.

  3. #3
    Join Date
    Jan 2003
    Location
    UK
    Posts
    277
    Or........

    just have unbound fields on your form so when the Save button is clicked you open a recordset or sets on the appropriate table(s) and Add the data to them that way.

    This requires more coding effort than the other idea but gives you absolute control over what is going on and how it is handled.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •