I have gone into tools - Options... - Confirm:
Record Changes
Document Deletions
Action Queries
These have been unchecked meaning the users do not get questioned before running these queries... BUT users still get questioned regarding, 1)"Will not be able to undo update to tables..." & 2)"19 records were lost due to key violations."
IS there any way to remove these messages for the users. I do not want users to get ANY messages...

Thanks in advance....

What you need to do is to add this code just before the code you want to run that will generate those message boxes.

Docmd.SetWarnings False

But, remember to do the opposite at the end of any operation you use that in, or REAL confirmations that you WOULD like will NOT show up at all (for example you accidentally hit the Delete Key while your table is selected in the Db Window. If you have Warnings Set False at that time, it will be deleted without a confirmation.

So always put a:

Docmd.SetWarnings True

at the end of any code where you have set them false.

BL
hth
http://www.access-programmers.co.uk/ubb/smile.gif

It worked perfectly, thanks alot...
Regards...