Single Front-End Interface for Reports and Forms

[Laura]

I have several reports and forms that I want to be accessed through a single
menu.
What's the best way to do this? Using forms, subforms, data access page or
what?

 

[Keven Denen]

I have several reports and forms that I want to be accessed through a single
menu.
What's the best way to do this?  Using forms, subforms, data access page or
what?

Most commonly, you'll see people using forms as their navigation menus
in Access. You could also build toolbars/menus/ribbons to act as your
navigation tool.

Keven Denen

 

[Clif McIrvin]

I have several reports and forms that I want to be accessed through a
single
menu.
What's the best way to do this? Using forms, subforms, data access
page or
what?

Most commonly, you'll see people using forms as their navigation menus
in Access. You could also build toolbars/menus/ribbons to act as your
navigation tool.

Keven Denen


----------

<quote>
Also, here's some discussion from Albert D. Kallal showing how he uses
customized menus instead of forms for navigation...

If you want to see some sample menu bars, and why I use them, you can
read
the following:

http://www.members.shaw.ca/AlbertKallal/Articles/UseAbility/UserFriendly.htm

</quote>

taken from this thread:

http://groups.google.com/group/microsoft.public.access.forms/browse_thread/thread/4dcde9fd823c6d54

[An earlier -- Jan '07 -- post from Albert showing VBA enable / disable
of individual menu commands:
http://groups.google.com/group/microsoft.public.access/msg/eda692d994ec1f67 ]

 

[Daniel Pineault]

There are different approach to anything and it depends on your needs. What
are yours? Is this for just you or is it being deployed to numerous users?
Do they need to be categories? You don't give us much to go on to guide you.

One of the simplest methods would be to create a switchboard (form) with
buttons to open your forms and reports.

If you google MS Acess Switchboard, you will find more information on the
subject. There are numerous free templates available on the web to give you
a head start or MS Access has a built-in switchboard utility (Tools -
Database Utilities - Switchboard Manager).
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Mark Andrews]

Most of my Access2003 and earlier applications use buttons on forms for
navigation and generally have one form where all the reports can be run.
Either use consistant navigation on all forms or have navigation from a
central area (that stays open).
In Access 2007 I tend to use the ribbon for navigation buttons.

If I got a user database and they used a switchboard and got used to it I
would probably continue to use that method.

My two cents,
Mark
RPT Software
http://www.rptsoftware.com