Report Captions

[Nchantim]

Wouldn't it be nice if we could programmatically change
the Caption property of a report BEFORE opening it, so
that my PDF writer could name the file as something
useful (i.e. based on the key in the WHERE clause passed
to the report).
It's hard to believe that it's seemingly impossible to do
this.
I've tried opening the report in preview mode (then
Report_Open fires, and you CAN change the caption), and
then open normal for printing, then close the report, but
with the Access 2002 runtime on some PCs, this results in
the second Open (Normal) completely ignoring the WHERE
clause.

 

[SA]

1.) If you've got the report open in preview, don't issue a second
OpenReport method, call PrintOut method.
2.) If you want a way to specify the file name at run time, take a look at
our PDF and Mail Library for Access. It will allow you to specify the file
name and output location at run time without having to preview the report
first or muck with captions.