Hello All,
I am using VBA with Access and would wish to know to prevent the "Are you sure you want to alter/append rows?" from popping up every time I make a query.
Printable View
Hello All,
I am using VBA with Access and would wish to know to prevent the "Are you sure you want to alter/append rows?" from popping up every time I make a query.
Open your Database and then select from the menu bar: Tools ---> Options and the Options Window will open. Next click the Edit/Find Tab and then Unselect in the Confirm Section the following: Action Queries and Record Changes. You shouldn't get that message any more.Quote:
Originally Posted by singularis
Thanks, While you are there can you explain how to make the unsafe expression box stop popping up everytime you open the file
MarkGambo's setting is correct, and what I use. It applies to all Access mdb files. If you just want to turn them off for a specific piece of code, you can use DoCmd.SetWarnings False, and then DoCmd.SetWarnings True to turn them back on.
[edit]
To clarify, Mark''s way works for any mdb file opened by that install of Access. If someone with their own copy of Access opens the file, they'll still get the warnings (unless they unchecked their options as well). Setting it in code works for anyone opening that file, but doesn't affect other mdb files.
Never seen the "unsafe expression" warning.