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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Thank you for responding so quickly. I'm new to Access. By levels I mean, I
have a Main Switchboard. Clicking an option on the Main Switchboard takes me
to another switchboard (i.e. I have an option on the Main that says
"Reports'. A second switchboard is titles Reports, and lists every report I
created.)

I'm sorry, but everything you wrote is "Greek" to me. I am a user, not a
programmer. I'm learning Access. Is there a non-techie way to add queries
to a switchboard? jr
 
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.
 
Back
Top