SwitchBoard

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

Guest

I have created a database and I am using a switchboard to access the forms
that I have created. What I am wondering is if there is a way that I can
create a button on the switchboard that will do a lookup in one of the
tables? If so, what would be my best course of action?

Thanks,
Tj
 
If you mean that you are using the "Switchboard Manager" then you
could create a form that would do that "lookup" (I don't understand
your definition of "looking up")

I'm assuming that you want to view the results of a Select Query. Use
a form for that.

Cheers,
Jason Lepack
 
You can try to create a Macro that opens your specified table then apply a
filter on the second line of the macro. The filter would be a query you
design to lookup the criteria you specify. I tried to add a button to a
switchboard menu that runs a macro. It works fine. I'm sure you can design
a query to lookup what ever you need to from this table. Good luck.
 
Let me know if it works for you or if you run into a problem. I'll check
back later today.
 
How do you UNDELETE a Switchboard??
Click to expand...

Sorry! Once a form is deleted, it's gone.
Create a new one.
If it was a switchboard created by the built-in Access Switchboard
Manager, first rename the existing SwitchBoard Items table (unless you
also deleted that) to OldSwitchboardItems.
Then open the Switchboard Manager and create a new switchboard. Just
add any one item. Then save the switchboard. Delete the new
Switchboard Items table. Rename the old table back to Switchboard
Items.
You will have re-created your old switchboard.

If your deleted switchboard was created using an unbound form with
command buttons, you'll have to re-create it anew.
 
Back
Top