How to make main switchboard?

[Guest]

Guys! please help... i finished doing Tables, Queries, Reports. What are the
next step. I want to make Main Switchboard but i don't know how to do it. I
tried it in Switchboard Manager but still it is not working.

Please help me......

 

[Shiller]

Guys! please help... i finished doing Tables, Queries, Reports. What are the
next step. I want to make Main Switchboard but i don't know how to do it. I
tried it in Switchboard Manager but still it is not working.

Please help me......

Tools > Database Utilities > Switchboard Manager > Edit (or New...)
That will take you to the Edit Switchboard Page, there you can use the
buttons on the right for example "New" to add new command to open your
forms, or "Edit" to edit current command, from this point on
everything is straight forward. Keep in mind that you're only allowed
8 commands on the Switchboard.

Shiller Calixte

 

[Shiller]

Tools > Database Utilities > Switchboard Manager > Edit (or New...)



That will take you to the Edit Switchboard Page, there you can use the
buttons on the right for example "New" to add new command to open your
forms, or "Edit" to edit current command, from this point on
everything is straight forward. Keep in mind that you're only allowed
8 commands on the Switchboard.

Shiller Calixte

One more thing is to run the Compact and Repair utility after creating
your commands:

Tools > Database Utilities > Compact and Repair Database

Shiller Calixte

 

[fredg]

Guys! please help... i finished doing Tables, Queries, Reports. What are the
next step. I want to make Main Switchboard but i don't know how to do it. I
tried it in Switchboard Manager but still it is not working.

Please help me......

I would strongly suggest that you create your switchboard using an
unbound Form and adding Command Buttons as needed.
You'll have more control over the switchboard (compared to using the
built-in switchboard manager) and are not limited to 8 buttons.
If you use the Command Button wizard when adding command buttons,
access will even write most of the code for you. Maintenance will be
much simpler.

 

[Linq Adams via AccessMonster.com]

I have to agree with Fred! An unbound table is a gazillion times more
flexible than a Manager generated Switchboard! If you've created an app with
multiple tables/queries/forms, take the little bit of extra time necessary to
do this part right!

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com

 

[BruceM]

That is "unbound form" rather than "unbound table", of course.

 

[Shiller]

I would strongly suggest that you create your switchboard using an
unbound Form and adding Command Buttons as needed.
You'll have more control over the switchboard (compared to using the
built-in switchboard manager) and are not limited to 8 buttons.
If you use the Command Button wizard when adding command buttons,
access will even write most of the code for you. Maintenance will be
much simpler.

I agree with you Fred, creating your own is more flexible but for
novice developers or students it's still a good start despite its
limitation.