How do I create a menu in access to link users through to the app.

S

Supahels

I have created a number of forms and would like to create a front screen menu
to link users through to the right form - just to make the application look
more pallitable to users. I have seen this done many times as a user but
can't figure out how its done. Can you help? Thanks.
 
G

Graham R Seach

Select the Tools menu, then select Database Utilities --> Switchboard
Manager.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
G

Guest

hi,
create an unbound form. put buttons on it or lables(which
have a double click event.) put the form name as the
button or lable captions.
then behind the button or lable you can use the docmd
object to run queries or reports or open other forms.
I have a main form with 6 lables. double click any lable
and 1 of 6 catagory forms opens. on the catagory forms in
have buttons to run queries, reports and opne other forms.

Private Sub lblSell_DblClick(Cancel As Integer)
DoCmd.OpenForm "frmSell"
Me.Visible = False
'DoCmd.Close acForm, "frmMainIntro", acSaveNo
End Sub
2 ways to go. open one form and close the main form or
just make it invisible.
and you can get fancy. on the main and catagory forms i
use the mouse move event to light up all the lables as you
mouse over then. each form has a picture as background.
the main forms has a picture of all the company employees.
the others have pictures of company events. some were
taken around the plant and offices.
 
Top