Report options

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

Guest

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 ...
 
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.).
 
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));
 
Back
Top