Question Front page to my Database

[Abbosy]

Hi there everyone

I need my Database to have an access/front page that I can use it as an entrance for the user to select where they want to go or what to do after.
It's like a page that I supply it with buttons to access all/most the forms in the database.
How can I go about this and what is the right name for it?

Thanks in advance

 

[AlexHedley]

You can just create an unbound Form, just call it Main Menu, set it as your startup Form in Options.
Then you can add buttons, using the wizard, that will open other Forms you've created.

 

[CazB]

... or depending on which version of Access you are using, you could use the Switchboard Manager tool to build a Menu / Switchboard for you?

 

[Abbosy]

Hi Alex Hedley

This is great. I will do it this way.

Many thanks for your help

 

[Abbosy]

Hi CazB

Many thanks for your reply. I really appreciate it. The only think that I don't know where to find Switchboard.

 

[CazB]

It should be under the developer tab, if you're using 2007 like me

Otherwise - I'm not sure! On earlier versions, it could be under Tools?

 

[Abbosy]

Many thanks CazB. I couldn't find it and I am using Access 2013. It is quite similar to 2010

 

[humph]

Be careful using the Switchboard manager especially if you expect to have more than 8 buttons on a page (think its 8). The switchboard manager restricts you to that and you then loose a forward button and a back button on the sub menus.

I have found from bitter experience that it is better to use a blank form and create the buttons either with the wizards or preferably VBA. It gives you so much more flexibility.