Boz:
The Access db window, doesn't really provide a way to organize reports into
folders or other groupings. However, if you want to simulate this for your
users, you could create one or more forms which use a list box (or I guess a
tree control) to simulate this with a little visual basic code.
To do this, you could prefix each report with say a three or four letter
"key" for each group. E.g. cust_Report1, cust_Report2, invt_Report1,
invt_Report2 etc.
Then to fill your list box, (or a node on the tree control) you'd use the
AllReports collection, selecting those with the target prefix, adding them
to a string (for a list box row source) like this in the form's On Load
event:
Dim obj As AccessObject, dbs As Object
Dim strRpts as String
Set dbs = Application.CurrentProject
' Search for open AccessObject objects in AllReports collection.
For Each obj In dbs.AllReports
If Left(obj.Name, 5) = "cust_" Then
strRpts = strRpts & Right(obj.Name - Len(obj.Name)-5) & ","
End If
Next obj
'Strip the last ","
strRpts = Left(strRpts, len(strRpts) - 1)
Me!MyListBox.RowSource = strRpts
When the user double clicks on the list box, you'd append the "cust_" to the
string returned to open the report. Of course you could get very creative
an add a combo box to the form so select the types of reports (using the
group name as the first column and a zero width second column with the
target report prefix).
If you want another way to do it, take a look at the free download on our
site in the Free Files area called "Other reports" and it demonstrates a way
to fill a tool bar control with the list of available reports and you could
create a tool bar for each type of activity (based on a form) that your
users had to do.
With a tree view control, you'd add a node for each report that meets the
criteria.
HTH
