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!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to pass parameters to Crystal Reports

Status
Not open for further replies.
RobHVB6Sql

RobHVB6Sql

Programmer
May 20, 2002
77
AU
I have done this in VB, but the .ParameterFields(x) property isn't there in Access 97/VBA.

I have a Crystal Report Control (which Access calls an ActiveX Control) on a form and am printing the report fine with:

With theForm.CRViewer1
.ReportFileName = "xxx"

'prepare standard parms (property not present)
''.ParameterFields(0) = "@DateFrom;" + strDateFrom + ";TRUE"
.PrintReport
End With

theForm.CRViewer1.Reset


Any help appreciated. Rob Hasard
Data Manager -Genetic Services
(VB6 /SQL 7.0)
 
Status
Not open for further replies.

Similar threads

ziffer68
  • Locked
  • Question
Pass Through query to create an alias for DB2 member
Replies
0
Views
2K
ziffer68
ziffer68
Zyborg
  • Locked
  • Question
Using a variable as reference to a form
Replies
5
Views
442
Zyborg
Zyborg
Kennelbloke
  • Locked
  • Solved
Refer to Navigation Control Subform Record
Replies
8
Views
755
Kennelbloke
Kennelbloke
renigar
  • Locked
  • Question
Code to write file path to field always writes to 1st record 1
Replies
5
Views
506
dhookom
dhookom
btamsgn
  • Locked
  • Question
How to edit column chitoi into TableA
Replies
0
Views
169
btamsgn
btamsgn

Part and Inventory Search

Sponsor

Back
Top