Covert report to PDF

M

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!
 
S

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


Mavis said:
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
 
A

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?
 
M

Mavis

Hi All,

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



Allen Browne said:
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.
Mavis said:
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!
 
A

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.
Mavis said:
Hi All,

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



Allen Browne said:
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 said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top