Validation messages for runtime version.

[Casperov]

Hello All,

I have just deployed a runtime version of an Access system to a test machine. However, the messages "You are about to run a delete query" etc. is displayed when my queries are run. These messages are not coming up on my machine. Is there a way to turn these messages off on another machine that is running the rutime version of the app?

Thanks,
Lee2004

 

[ghudson]

You can turn the warnings off when needed [just make sure you turn them back on at the end of the routine].

Docmd.Setwarnings = False
run your query here
Docmd.Setwarnings = True

Or you can use the .Execute method to run the SQL and you will not see any messages when the action SQL is run.

CurrentDb().Execute "DELETE * FROM YourTableNameHere"

That command will delete all the records in the 'YourTableNameHere' table. You can easily add criteria to the SQL to only delete records that meet your criteria if you do not want to delete all records.