Report Manager

[OldCityCat]

I'm going a little crazy trying to manage and run the 50-60 custom reports and queues, that my manager requires.


I looking for any tips/tricks or maybe a Add-in that might help.

Thanks in advance for any and all suggestions

OldCityCat

[June7]

What do you mean by 'manage'? Run the reports at scheduled times? Run them with filter parameters?

[Missinglinq]

Find a new job? Hire a retired Access Gnome? As June7 has suggested, your post is lacking in the details we need if we're going to help you!

If you need to organize and easily retrieve your Reports, for printing, you could use a Combobox to do this:

• Place a Combobox on your Form
• When the Wizard comes up, hit <Cancel>
• With the Combobox selected, go to Properties – Other
• In the Name Property box enter ReportToPrint
• Go to the Data Tab
• Paste this into the RowSource Property box

SELECT MSysObjects.Name FROM MsysObjects WHERE (Left$([Name],1)<>"~") And (MSysObjects.Type)=-32764 ORDER BY MSysObjects.Name;

Now place this code in the Form’s Code Module

Private Sub ReportToPrint_AfterUpdate()
    
    If Nz(Me.ReportToPrint) <> "" Then
     DoCmd.OpenReport ReportToPrint, acNormal
   Else
     MsgBox ("You Must First Select a Report To Print!")
     Me.ReportToPrint.SetFocus
   End If
   Me.ReportToPrint = Null

End Sub

The Combobox will be loaded with all Reports, and selecting one will send it to the printer.

Linq ;0)>

[OldCityCat]

Thanks to June7 & Missinglinq for your prompt responses.
Sorry, I knew right after is sent the post I didn't explain myself very well.
I guess I'm looking for a more efficient way of finding the report I need to run.

I'm using the "best practice" naming convention, all report names start with
"rpt" then I give it a very descriptive name, here are a few examples;

rptBillOfLadingCarrierCount_Europe_Tbl_2010
rptBillOfLadingCount_EuorpeSummary_Tbl_2011
rptCarrierByDischargePortShipper_Asia_Tbl_2012
rptContainerCountByShipperConsignee_Asia_Qry_2012

I'v tried modifying with the "Navigation Pane"
Attachment 8609
but it doesn't seem very stable.

Linq,
I added the Combo Box to my form and it works as expected.
Is there a way to get a subset of the MSysObjects, based on part of the report name?
Maybe grouping by some part of the name.


Again thanks for any and all suggestions

OldCityCat

[June7]

You could have another criteria in the WHERE clause. What part of the name?