Report Printing Problem

  • Thread starter Thread starter bill
  • Start date Start date
B

bill

I have a report where I reference the following text box
on a form. When I preview the report everything looks
fine, however, when I print the report, the field on the
report shows as #Name?. Any idea why? The reference I
am making is below.

=[Forms]![frmFPISelect]![txtjob2]
 
It is being closed as part of the OnClick procedure of
the print preview command button
-----Original Message-----
When are you closing the form "frmFPISelect"?

--
Duane Hookom
MS Access MVP
--

I have a report where I reference the following text box
on a form. When I preview the report everything looks
fine, however, when I print the report, the field on the
report shows as #Name?. Any idea why? The reference I
am making is below.

=[Forms]![frmFPISelect]![txtjob2]
Click to expand...


.
Click to expand...
 
Ok, so when should the form be closed? If you want to reference the text box
value in your printed report, the form should remain open until the report
has been printed.

--
Duane Hookom
MS Access MVP
--

bill said:
It is being closed as part of the OnClick procedure of
the print preview command button
-----Original Message-----
When are you closing the form "frmFPISelect"?

--
Duane Hookom
MS Access MVP
--

I have a report where I reference the following text box
on a form. When I preview the report everything looks
fine, however, when I print the report, the field on the
report shows as #Name?. Any idea why? The reference I
am making is below.

=[Forms]![frmFPISelect]![txtjob2]
Click to expand...


.
Click to expand...
Click to expand...
 
ok, so where should I move the code so that the pop up
form is not on top of the preview report screen?
-----Original Message-----
Ok, so when should the form be closed? If you want to reference the text box
value in your printed report, the form should remain open until the report
has been printed.

--
Duane Hookom
MS Access MVP
--

It is being closed as part of the OnClick procedure of
the print preview command button
-----Original Message-----
When are you closing the form "frmFPISelect"?

--
Duane Hookom
MS Access MVP
--

I have a report where I reference the following text box
on a form. When I preview the report everything looks
fine, however, when I print the report, the field on the
report shows as #Name?. Any idea why? The reference I
am making is below.

=[Forms]![frmFPISelect]![txtjob2]



.
Click to expand...
Click to expand...


.
Click to expand...
 
Make the form invisible and then close it in the On Close of the report. Or,
don't close it.

--
Duane Hookom
MS Access MVP
--

bill said:
ok, so where should I move the code so that the pop up
form is not on top of the preview report screen?
-----Original Message-----
Ok, so when should the form be closed? If you want to reference the text box
value in your printed report, the form should remain open until the report
has been printed.

--
Duane Hookom
MS Access MVP
--

It is being closed as part of the OnClick procedure of
the print preview command button
-----Original Message-----
When are you closing the form "frmFPISelect"?

--
Duane Hookom
MS Access MVP
--

message
I have a report where I reference the following text
box
on a form. When I preview the report everything looks
fine, however, when I print the report, the field on
the
report shows as #Name?. Any idea why? The reference I
am making is below.

=[Forms]![frmFPISelect]![txtjob2]



.
Click to expand...


.
Click to expand...
Click to expand...
 
Thanks Duane. One more stupid question..

How do I make it invisible after they have entered the
data? I am assuming I do this as part of the Onclick
procedure, but not sure how
-----Original Message-----
Make the form invisible and then close it in the On Close of the report. Or,
don't close it.

--
Duane Hookom
MS Access MVP
--

ok, so where should I move the code so that the pop up
form is not on top of the preview report screen?
-----Original Message-----
Ok, so when should the form be closed? If you want to reference the text box
value in your printed report, the form should remain open until the report
has been printed.

--
Duane Hookom
MS Access MVP
--

It is being closed as part of the OnClick procedure of
the print preview command button
-----Original Message-----
When are you closing the form "frmFPISelect"?

--
Duane Hookom
MS Access MVP
--

message
I have a report where I reference the following text
box
on a form. When I preview the report everything looks
fine, however, when I print the report, the field on
the
report shows as #Name?. Any idea why? The reference I
am making is below.

=[Forms]![frmFPISelect]![txtjob2]



.



.
Click to expand...
Click to expand...


.
Click to expand...
 
Add code to the procedure that opens the report like:
Me.Visible = False

--
Duane Hookom
MS Access MVP
--

bill said:
Thanks Duane. One more stupid question..

How do I make it invisible after they have entered the
data? I am assuming I do this as part of the Onclick
procedure, but not sure how
-----Original Message-----
Make the form invisible and then close it in the On Close of the report. Or,
don't close it.

--
Duane Hookom
MS Access MVP
--

ok, so where should I move the code so that the pop up
form is not on top of the preview report screen?
-----Original Message-----
Ok, so when should the form be closed? If you want to
reference the text box
value in your printed report, the form should remain
open until the report
has been printed.

--
Duane Hookom
MS Access MVP
--

message
It is being closed as part of the OnClick procedure of
the print preview command button
-----Original Message-----
When are you closing the form "frmFPISelect"?

--
Duane Hookom
MS Access MVP
--

message
I have a report where I reference the following text
box
on a form. When I preview the report everything
looks
fine, however, when I print the report, the field on
the
report shows as #Name?. Any idea why? The
reference I
am making is below.

=[Forms]![frmFPISelect]![txtjob2]



.



.
Click to expand...


.
Click to expand...
Click to expand...
 
thanks
-----Original Message-----
Add code to the procedure that opens the report like:
Me.Visible = False

--
Duane Hookom
MS Access MVP
--

Thanks Duane. One more stupid question..

How do I make it invisible after they have entered the
data? I am assuming I do this as part of the Onclick
procedure, but not sure how
-----Original Message-----
Make the form invisible and then close it in the On Close of the report. Or,
don't close it.

--
Duane Hookom
MS Access MVP
--

ok, so where should I move the code so that the pop up
form is not on top of the preview report screen?
-----Original Message-----
Ok, so when should the form be closed? If you want to
reference the text box
value in your printed report, the form should remain
open until the report
has been printed.
Click to expand...
procedure
of
the print preview command button
-----Original Message-----
When are you closing the form "frmFPISelect"?
Click to expand...
wrote
in
message
I have a report where I reference the
Click to expand...
following
text
box
on a form. When I preview the report everything
looks
fine, however, when I print the report, the field on
the
report shows as #Name?. Any idea why? The
reference I
am making is below.

=[Forms]![frmFPISelect]![txtjob2]



.



.



.
Click to expand...
Click to expand...


.
Click to expand...
 
Back
Top