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
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
What do you mean by 'manage'? Run the reports at scheduled times? Run them with filter parameters?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
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
Now place this code in the Form’s Code ModuleCode:SELECT MSysObjects.Name FROM MsysObjects WHERE (Left$([Name],1)<>"~") And (MSysObjects.Type)=-32764 ORDER BY MSysObjects.Name;
Code: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)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007
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
You could have another criteria in the WHERE clause. What part of the name?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.