switchboard help?????

[guitarfunk24]

Ok so I have a switchboard that i put together and I have some buttons
that i added to it using the button wizard and they are carried to
each page of the switchboard. How do I just have them show up on the
first page of the switchboard no get carried through my switchboard.

 

[fredg]

Ok so I have a switchboard that i put together and I have some buttons
that i added to it using the button wizard and they are carried to
each page of the switchboard. How do I just have them show up on the
first page of the switchboard no get carried through my switchboard.

That Access built-in switchboard is just one form with it's 8 buttons
being made visible or not, depending upon the Switchboard Manager's
design. The buttons you added, therefore are not in the manager's
design. While you can set them to visible or not using the
SwitchboardID value, it really is a long way to go to solve a simple
problem.

To show the button just on the main menu add this just after the End
If of the Sub FillOption procedure:

Me.CommandButtonName.Visible = [SwitchboardID] = 1

Better if you simply create a new switchboard(s) using unbound forms.
You can add as many buttons as you wish to whichever switchboard form
you wish. If you use the Command Buttons wizard to add the buttons,
Access will even write most of the code for you. You'll have more
control over it's appearance and function, and maintenance will be
simpler.

 

[bsmith59]

Ok so I have aswitchboardthat i put together and I have some buttons
that i added to it using the button wizard and they are carried to
each page of theswitchboard. How do I just have them show up on the
first page of theswitchboardno get carried through myswitchboard.

If you want to look at a free alternative
to the Access Switchboard, you can try the Access UI Builder. It has
a more modern look and feel, free for non-commercial uses.
http://www.opengatesw.com/products.aspx

Brandon Smith-Daigle
http://accesspro.blogspot.com (access tips for non-programmers)