Entering a criteria for a Report based on a variable

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I am trying to run multiple reports using values from a table to
populate the criteria. When I run the report manually I am prompted to enter
in the criteria value what I am trying to do is pass the value from a
variable in my module. So I can run a loop and keep selecting a different
report based on the current value of the variable. Any help would be greatly
appreciated.
 
On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "EmailingSpecificReports.mdb" which illustrates how to do
this. The emailing portion no longer works consistantly because of security
"improvements" in Outlook, but the part that builds the reports from
information in a table still does.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Thanks, I love your site. It is very helpful.

--
Thank You,
Steve


Roger Carlson said:
On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "EmailingSpecificReports.mdb" which illustrates how to do
this. The emailing portion no longer works consistantly because of security
"improvements" in Outlook, but the part that builds the reports from
information in a table still does.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
Click to expand...
 
Back
Top