run or execute query

[matrixknow]

I have done it ones, but looking now again how to do this.
From in your code how can you execute a make table query.
It is something with a .execute. I know how you can execute an sql.

 

[PHV]

Either DoCmd.RunSQL "SELECT ... INTO ... FROM ..."
or CurrentDb.Execute "SELECT ... INTO ... FROM ..."

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

 

[matrixknow]

I added a parameter date (he gets that from a textfield from the form) to my query, its a make table query. If I run the query manually, he runs fine. If I try to do the same via my code I got the typical error message "to few parameters".
This is a real strange access problem. I think I should ask the user to run the query manually.

 

[PHV]

run the query manually
What about DoCmd.OpenQuery ?

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

 

[matrixknow]

or someone should show me the light in this darkness

 

[PHV]

To execute a parametized action query:
Dim db As DAO.Database
Dim qdf As DAO.QueryDef
Dim prm As DAO.Parameter

Set db = CurrentDb
Set qdf = db.QueryDefs("NameOfQuery")
For Each prm In qdf.Parameters
prm.Value = Eval(prm.Name)
Next prm
qdf.Execute

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