By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,651 Members | 1,694 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,651 IT Pros & Developers. It's quick & easy.

How to make Front End Application Menu - Access 2000

P: n/a
I am a newbie to Access. I have used Lotus Approach much over the
years, but not Access. What I am trying to do is to create an opening
screen with a bar menu that will basically allow me to select what I
want to do, whether it be to generate a specific report or enter data
to a specific form or run a specific macro. It would be great if this
screen would act as the main interface screen, and that after closing
the selected form, report, macro, etc., I would return to this menu.
I have read the help file, but it is not clear how to do this. (In
LOTUS Approach, it's a no-brainer.)

Can someone help me out here.
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
It's also a no-brainer in Access once you know what to do. First, click on
View - Toolbars - Customize and explore there. You create either a Menubar or a
Toolbar and then place single use buttons or menu buttons on them. Both
processes are click and drag. Once you have a single button or menu button, you
right click on it to get to the properties. You put the caption in here and
where it says Action Item you enter something like:
=OpenMyForm()
This is a function call and so you create the function in a standard module. The
function looks like:
Function OpenMyForm()
DoCmd.OpenForm "MyForm"
End Function
When you enter the action item, it MUST start with '=', be the same exact name
as the function in the standard module and include the opening and closing
parens. (I frequently forget the parens and have to go back in and add them.)

Experiment a little and you will quickly get the hang of it!

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Rich Anton" <an******@yahoo.com> wrote in message
news:49**************************@posting.google.c om...
I am a newbie to Access. I have used Lotus Approach much over the
years, but not Access. What I am trying to do is to create an opening
screen with a bar menu that will basically allow me to select what I
want to do, whether it be to generate a specific report or enter data
to a specific form or run a specific macro. It would be great if this
screen would act as the main interface screen, and that after closing
the selected form, report, macro, etc., I would return to this menu.
I have read the help file, but it is not clear how to do this. (In
LOTUS Approach, it's a no-brainer.)

Can someone help me out here.

Nov 12 '05 #2

P: n/a
To see a sample application with a custom menu bar..and how it hides all of
the ms-access interface.

Try downloading the 3rd download at:

http://www.attcanada.net/~kallal.msn...s/DownLoad.htm

You can also make a "launch pad form"..and this refereed to as a
switchboard. You should give this a try.

in a97...tools->add ins->switchboard manager.

In a2000 and later...

tools->database utilities->switchboard manager.

And, for a detailed tutorial on creating customer menu bars...check out:

http://www.microsoft.com/Accessdev/a...ers/ba01_6.htm

Also, the term "front end" when speaking of ms access is a term usually used
when you are talking about a split database. (while I did understand your
use of the term "front end"..it does have a specific meaning in ms-access).
If you plan to do any kind of development of a applications in ms-access,
then you need to lean about his concept. Check out:

http://www.granite.ab.ca/access/splitapp.htm

http://www.microsoft.com/accessdev/a...ers/ba15_3.htm
--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
pl******************@msn.com
http://www.attcanada.net/~kallal.msn
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.