Variable from VB to Access Report

[vbjohn]

How can you add a variable from VB to an Access Reports Page Header?

Any suggestions?


John-

 

[Mile-O]

When opening the report with code assign the variable to the report's OpenArgs property.

Then, on the OnOpen() event of the report assign the reports OpenArgs to the control in the header that you wish to display the variable's value.

 

[vbjohn]

This is how I am opening the report...

=========================================
Private appAccess As Access.Application

Set appAccess = New Access.Application
strACCond = "((APHistory.POSTEDDT) Between #" & txtFDate.Text & "# And #" & txtTDate.Text & "#)"

appAccess.Visible = False
appAccess.OpenCurrentDatabase App.Path & "\APHistory.mdb", True

With appAccess.DoCmd
.OpenReport "Aphistory", acViewPreview, , strACCond
.Maximize
End With

appAccess.Visible = True

=========================================

So where is the OpenArgs in VB or Access?


John-

 

[Mile-O]

If you look at the information of all the arguments in the DoCmd.OpenReport statement - where it goes:FormName, [Filter], etc you'll see that OpenArgs is the last argument and you'd just put the variable's name there.

 

[vbjohn]

All I see is..

.OpenReport [Report Name], [View As AcView = acViewNormal],[Filtername],[WhereCondition]

John-

 

[Mile-O]

Strange...

 

[vbjohn]

what version of vb, access do you have? What refrence do you use in VB? "Microsoft Access 9.0 Object Library".


John-

 

[Mile-O]

Ah! As I'm at home I'm using A2002 - forms in A97 can be opened with OpenArgs passed so I'd have thought reports had that same property.