Report options

K

kloney

I would like to setup a dropdown list of report names which when selected run
the specific report.

I am guessing that i need a form with a text/combo box on it but cant seem
to figure it out from there
all help is appreciated as i am sure i have seen this done before ...
 
S

Sandra Daigle

There is an example of how to do this using listboxes in my report dialog
sample on http://www.daiglenet.com/msacc­ess.htm. It requires that you build
a table that lists the report objects with their common (user recognized)
names. It also allows you to group reports (ie Vendor Reports, Customer
Reports, etc.).
 
T

Tom Ross

this query will list your reports. can be used as the row source for your
combo box. Msysobjects is a system table

SELECT msysobjects.Name, msysobjects.Type
FROM msysobjects LEFT JOIN ReportNames ON msysobjects.Name =
ReportNames.ReportName
WHERE (((msysobjects.Type)=-32764));


This query (as i use it) links to a table t (reportnameshat has a user
friendly description for each report. Items not in that table will be
excluded

SELECT msysobjects.Name, ReportNames.ReportDescription AS Description,
msysobjects.Type
FROM msysobjects INNER JOIN ReportNames ON msysobjects.Name =
ReportNames.ReportName
WHERE (((msysobjects.Type)=-32764));
 
Top