Create a button which links to the 'Create Query' function

[nicolenwn]

Hello all,

Many thanks in advance again for your expertise.

I need help in Microsoft Access VBA once again ):

I'd like to inquire if it is indeed possible to create a button that when it is clicked,
it opens the 'Create a query in design view' function.

I've tried using my current codes that opens queries instead, trying to tweak it so it can open to the 'Create new query in design view' function.

I need this because i'm currently trying to improve my user interface so i have a menu. On my menu it has the important buttons for work to be done. But i also need to include buttons so users can create their own query as and when needed. Thus the need for a button that can open the 'Create a query in design view' function.

Many thanks in advance for all the advice given, i appreciate it(:

Cheers and have a great day!
Nicole

[ADezii]

Try:

Application.Run "acwzmain.ssq_Entry"

[nicolenwn]

Thanks Adezill,

but is there any other way to do this. As i the solution you gave allows me to open queries, whereas what i was kinda lookinf for was a button to open the function "Create New Query in Design View" that has the same interface as one on the Database main windows.

[ADezii]

I'll look into further for you, but you may only be able to do this from the Database Window.