Macro to open a report that includes certain dates?

[hartandsoul85]

I have a bunch of reports that need to be printed, but only if they include a certain date. I want all of the dates to show up though.

For example:

There are 3 reports with a bunch of different dates in the bill date column.

Reports A and B include the date 04/30/2012, along with a bunch of other dates.


Report C does not include the date 04/30/2012.

i want reports A and B to open since they include the date 04/30/2012, and I want all of the other records with other dates to show up on the reports along with records with a date of 04/30/2012. I do not want Report C to open at all.

Please Help!

[Robeen]

You could create a Macro Action 'RunCode' - and give it the name of a Function Eg: 'Find_Date()' that you would create.

In Function Find_Date(), you could use a DLookup() function to find the date in the dataset [Table/Query] on which your report is based.

You can pass the Date that you are searching for to the Function or get the function to prompt for the Date - or - if it is always going to be the same Date - just hard-code it into the DLookup statement in the function.

If DLookup finds that date in your data set - then you can issue a command - still in the Find_Date() function - to print/open the report:
DoCmd.OpenReport . . .

See this page for details on the syntax for DoCmd.OpenReport:
http://msdn.microsoft.com/en-us/libr...ffice.12).aspx

I hope this helps - but let us know if you need more help.

[JeroenMioch]

If me.[Bill date] = "04/30/2012" then
docmd.openReport "YourReportName"
'Or docmd.printOut
else
'do nothing
exit sub
'outta here
end if

Does that help ?