Access Report - Passing parameters 1

[CmPaiva]

Hi,
Does anybody knows how to pass a parameter to an Access Report, not for filtering (DoCmd parameters do this), but just to be shown in the report (Say StationId: ...), and that is not related with report data.
In Crystal reports, i'd used to pass this by using Formulas, but I can't find a way of doing this in Microsoft Access Report!

Thanks in advance, for your help
Carlos

 

[CmPaiva]

Hi, Again!

I manage to find the answer. I do not know if is the best way, but I do as:

- Open the report in design mode
- Change Labels captions as desired
- Then open report again for print.

Code is as follows:

With mAccessApp
.OpenCurrentDatabase App.Path + "\cpRegistry.mdb"
.RunCommand acCmdWindowHide
.RunCommand acCmdAppMinimize
' .Visible = True
.DoCmd.OpenReport "Results", acViewDesign
With .Reports("Results&quot
.Controls("Title&quot.Caption = "Results By " + mResult
.Controls("Description&quot.Caption = mDescription
.Application.DoCmd.OpenReport "Results"
End With
End With

Thanks anyway
Carlos Paiva

 

[CCLINT]

Yep, that's how to do it.

Thanks for posting your solution for others to see!

 

[CmPaiva]

Hi, CClint,

I think that it is the right way to put this forum to work!

Thanks for your comment,

Carlos Paiva

 

[johnwm]

A Star for CmPaiva - may many others learn from your good example!


________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'