Form to BRING TOGETHER Other Forms/Queries

  • Thread starter Thread starter kev100 via AccessMonster.com
  • Start date Start date
K

kev100 via AccessMonster.com

I'm fairly new to Access, but, with some great help from this board, have a
pretty good project going.

Currently it consists of several queries and a few reports. Users are
accessing them via Macro shortcuts that have simply been copied to their
desktop.

However, there are several now and things would be more orderly if I could
have a form with buttons that activated each item.

This way, it would be more like an actual program rather than a collection of
files.

Ideally, they could have a Form with buttons that simply remained open. When
they needed the results of a certain query or report, they'd just have to
click the correct button.

Is something such as an "organizer screen" available in Access?

Thanks very much,
Kev100
 
Yes, it is called a Switchboard. It is very easy to use. From you main
Access Menu,
Tools, Database Utilities, Switchboard Manager. It is pretty intuitive;
however, be aware it will only allow 8 command buttons on one page, so when
you have 7 actions identified on a page, make button 8 open a new page.
 
Klatuu said:
Yes, it is called a Switchboard. It is very easy to use. From you main
Access Menu,
Tools, Database Utilities, Switchboard Manager. It is pretty intuitive;
however, be aware it will only allow 8 command buttons on one page, so when
you have 7 actions identified on a page, make button 8 open a new page.
Click to expand...
Cool! Thanks very much.

If I understand the 8 button per page limitation correctly, I'll use the
first page for the "Menu Buttons."

Grouping them into categories will actually work best.

Do you know if the buttons can be used to launch other programs?

I have a litttle Bat file that needs to run from time to time to copy some
needed files (I think a VB program be able to do the same thing).

Thanks very much for the info.
 
Not directly from the switchboard. What you can do it run a Macro from the
switchboard. One of the options in a Macro is RunApp. For the RunApp
action, you enter the command line to execute. So, create a macro that will
run your bat file, then run the macro from the Switchboard.

By the way, you plan to use the first page as menus is a good idea.
 
For launching of reports and the like I often just build a simple form,..and
place some buttons on it to launch the appropriate form, or repot.

There is some screen shots of what I mean:
http://www.members.shaw.ca/AlbertKallal/ridesrpt/ridesrpt.html

If you don't want to use forms...then you *can* consider building menus.
Here is some screen shots of ms-access with menus....

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

How you build these nice prompt forms is really only limited by your
imagination...
 
Back
Top