How do I run a query with code?? 4

[egstatus]

Hi all,
I have a query that I want to execute in an event procedure [When the user click on a command buttom], the querry is a make table querry. [Query name, qMakeMasterTableByYear]

Is this possible ??
If yes, how??

Thanks

 

[HarleyQuinn]

Have a look at DoCmd.OpenQuery()

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[lespaul]

you do realize that you don't have to create a new table, right? If you have a saved query you can use that in the FROM clause of another query:

SELECT SomeFields FROM TableName WHERE SomeCriteria = True

then another query that uses qry1:

SELECT Field1, Field2 FROM qry1

Leslie

In an open world there's no need for windows and gates

http://www.ubuntu.com

 

[PHV]

You may also consider the DoCmd.runSQL method ..

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[dhookom]

Or how about:

CurrentDb.Execute "qMakeMasterTableByYear", dbFailOnError

Duane MS Access MVP
Now help me support United Cerebral Palsy

 

[HarleyQuinn]

Yep, several ways to skin a cat so to speak

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.