Im currently Developing a Database Program. One of the requirement is to have a make- table query. In that case if I run the make-table in my program MS Access Automatically ask "You are about to run a make-table query that will modify data in your table". I read in one of my MS Access Book. to eliminate the "Prompt Messages" go to Option Menu --> Edit/Find then unchecked Record Changes, Documents Deletions and Action Query. The problem is, my Program is Multiple User. almost 100 users and some users are in the other branch since Access is not a big File I email the Program to the other users. and It very hard to change the settings on by one in the Option Menu ans its not cool for them to instruct and change the settings in Option Menu.

Is there a possible solution to eliminate prompt messages in MS Access.

Thanks in Advance

Elmer

A simple solution would be to create a macro.

Echo = No
SetWarnings = No
OpenQuery = [Query Details]
SetWarnings = Yes
Echo = Yes

Basically run the macro instead of directly running the query, if you have any command buttons assigned to run the query change them to run the macro.

Ben :)

Or if you choose to add this to VBA code...

DoCmd.SetWarnings False
DoCmd.OpenQuery "your query"
DoCmd.SetWarnings True

Kenny Alligood

Yeah! It works Thanks Kenny and Ben. I really appreciate your help.

Elmer Espinosa