No appear message box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like when the user, who use my database, click a button to run a
querriy doesnot see any message box. How can i do that?
 
Andreas,

Is this an action query (append, update, delete, make-table)? Are you
referring to the warning "you are about to append/delete modify etc"?

If yes, and you are running the query through a macro, precede the
OpenQuery action with a SetWarnings action, argument False; then
supersede it with another SetWarnings, argument True to restore warnings.

If you are running an action query in VBA code, like:

DoCmd.RunSQL strSQL

then change that to:

CurrentDb.Execute strSQL

HTH,
Nikos
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fill automatic a table with the data of a queery table 3
Oversensitive touchpad on modern laptops 0
Excel Providing user message when RED X clicked & properly closing application. 2
Need to show result in message box 1
How to remove stuff that appears when I click on the windows button on the bottom left of my screen? 2
Probelem with Macro 0
Result in message box 3
Disable Pop Up Box 4

Back
Top