switchboard w/ multiple pages

[Guest]

when using a switchboard w/ multiple pages, how do i go to each page without
having to close the database and reopen. if I close the switchboard page I
am currently using, it closes everything.

 

[Jeff Conrad]

when using a switchboard w/ multiple pages, how do i go to each page without
having to close the database and reopen. if I close the switchboard page I
am currently using, it closes everything.

Are you using the built-in Access Switchboard Manager to build
your menu system?

 

[Guest]

Yes, I am. It only allowed me 8 buttons on the first switchboard and I
needed much more than that so I created new switchboard pages. The
switchboard is set to open at startup but I need to manuever between 4 pages
of switchboards.
Thanks for your help.

 

[Jeff Conrad]

Yes, I am. It only allowed me 8 buttons on the first switchboard and I
needed much more than that so I created new switchboard pages. The
switchboard is set to open at startup but I need to maneuver between 4 pages
of switchboards.

What you need to do is set up each switchboard page with the options you want.
Then on your main one you choose the option "Go To Switchboard" command
and select the name of that other menu.

For example, you may have a switchboard page called "Reports Menu" that opens
various reports in your database. The main switchboard page would have an option
called "Go To Reports Menu." Using the wizard you would select the option
"Go To Switchboard" and choose the Reports menu name. On the main page
clicking that option will take you to the reports menu.

For each sub-menu make sure you have an option that can take you back to the
main page. Again, you would choose "Go To Switchboard", but in this instance
select the name of the main page. Follow me?

Here are some study links on the Switchboard Manager which may help you:
(Watch out for any line wrapping on these links)

http://msdn.microsoft.com/archive/d...dnaraccessdev/html/ODC_CreateASwitchBoard.asp
http://office.microsoft.com/en-us/assistance/HP051887321033.aspx

http://office.microsoft.com/en-us/assistance/HP051887361033.aspx


In addition, the built in Access templates also use the Switchboard
Manager. You could load one of those for study as well.

If you still have problems, post back.

 

[Guest]

Thanks Jeff. I will try this. I am also going to attempt making my own
switchboard after reading all your comments to other questions - it may be
better to make my own. I did not even know I could do that. This is my
first time to visit this site...it is great -very very helpful.

 

[Ed]

If I may: I have a switchboard page that uses a form with 6 Tabs accross the
top.
Each tab is a different set of records and commands. So in effect I have 6
switchboard pages that I just tab through on opening screen. Using Access XP
by the way. Ed

 

[Jeff Conrad]

Thanks Jeff. I will try this. I am also going to attempt making my own
switchboard....

Ok, no problem.
The Switchboard Manager is just one way to create a main launch form.
You are only limited by your imagination if you custom create something.
You will also have more control over it if you design something yourself.

......after reading all your comments to other questions - it may be
better to make my own.

Reading all my other comments?????

What other comments Catherine?
This is my first time here as well.

I did not even know I could do that.

Yep, endless possibilities for you.

This is my first time to visit this site...it is great -very very helpful.

You must come back more often Catherine and join the Collective.
Resistance is futile.....

 

[Guest]

Thanks for the comments Ed. I just made the tab control with several control
buttons on each tab . The only thing I don't like is that I would like each
tab to be colored differently and so far I have not discovered how.
I can not color the control buttons either.

 

[Jeff Conrad]

Thanks for the comments Ed. I just made the tab control with several control
buttons on each tab . The only thing I don't like is that I would like each
tab to be colored differently and so far I have not discovered how.
I can not color the control buttons either.

For colored tab control pages, see Sensei Stephen Lebans for all things
magical. Specifically:
http://www.lebans.com/tabcolors.htm

Here are several options for you on different command button styles/colors:

1. Use a label instead. Labels have click events and can be made to look like
a command button with some work.

2. Sensei Stephen Lebans has an example database that shows how to set
a command button back color and more:
http://www.lebans.com/cmdbutton.htm

3. There's a nice "Color Command Buttons" download at this site:
http://www.candace-tripp.com/access_downloads.htm

4. Some simple colored button examples that can be copied into your
application are available at:
http://www.peterssoftware.com/clrbtn.htm

5. A shareware version of Button Painter for MS Access is available
at this web site:
http://www.peterssoftware.com/bp.htm

 

[Guest]

Thanks Jeff. I am creating this database to be shared by many others. If I
download and use the features you mentioned...will I still be able to share
the file or will everyone need the download?

 

[Jeff Conrad]

Thanks Jeff. I am creating this database to be shared by many others. If I
download and use the features you mentioned...will I still be able to share
the file or will everyone need the download?

Which download are you referring to?

For sharing a database file you would need to split the database into a
back end (BE) file which would contain just the tables and reside on a
server. The front end (FE) file would have links to the BE tables and
contain all the queries, forms, reports, and modules. You would make
one master FE file and then give each person a copy of that file to put
on their own workstation. So in essence, whatever you add into your
database would be the same for everyone.

 

[Guest]

I am creating this database to be shared by many others. If I
download and use the features from lebans.com...will I still be able to share
the file or will everyone need the download?
: For colored tab control pages, see Sensei Stephen
Lebans for all things

magical. Specifically:
http://www.lebans.com/tabcolors.htm

I am creating this database to be shared by many others. If I
download and use the features from lebans.com...will I still be able to share
the file or will everyone need the download?

 

[Jeff Conrad]

I am creating this database to be shared by many others. If I
download and use the features from lebans.com...will I still be able to share
the file or will everyone need the download?
http://www.lebans.com/tabcolors.htm

As I mentioned, if you split the database and give each person an identical
copy of the FE file, then everyone will have the same *things.* The other
people will not have to do anything other than open the file.

If it helps, think of it this way. If you close your database, go to Windows
Explorer, make a copy of it, and place the second copy in a different directory,
will the second file look and behave just like the first file? Sure, it will.
It is just a "cloned" copy if you will so everything works just fine. By giving
each person a copy of your master FE file, each person's database will have the
same functionality as your file.

 

[Guest]

Hi. How did you made a tab in the switch board?

Is that tab fix ou variable? does it change for each page onthe switchboard?

regards,
Marco