SwitchBoard

B

bumper338

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
 
J

Jason Lepack

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
 
F

FL

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.
 
F

FL

Let me know if it works for you or if you run into a problem. I'll check
back later today.
 
F

fredg

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.
 
Top