How to make Front End Application Menu - Access 2000

[Rich Anton]

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.

[PC Datasheet]

Re: How to make Front End Application Menu - Access 2000

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
resource@pcdata sheet.com

https://www.pcdatasheet.com

"Rich Anton" <antonr01@yahoo .com> wrote in message
news:4965c880.0 404220517.2b91c 5f7@posting.goo gle.com...[color=blue]
> 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.[/color]

[Albert D. Kallal]

Re: How to make Front End Application Menu - Access 2000

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/msaccess/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/articles/bapp97/chapters/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/articles/bapp97/chapters/ba15_3.htm

--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
pleasenonoSpamK allal@msn.com

http://www.attcanada.net/~kallal.msn