New Query

[k209310]

I have a switch board in a Db - I would like one of the options on the switch board to be "Create New Query2 Does anyone have any idea of anyway to create a completly new query either using code or any other way?

any adive is greatly recieved.

 

[Mile-O]

Are you trying to make your own query builder whereby the user selects all the criteria and you are creating the SQL in the background?

 

[k209310]

nothing even that complicated. something similar to clicking the "Create Query in Design View".

I just need that option available to the users but when the Db goes live the Db window wont be available to the users so i need to put it on the switchboard.

 

[Rich]

If the db window isn't visible, then neither will any query.

 

[k209310]

i am starting the databse with the switchboard and not showing the Databse window. All of other queries in the database work OK.

Does it mean i cannot create one in these circumstances?

 

[Rich]

I assumed your switchboard was set to PopUp and there was no access to the db window, if you close/hide the switchboard then you can view/create queries

 

[k209310]

i think ill just have to leave it. I was hoping there was someway of opening of creating a new query from the switchboard using code or a macro or something.

Nevermind

Cheeers for the replies

Chris