Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Creating Menus in MS Access

Posted on 2006-07-14
8
Medium Priority
?
1,891 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 19

Accepted Solution

by:
Richard Daneke earned 400 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 400 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
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 
LVL 5

Assisted Solution

by:macsta
macsta earned 400 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 85

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 400 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 400 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: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

926 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