Warning Messages

[marklord]

I am currently developing a database to record a number of orders, delivery tickets and invoices which come into a company. To perform calculations etc. tables are deleted, appended and primery key violations occur etc. This is exactly what I want to happen as it ensures all dtaa remains correct, however, when I run the macro which runs each of the queries I receive a number of warning messages asking if I am sure I want to continue running a particular query. As the end-user of this system will not be a confident computer user I am concerned that they will press 'No' causing problems later on.

I have turned some of the warning messages off by deselcting the tick boxes in 'Tools>Options>Edit/Find>Confirm', however this is not ideal since when the database is moved to another computer these settings are lost, plus some warning messages still remain.

My question is, is there a method of turning these messages off/automatically pressing Yes/removing all buttons but yes?

Cheers,


Mark

 

[namliam]

I am almost sure that by now Mile has something about this in the FAQ somewhere....

But here goes:
1) Dont use macro's
2) In vba use either
Docmd.setwarnings false
docmd.runsql "qryName"
docmd.runsql "update sql here"
docmd.setwarnings true

Or (which is better)
Currentdb.execute "qryName"
Currentdb.execute "update sql here"

GL & Regards