Friday, October 28, 2005

Confirm Record changes Option

Latest Access versions has Confirm Record Changes in menu Tools > Options > Edit/Find. Tooltip says that option used to show confirmation dialog when you change a record. Did you ever see such confirmation dialog?
Thanks to MVP Karl Donaubauer, who made a clear explanation of it:
The name of the option may be a bit misleading. It refers to the messages that you get when you delete one or more records or insert multiple records from the clipboard into a table, query or form. "Do you really want to...delete/insert..." etc. If the box is unchecked there are no such messages instead the actions are executed silently.

3 comments:

  1. Anonymous2:01 AM

    I have a question... :)
    how do you turn it off when you deploy app somewhere? I couldn't do that untill I've installed normal access (not runtime) and then turned it off. After that I'v installed runtime again, and it worked.

    ReplyDelete
  2. Anonymous2:04 AM

    thank you. :)

    ReplyDelete
  3. You can set it any time using SetOption, see online help for more info

    ReplyDelete