Print Page | Close Window

ChooseReportFromList2.mdb (intermediate)

Printed From: Roger's Access Library
Category: Roger's Access Library
Forum Name: Roger's Download Samples
Forum Description: A compendium of Microsoft Access 97 and 2000+ routines, each separated into its own sample database.
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=382
Printed Date: 19 Sep 2019 at 4:19am


Topic: ChooseReportFromList2.mdb (intermediate)
Posted By: Roger Carlson
Subject: ChooseReportFromList2.mdb (intermediate)
Date Posted: 01 Aug 2008 at 7:48am

Please consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm - 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):
http://www.rogersaccesslibrary.com/forum/uploads/5/ChooseReportFromList2_97.zip - ChooseReportFromList2_97.zip
Access 2000 (147 KB): http://www.rogersaccesslibrary.com/forum/uploads/5/ChooseReportFromList2-2k.zip - ChooseReportFromList2-2k.zip



-------------
Consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm" rel="nofollow - find out why here .<



Print Page | Close Window