Main Switchboard

A

awach

I'm trying to make a switchboard that pops up when the database is opened and
allows users to click on a button that will open that form and click on a
button that will open that report.

I have somehow figured out how to do the OpenForm button (by using the
Northwind db in Access as sort-of template) but I can't figure out how to do
the OpenReport button or how to make the form open automatically when the
database is opened. Does anyone have any ideas? Thanks!
 
S

Sprinks

Awach,

See VBA Help on the OpenReport method. The syntax is:

expression.OpenReport(ReportName, View, FilterName, WhereCondition,
WindowMode, OpenArgs)

For example (all parameters pass the ReportName are optional):

DoCmd.OpenReport("YourReport", acNormal)

Set the form to open with the Database through the Tools, Startup dialog box.

Hope that helps.
Sprinks
 
S

Sprinks

awach,

If the Switchboard Manager works for you, great. It has limitations,
however--for example, using the optional parameters of the methods that it
executes. I much prefer to "roll my own", and have a standard form with
command buttons labeled cmd1, cmd2, .... cmdx, cmdExit with the layout I
like. Then I customize the event procedures as required.

Sprinks
 
Top