Switchboard vs Form

[franklinbukoski]

I had 12 buttons with macros opening 12 different forms all on one Form that
I titled startup and used as a switchboard.

An IT person told me I'd have quicker acces into the actual forms if I used
the Access switchboard, which I think turned out to be true (by a couple
microseconds)...but I can only have eight buttons on the switchboard, so it
takes longer going to another switchboard to find the form I want to enter
into.

Is there a better way of doing this?

 

[Jeff Boyce]

How long the forms take to open is more a factor of what's on the forms and
how many records they're tied to. My mind doesn't usually perceive
microsecond differences, so I couldn't tell you if a switchboard works
faster than a macro.

For just the reason (i.e., limitation) you gave, I use my own form rather
than a switchboard. Rather than macros, I use the DoCmd.OpenForm command in
code behind the button. You wouldn't even need to write the code, as the
command button wizard would do that for you.

Just one person's opinion...

--
Regards

Jeff Boyce
Microsoft Office/Access MVP
Microsoft IT Academy Program Mentor

 

[Tim Ferguson]

=?Utf-8?B?ZnJhbmtsaW5idWtvc2tp?=

I had 12 buttons with macros opening 12 different forms all on one Form

What _is_ the difference between that and a switchboard?

Tim F

 

[Bob Miller]

I prefer menubars. You can put all of your forms on it and with the use
of sub-menus - the possibilities are endless and they stay visible ALL
the time.
Right click in the menu/toolbar area adn then select Customize.
Go to Toolbars and select New and name it. Drag it up to the
menubar/toolbar area.
Select Commands and then move down to All Forms. Drag each form you
wan tto the new Menubar. If you right click on the form name you can
change the nasme and the appearence.
You would then tell Acces to load that Menubar on Startup.
You can add to, delete from, or modify the menu anytime by going to
customize.
This is a much quicker way of doing all of this. It would take me
about 2 minutes to add 20 forms to a new menubar. You to can do this
with practice.
Good luck,

 

[Brendan Reynolds]

=?Utf-8?B?ZnJhbmtsaW5idWtvc2tp?=


What _is_ the difference between that and a switchboard?

4.

Well, you did ask!

 

[franklinbukoski]

Bob,

Thank you so much, this MORE than meets my intent, and saves me much time.
Just AWESOME! Thank you!