B
Bratboy
I need to publish reports from Access to PDF's. I preview a report and then
print it to Adobe Distiller, go back to the design view of the report. and
save the report. This set the printer for that report to the distiller. I
then go to properties>format>caption..and delete what is there. In
properties>event>on open, I set it to event procedure and insert the
following:
Private Sub Report_Open(Cancel As Integer)
Me.Caption = "test" & "-"
End Sub
After the dash I need to concatenate a number representing the month ie 1
for january.
Using a macro I "print" the report. because I have previously printed to
adobe the file name dialog box in adobe is populated with the "MeCaption"
statement"test -". and the path is set by the output statement in the macro.
So my question is How can I get that month number in the caption without
physcally changiing it each month? The number is in a field of the query
used as data for the report and in the macro a form is opened that contains
the needed number.
Not being anything close to a VB person i am not sure how to write the
statement.
Thanks in advance
BratBoy
print it to Adobe Distiller, go back to the design view of the report. and
save the report. This set the printer for that report to the distiller. I
then go to properties>format>caption..and delete what is there. In
properties>event>on open, I set it to event procedure and insert the
following:
Private Sub Report_Open(Cancel As Integer)
Me.Caption = "test" & "-"
End Sub
After the dash I need to concatenate a number representing the month ie 1
for january.
Using a macro I "print" the report. because I have previously printed to
adobe the file name dialog box in adobe is populated with the "MeCaption"
statement"test -". and the path is set by the output statement in the macro.
So my question is How can I get that month number in the caption without
physcally changiing it each month? The number is in a field of the query
used as data for the report and in the macro a form is opened that contains
the needed number.
Not being anything close to a VB person i am not sure how to write the
statement.
Thanks in advance
BratBoy