By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,844 Members | 1,859 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,844 IT Pros & Developers. It's quick & easy.

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

P: 23
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
Jan 22 '10 #1

✓ answered by ADezii

Try:
Expand|Select|Wrap|Line Numbers
  1. Application.Run "acwzmain.ssq_Entry"

Share this Question
Share on Google+
3 Replies


ADezii
Expert 5K+
P: 8,615
Try:
Expand|Select|Wrap|Line Numbers
  1. Application.Run "acwzmain.ssq_Entry"
Jan 22 '10 #2

P: 23
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.
Jan 27 '10 #3

ADezii
Expert 5K+
P: 8,615
I'll look into further for you, but you may only be able to do this from the Database Window.
Jan 27 '10 #4

Post your reply

Sign in to post your reply or Sign up for a free account.