New Query opens as a popup

[Arry]

I have a database running with the application window hidden and would like to give users the option of creating querys based on the built in query wizard.

The query when opened using a button on a form is not displayed on screen because the app is hidden. I need to somehpw set this to a pop up!!!

Does anyone have any ideas on how this could be achieved.

 

[Mile-O]

Wouldn't you put it on a form, set it to datasheet view, and set the form's properties (PopUp and Modal) to Yes?

 

[Arry]

i want the query in design view so the user can create it themselves. I cannot do that with a query can i. It is a new query with nothing in it until the user selects tables etc...

 

[Mile-O]

Ah! Understand you now. The whole idea of having a query editor is that you can design your queries and have their definition saved prior to runtime.

To open the Design grid, you need to specify a query's name. Ergo, it can't be done.

The nearest you can get is:

DoCmd.RunCommand acCmdNewObjectQuery

 

[Arry]

okay thanks anyway.

 

[Rich]

Is it a good idea to let users create their own queries?

 

[Arry]

If they cannot change the data in the tables then i don't see any reason why not. It just means that capable access users have more freedom to extract the data they want.

 

[Rich]

Simply because they will fill the db with redundant queries that will bloat it.

 

[Arry]

Just set the queris to delete after X days and informt the user of this when it is created. The dB Administrator can keep an eye on it!

Unfortunately as per previous it ain't possible. Bummer!!