Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Creating Menus in MS Access

Posted on 2006-07-14
8
1,858 Views
Last Modified: 2008-04-22
HI,

I need to create a menu for the a database in MS Access. The menu should give the user the option for which report to pick. Please let me  know how to do this in MS Access. Iam a beginner in MS Acess.

Thanks
KK
0
Comment
Question by:kkmayi
8 Comments
 
LVL 18

Accepted Solution

by:
Richard Daneke earned 100 total points
ID: 17111198
The quickest way for a menu is the Swichboard.
With your database open, choose Tools, Database Utilites, Switchboard Manager...

The first time, Access will comment that no switchboard items are found and asks if you want to create one.  Choose Yes.

The Switchboard permits up to 8 buttons on a form.  If you need more than that, use a button to open the next (new) switchboard and save a button on new switchboards to reopen the first.

Edit the default switchboard and use New to add buttons.  The form makes it easy - use a button to open a form, open a report, run macros, etc. and even to close the database (although it will not close Access)
0
 
LVL 65

Assisted Solution

by:rockiroads
rockiroads earned 100 total points
ID: 17111210
r u talking about menus u see on the toolbar?

right click on a toolbar, and create your own menu from there

i.e click New, enter name
a blank menu appears
select "Commands" tab
scroll down to All Report, select that
u see your list of reports on the right hand side
simply drag to your menu



OR

r u talkng about a menu on a form?
0
 
LVL 5

Expert Comment

by:macsta
ID: 17114889
I am guessing what you are after is a drop down menu with a list of reports that open once you have selected them?

I have uploaded a demo of what I think you want to:

http://www.4shared.com/file/2529825/a73d64e2/report.html

What is there is a dropdown menu that opens the selected report. the report list is taken from a table and is easily updateable.

its stored in report.zip and is perfectly safe.

the main form has the dropdown and a some brief information as to how to get the same in your own database..

Hope this helps..

Mac
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 5

Assisted Solution

by:macsta
macsta earned 100 total points
ID: 17114902
http://www.4shared.com/dir/590378/6020c229/sharing.html

is the correct link sorry, password is mac

I think you may need to register to download..

nothing is ever just simple :)

Mac
0
 
LVL 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 100 total points
ID: 17122122
Here's an Access 2000+ sample of buildnig traditional Office-style menus:

www.infotrakker.com/ProgSamples/Menus.zip

This is basically what rocki has suggested and also shows how to use the OnAction command to run code when the user clicks an item.
0
 

Assisted Solution

by:peter_chong
peter_chong earned 100 total points
ID: 17128239
Dear friend,
You may create some buttons in your access form.
Single click on the button control in design view.
Press F4 to call the properties.
Goto event tab in properties.
Scroll and click on the on_click.
Choose "Code Builder" by clicking the ... button.
Enter the following code to the on_click event.
e.g:
Private Sub Command0_Click()
  DoCmd.OpenReport "YourReport Name", acPreview
 'Your Report Name is the name of your report in Project Explorer,
'Press Ctrl-R in the code view (View Menu->Code) to call up the Project Explorer
End Sub

Regards,
Peter

0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question