

Converting form to Switchboard in Access 2007
Started by
tiroshii
, May 11 2010 05:55 AM
#1
Posted 11 May 2010 - 05:55 AM


#2
Posted 11 May 2010 - 06:48 PM

Hello again tiroshii,
Yes, you can set any form to display when the database is opened. The Switchboard is a "form" object, and is limited to 8 buttons on it, so if you want to give the user more than 8 options, creating your own "Switchboard" is a good option.
If you have a form you want the user to see upon opening the file you will need to find a path similar to Options window (probably in the Office Orb) > Current Database > Application Options > then find an item similar to Display Form (should be a drop down box), then select your form and then close and reopen your database (the selected Form should now be open).
You may want to set that Forms properties to remove the scroll bars and/or record navigation buttons if don't want them visible on that Intro Form.
I'm sure you can also use code to do this as well, but if you just want to have one form open at launch, this is the quickest method.
Hope this helps,
dm
Yes, you can set any form to display when the database is opened. The Switchboard is a "form" object, and is limited to 8 buttons on it, so if you want to give the user more than 8 options, creating your own "Switchboard" is a good option.
If you have a form you want the user to see upon opening the file you will need to find a path similar to Options window (probably in the Office Orb) > Current Database > Application Options > then find an item similar to Display Form (should be a drop down box), then select your form and then close and reopen your database (the selected Form should now be open).
You may want to set that Forms properties to remove the scroll bars and/or record navigation buttons if don't want them visible on that Intro Form.
I'm sure you can also use code to do this as well, but if you just want to have one form open at launch, this is the quickest method.
Hope this helps,
dm
#3
Posted 17 May 2010 - 04:51 AM

Thanks for your help, this will do nicely.
Similar Topics
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users
As Featured On:






