Results 1 to 7 of 7
  1. #1
    Join Date
    Mar 2003
    Posts
    4

    Unanswered: Hi every body autosave killing me

    how r u everybody
    i'm new member ,hi
    pls the autosave is killing me ,if i want to enter test data in the table
    the program direct saving what i entered ,and i don't want to save it.
    so if any one know how to cancel this option or have code make the save manual pls answer me

  2. #2
    Join Date
    Mar 2002
    Location
    Sacramento, CA
    Posts
    120
    Maybe I am reading this wrong, but couldn't you just copy & paste your table and delete the test records when you're done? (Then compact the database to get your autonumber back to 1)

    Michael

  3. #3
    Join Date
    Mar 2003
    Posts
    4

    Smile Thank you for your reply but...

    Thanks my dear for your reply
    but what i meant is that i don't want saving any new data entered to the table without ask me first.
    Suppose i entered 3 records i want from the access qustion for saving befor it save.
    on another explanation,when i want to leave(close) the table,the progrom should ask me if i want to save what i entered,not save it direct.

    i hope you get what i want .
    and thank you again.

  4. #4
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665

    Re: Thank you for your reply but...

    Originally posted by skullscollector
    Thanks my dear for your reply
    but what i meant is that i don't want saving any new data entered to the table without ask me first.
    Suppose i entered 3 records i want from the access qustion for saving befor it save.
    on another explanation,when i want to leave(close) the table,the progrom should ask me if i want to save what i entered,not save it direct.

    i hope you get what i want .
    and thank you again.
    have u set warnings off? thats the only way that u will not get the warning mesg. "do u want to update"
    regards Jim

  5. #5
    Join Date
    Mar 2003
    Posts
    4

    Smile Still no body got my point

    i want the code of saving the data in the table
    just i want to off autosave of the data
    i want save what i entered by save button
    because the program save any changes in dat of the table without
    ask you if you want to save the changes
    so i want code make this option off


    and thanks for every one replied me.

  6. #6
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665

    Re: Still no body got my point

    Originally posted by skullscollector
    i want the code of saving the data in the table
    just i want to off autosave of the data
    i want save what i entered by save button
    because the program save any changes in dat of the table without
    ask you if you want to save the changes
    so i want code make this option off


    and thanks for every one replied me.

    Ohhh!!! u dont want the msgs.
    the command for that is

    docmd.setwarnings false

    put that as the first line of your code and the last line should say

    docmd.setwarnings true

    that way u will get the errer msg again
    Regards Jim

  7. #7
    Join Date
    Mar 2003
    Posts
    4

    Thank my dear

    thank you alot
    i hope this way work

Posting Permissions

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