Getting list of Reports

  • Thread starter Thread starter Michael Kintner
  • Start date Start date
M

Michael Kintner

Access 2002

How can I get a list of all the reports and put them in a pull down menu in
a form view.

VB Code Please...

Thank you in advance for any help!!! (smile)

Mike
 
Access 2002

How can I get a list of all the reports and put them in a pull down menu in
a form view.

VB Code Please...

Thank you in advance for any help!!! (smile)

Mike
Click to expand...

Add a List box or Combo box to the form.
As RowSource:
SELECT MSysObjects.Name FROM MSysObjects WHERE
(((Left([Name],1))<>"~") AND ((MSysObjects.Type)=-32764)) ORDER BY
MSysObjects.Name;
 
I find it much more flexible to keep a table of reports with the ObjectName,
ReportTitle, Status, Comments, and other fields. This allows you to:
use a proper naming convention for your report objects
display a nice title in the list/combo box
display the comments when the user selects a report in the list box
not show/display subreport names
It takes very little effort to maintain this table and it is a standard in
every application that I create.
 
Back
Top