Covert report to PDF

[Mavis]

Hi All,

I have the below code for my title of my report.

=" Total Recovery Within " & [Forms]![Form Date Range Total Recovery]![Start
Date] & " And " & [Forms]![Form Date Range Total Recovery]![End Date]

The title was generated out nicely but once i convert the report to PDF
format it will show #Name.

Can anyone advice what is wrong?

Thanks!

 

[Steve Schapel]

Mavis,

My guess ;-) is that you don't have the 'Form Date Range Total Recovery'
open at the time that you are doing the output to PDF.

--
Steve Schapel, Microsoft Access MVP

Hi All,

I have the below code for my title of my report.

=" Total Recovery Within " & [Forms]![Form Date Range Total
Recovery]![Start
Date] & " And " & [Forms]![Form Date Range Total Recovery]![End Date]

The title was generated out nicely but once i convert the report to PDF
format it will show #Name.

Can anyone advice what is wrong?

Thanks!

__________ Information from ESET Smart Security, version of virus signature database 4227 (20090709) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Allen Browne]

The most likely reason is that the form has been closed at the time the PDF
is created. Can you verify that the form is still open?

 

[Mavis]

Hi All,

Yes, the form is closed. is there a way that the title still can be
generated even the form is close?

The most likely reason is that the form has been closed at the time the PDF
is created. Can you verify that the form is still open?

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Hi All,

I have the below code for my title of my report.

=" Total Recovery Within " & [Forms]![Form Date Range Total
Recovery]![Start
Date] & " And " & [Forms]![Form Date Range Total Recovery]![End Date]

The title was generated out nicely but once i convert the report to PDF
format it will show #Name.

Can anyone advice what is wrong?

Thanks!

 

[Allen Browne]

I hope it makes sense that you cannot have the report refer to the form if
the form is closed.

There are alternatives, but they will involve some coding. If the form is
open when the report opens, you could write code in the Format event of the
Report Header, to read the information from the form and assign it to some
unbound text boxes on the report.

Another approach would be to open the report from a command button on your
form, and pass the text you want in the OpenArgs of OpenReport. (Requires
Access 2002 or later.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Hi All,

Yes, the form is closed. is there a way that the title still can be
generated even the form is close?

The most likely reason is that the form has been closed at the time the
PDF
is created. Can you verify that the form is still open?

Hi All,

I have the below code for my title of my report.

=" Total Recovery Within " & [Forms]![Form Date Range Total
Recovery]![Start
Date] & " And " & [Forms]![Form Date Range Total Recovery]![End Date]

The title was generated out nicely but once i convert the report to PDF
format it will show #Name.