Menu Buttons

[yarnoss]

Hi!, Fairly new to access using access2000.I am trying to create a Service call Program so i can install onto my PDA. What i am trying to achieve once i create this database i want this database to launch automatically onto a Forms format with a Menu Screen with Command Buttons so all i need to do is click on the button and it directs me onto the job card. eg:- Pending jobs,All Service Jobs,Customers,Suppliers,(with customers and suppliers details) I think if i take this approach then i won't need to train my employees fully on Access just a simply course on how to use this application created on access
If anybody has any other ideas they are welcomed!

Please try and keep answer simple

 

[SydneyGeek]

There's a lot in this but here's the helicopter view.
Opening to a set form -- easy. Create the form first and save it. Then Tools | Startup, pick the form from the drop-down list and it should be the first thing the users see when the db is opened.
Buttons to show you stuff -- Create the queries or reports that you need. Then go to your main form in design view, drag a Command Button onto the form with the Wizards activated, and follow the prompts. You can make the buttons open forms, queries or reports, without having to write any of the code yourself.
VERY brief, but you asked to keep it simple... If you need help on the specifics, post back

Denis

 

[yarnoss]

Thank you for the information but i spent all weekend searching the net found a starting point!! What i need to achieve is to understand how to create application switchboards. If you assist me on how to create or know anywhere on the net that explains how to create switchboards with 3 buttons and and 3 switchboard forms.

cheers mate!!!!

 

[SydneyGeek]

Hi yarnoss,

the Switchboard is built using Tools | Add-Ins | Switchboard Manager. It's mostly point and click. To create a new page you need to select a command like New Switchboard or New Page (I forget which). To add lines to a page you select the switchboard name, select Edit, and then New Item or Add Item. You then have options to open forms or reports, run queries, and others.
Limitations: You can't exceed 8 items per switchboard page. And if you have too many pages, there will be so many nav buttons that there's not much room for useful operations Still, a pretty good way to set up navigation for a small database.

For more info, try the MS knowledge base or run a Google search.

Denis