If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Switchboards
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 |
#2
|
|||
|
|||
Switchboards
Sounds good. Just build the two switchboards. Do you have a question?
"Lin Light" wrote in message ... 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 |
#3
|
|||
|
|||
Switchboards
I was using the build wizard and doesn't give a place to
name the switchboards -----Original Message----- Sounds good. Just build the two switchboards. Do you have a question? "Lin Light" wrote in message ... 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 . |
#4
|
|||
|
|||
Switchboards
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 "Lin Light" wrote in message ... I was using the build wizard and doesn't give a place to name the switchboards -----Original Message----- Sounds good. Just build the two switchboards. Do you have a question? "Lin Light" wrote in message ... 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 . |
#5
|
|||
|
|||
Switchboards
"Lin Light" wrote in message ...
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 |
Thread Tools | |
Display Modes | |
|
|