Switchboards

[Lin Light]

Need to have two switchboards running off the same
database. I need to have one switchboard that makes
available only reports "read only" , while the other is a
working system to record invoices, orders and fund
balances.
Lin

 

[Rick B]

Sounds good. Just build the two switchboards. Do you have a question?




Need to have two switchboards running off the same
database. I need to have one switchboard that makes
available only reports "read only" , while the other is a
working system to record invoices, orders and fund
balances.
Lin

 

[Lin Light]

I was using the build wizard and doesn't give a place to
name the switchboards

 

[Rick B]

Hmmm. I just tried it and see what you mean. I have a couple out there,
and I guess that I must have copied the table and form, then renamed them.
It looks like you would also have to go into the design view of the form and
change the source to the new table. The vba code also references the table
many times, so you'd have to do a find and replace to change the table name
there.

I'm suprised that the Switchboard Manager does not make it easier to create
two toally different switchboards.

Hopefully someone else will post a better solution.

After i built a few, I ended up making menus by building forms with buttons
on them and no longer using the Switchboard Manager, so I forgot what it
could and could not do.

Good Luck. Post a new thread if you don't get any other responses.

Sorry I could not be of more help.

Rick B


I was using the build wizard and doesn't give a place to
name the switchboards

 

[Peter De Baets]

Need to have two switchboards running off the same
database. I need to have one switchboard that makes
available only reports "read only" , while the other is a
working system to record invoices, orders and fund
balances.
Lin

We have a shareware product that enhances the MS Access-supplied
Switchboard. It's called "A Better Switchboard" and it allows the use
of multiple "Switchboard Items" tables/multiple switchboards among
other features.

You can find out more at http://www.peterssoftware.com/abs.htm

If you want to code it yourself, it's not that hard. You just have to
pass a switchboard items table name to the "FillOptions" and
"HandleButtonClic" routines.

Hope this helps,

Peter De Baets
Peter's Software - MS Access Tools for Developers
http://www.peterssoftware.com