Switchboard Management

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can anyone point to a sites that would have coding to create my own
switchboard manager? The built-in one is nice but it only allows 8 buttons
and I have come across several instances where I could use more.
TIA
 
Cyberwolf said:
Can anyone point to a sites that would have coding to create my own
switchboard manager? The built-in one is nice but it only allows 8 buttons
and I have come across several instances where I could use more.
TIA
Click to expand...

I find it easier to edit the form and table myself. A quick look at the code
will show what constant and indices will have to be changed.

Tom Lake
 
Hi James...Or Mr Wolf...

I don't have a site to offer you but it isn't too difficult to setup your
own. All you need is a form and several command buttons to perform the
actions you specify. Create a blank form in design view and the required
buttons, and use the On Click event to add functionality to the buttons. The
main function you will need is: DoCmd and the OpenForm method. Look for
these in the help file as a good starting point.
 
Cyberwolf said:
Can anyone point to a sites that would have coding to create my own
switchboard manager? The built-in one is nice but it only allows 8 buttons
and I have come across several instances where I could use more.
TIA
Click to expand...

I tried usid using the switchboard manager for my application, and ran
into the same wall. I found the swb manager to be very inefficient (for
my needs) and not easily modifiable. BUT, it did give me some very
good(IMHO) ideas on waht needed to be done.

1. Create your form with a combo box versus buttons. The cbo source
should be a local table (not linked) that contains information like:

DisplayName; ActualName

DisplayName is the text to appear in the cbo
ActualName is the actual name of the thing you want execute, run, or open


2. Add one command button "Open Form". Make the onClick event of the
command button "Open" the form in the cbo.

If you add (or delete) a form from your application, just modify the table.

I use this setup in many applications. In fact, I use this same setup as
a database switchboard manager. Instead of opening forms within a
database, I open other databases.(Free for the asking).

You could aloso modify the the source table to include a "Type" field,
where 'Type' would be the type of thing to be opened(Table, Report,
Query or Form). The Click event of the Open button would need to be
modified accordingly.


HTH,
Andy
 
Back
Top