open query with VB code

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

Guest

I want to open/run an update query from a command button (comand28) in a form
(accountingform).

I am a beginner and need the the code to do that?

Thanks
 
One more thing
If you don't want any messages to be displayed when the query runs, the use
that

Docmd.SetWarnings False
Docmd.OpenQuery "QueryName"
Docmd.SetWarnings True
 
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

Parameter Query Won't Run 0
Multiple queries with same filter problem. 11
Refresh method in VB doesn't pull most recent records 1
Access Open Form with WhereCondition 6
refresh or close query 1
Which CPU I should choose for coding and multitasking? 0
Running a query from vb without opening in access 1
Queries have stopped displaying error messages 1

Back
Top