Table showing when running query from command button

J

Jeff

Hi,

can someone please tell me how to run a query from a command button on the
form without a table showing the results pop up? i would like to be able
just to push the button and have the query run without having a table pop up
that in turn just close down. I have a report that shows the result. I am
using Access 2002.

Thanks for the help.

Jeff
 
J

JAdams

Run it in code:

Example:

DoCmd.RunSQL "UPDATE tblPI SET tblPI.Email2 = Date() WHERE
((tblPI.Pri_responsible)=1));"
 

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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Creating a Chart on form from selected data in query. 0
Opening a query from a command button 2
How to execute a command in VBA 2
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Run a query after selecting from combo box 3
Query to show details of dataset when one type of data is still blank 1
Passing a Control Value from a Form to a Query 2

Top