Hide Query on Run command

[BillMc]

My application uses many action queries that run as an Event Procedure. Following is one example:

DoCmd.OpenQuery "AutoQDate", acViewDesign, acEdit
DoCmd.SetWarnings False
DoCmd.RunCommand acCmdRun
DoCmd.Close acQuery, "AutoQDate"

Although I have reduced the size of the query window, it still is visible and flashes while running.

Is there a way to hide it and still have it open in design view? Is there a hide command? My queries are very large and it would be an enormous task to convert these queries to VB code. Thanks, Bill

 

[BoxHead]

Bill,

Have you checked the results of

   DoCmd.OpenQuery "AutoQDate"

With action queries, opening them in acViewNormal (the default) will actually just run the query without having to open it.

I tried this with a Data definition query that added a column to a table and an update query. Neither one of them had to open to run.



HTH
John

Use what you have,
Learn what you can,
Create what you need.

 

[BillMc]

Hi John, Thanks for the response. I will give this a try later today. Bill

 

[BillMc]

John, I tried removing the AcViewdesign.. and ran the query. It ran and ran. It just did not stop. According to microsoft Access help, an action query needs to be in design view to run. Bill

 

[BoxHead]

Bill,

Did you run the query or open the query?

Help also says that if you open an action query that returns no records, it will actually just run in the background.


Getting closer?
John

Use what you have,
Learn what you can,
Create what you need.