Results 1 to 3 of 3
  1. #1
    shanky365 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jul 2011
    Posts
    13

    Stop auto save of forms

    I have created a simple form for entering data into my table.
    but if the user jus enters one field out of four and close the form, the table gets updated with this single entry.
    i want to restrict this entyry as invalid


    as i want there sholuld be some botton , by clicking only dat u can save the data, nt before dat.

  2. #2
    khalid's Avatar
    khalid is offline MS-Access Developer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2010
    Location
    Kuwait
    Posts
    244
    one way is to prevent the data to being saved in a table, is to make some fields as required data type in table design view. so no record will be saved unless you fill the required field.

  3. #3
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    If you are using a bound form you'll have to perform some sort of check before the record becomes 'permanent' in your database. The easiest way to do this is to make all of the fields they have to enter 'required' on your table design view. If they try to navigate away from your form without filling out the four fields an error message will be displayed and they will not be able to exit until they either clear the contents or fill them out.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Auto Save MS Access 2007
    By BlindLady in forum Access
    Replies: 2
    Last Post: 02-27-2011, 06:44 AM
  2. stop access from auto adding records
    By svcghost in forum Forms
    Replies: 2
    Last Post: 10-21-2010, 05:25 PM
  3. Replies: 2
    Last Post: 11-29-2009, 12:00 PM
  4. Turn Off Auto Save Record
    By Syntinal in forum Forms
    Replies: 2
    Last Post: 03-01-2009, 11:30 AM
  5. auto start/stop time
    By j0ker21m in forum Reports
    Replies: 1
    Last Post: 12-10-2005, 08:42 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums