I have a Access 2000 form that I am using to pull Crystal Reports through a viewer. I got the report to pull through the viewer through VBA, but my questions is how can I set up Parameters in Access 2000 to run through my Crystal Report in VBA. I would like to use Calendars in Access to do Start and End Dates. Can anyone help me.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Passing Parameters through Access 2000 (VBA) to CR 8.5
- Thread starter rsatty
- Start date
You can use the ParameterFields collection of the Report object:
crxReport.ParameterFields(1).AddCurrentValue "AAA"
crxReport.ParameterFields(2).AddCurrentValue "ALL"
The parameter fields from the report are indexed starting with 1.
Have a look here:
-Gary
crxReport.ParameterFields(1).AddCurrentValue "AAA"
crxReport.ParameterFields(2).AddCurrentValue "ALL"
The parameter fields from the report are indexed starting with 1.
Have a look here:
-Gary
- Status
Similar threads
- Locked
- Helpful tip
