Solved

Creating Menus in MS Access

Posted on 2006-07-14
8
1,851 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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

920 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now