Roger's Access Library Homepage
Forum Home Forum Home > Roger's Access Library > Roger's Download Samples
  New Posts New Posts RSS Feed - ChooseReportFromList2.mdb (intermediate)
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

>
Want a good read? Try The Summer of His Life (available on Amazon!)

ChooseReportFromList2.mdb (intermediate)

 Post Reply Post Reply
Author
Message
Roger Carlson View Drop Down
Microsoft MVP
Microsoft MVP


Joined: 20 Feb 2008
Status: Offline
Points: 261
Post Options Post Options   Thanks (0) Thanks(0)   Quote Roger Carlson Quote  Post ReplyReply Direct Link To This Post Topic: ChooseReportFromList2.mdb (intermediate)
    Posted: 01 Aug 2008 at 7:48am

Please consider donating $1 per sample downloaded, find out why here.

ChooseReportFromList2.mdb

These forms illustrate some advanced features in a "Report Switchboard". For less complex examples, see "ChooseReportFromList.mdb"

-- Choose Report or Parameter Form allows the user to select either a report directly or a form in which they can choose a parameter for the report.

With the Parameter Form, the routine opens a form instead of the report directly. The report is opened from the parameter form instead.

Reports that show in the list MUST have an "rpt" prefix. Parameter forms that appear in the list MUST have an "rpf" prefix. Reports that are run from the Parameter form SHOULD NOT have a prefix (or they will appear in the list as well, and you don't want that.)

-- Choose Report or Query allows the user to select either a report or a query from the listbox.

Reports that show in the list MUST have an "rpt" prefix. Queries that appear in the list MUST have an "qrpt" prefix. Queries that you do not want in the list SHOULD NOT have that prefix.

The option box which objects will be shown in the list. Choosing a different option rebuilds the RowSource for the list. It also determines which object (report, form, or query) will be opened..
 
Download
Access 97 (245 KB):
ChooseReportFromList2_97.zip
Access 2000 (147 KB): ChooseReportFromList2-2k.zip

Consider donating $1 per sample downloaded, find out why here.<
Back to Top
Sponsored Links
>
Want a good read? Try The Summer of His Life (available on Amazon!)

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.