How do I add Queries to a Switchboard in Access 2000?

J

J Rusche

My Switchboard has 2 levels. I want my queries on the 2nd level. For
example, user opens Switchboard, clicks on Queries, which goes to 2nd level
of Switchboard.

Level 2 contains the items, Step 1, Step 2, etc. (I want the user to run
through a process of Make-Table, Delete, and Append queries).

Thank you for you help. jr
 
G

Guest

hi,
Not sure what you mean by "levels"(another form maybe)but..

docmd.openquery "queryname", acnormal

You might want to look up the docmd.openquery in help of
more info.
you can add this to a button's click event or
a lable's double click event.
 
G

Guest

hi again
sorry i took so long to get back. I do work for a living
and had to do some stuff.
and sorry. no non-teckie way to do it. you will have to go
to design mode with the form and add a button to your
form from the toolbox. (a switchboard is just another form-
nothing special or magic about it) then in the button's
click event, put the code i gave you. just put the query's
name where i put "queryname" you will need a button for
each query.
and i have a feeling all this will be greek to you also.
sorry.
 
Top