Main Switchboard

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

Guest

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!
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top