|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 15th, 2009, 08:25 PM
posted to microsoft.public.access.reports
|
|||
|
|||
prient preview okay but actual printing causes #name? error
I have a report that displays values collected from a form.
The Print Preview shows the values correctly, but when I actually print the report (to a printer or pdf) the values show up as #Name? errors. I have the values entered in controlsource field of the report as [=[forms]![frmName]![formvaluename] Any suggestions? 
|
|
#2
December 15th, 2009, 08:43 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
prient preview okay but actual printing causes #name? error
jillymc,
Are you closing the form before the report actually prints? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "jillymc" wrote in message ... I have a report that displays values collected from a form. The Print Preview shows the values correctly, but when I actually print the report (to a printer or pdf) the values show up as #Name? errors. I have the values entered in controlsource field of the report as [=[forms]![frmName]![formvaluename] Any suggestions?
|
|
#3
December 16th, 2009, 03:31 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
prient preview okay but actual printing causes #name? error
Yes, that turns out to be the problem.
The form opens in a popup window that obstructs the print preview. We were closing the popup before printing. Which brings up the question.....is there a way to have the print preview window appear in front of the form popup? Or, how could I pass the variables in the code behind so that it's not an issue? thanks. Jill "Gina Whipp" wrote: jillymc, Are you closing the form before the report actually prints? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "jillymc" wrote in message ... I have a report that displays values collected from a form. The Print Preview shows the values correctly, but when I actually print the report (to a printer or pdf) the values show up as #Name? errors. I have the values entered in controlsource field of the report as [=[forms]![frmName]![formvaluename] Any suggestions? .
|
|
#4
December 16th, 2009, 04:14 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
prient preview okay but actual printing causes #name? error
Jill,
Instead of closing the form use Visible... On Report's On_Close Event Forms![YourFormName].Visible = True On the Report's On_Load Event Forms![YourFormName].Visible = False -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "jillymc" wrote in message ... Yes, that turns out to be the problem. The form opens in a popup window that obstructs the print preview. We were closing the popup before printing. Which brings up the question.....is there a way to have the print preview window appear in front of the form popup? Or, how could I pass the variables in the code behind so that it's not an issue? thanks. Jill "Gina Whipp" wrote: jillymc, Are you closing the form before the report actually prints? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "jillymc" wrote in message ... I have a report that displays values collected from a form. The Print Preview shows the values correctly, but when I actually print the report (to a printer or pdf) the values show up as #Name? errors. I have the values entered in controlsource field of the report as [=[forms]![frmName]![formvaluename] Any suggestions? .
|
|
#5
December 16th, 2009, 05:30 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
prient preview okay but actual printing causes #name? error
That works perfectly!!!!!
Thanks for the Christmas present!!! Jill "Gina Whipp" wrote: Jill, Instead of closing the form use Visible... On Report's On_Close Event Forms![YourFormName].Visible = True On the Report's On_Load Event Forms![YourFormName].Visible = False -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "jillymc" wrote in message ... Yes, that turns out to be the problem. The form opens in a popup window that obstructs the print preview. We were closing the popup before printing. Which brings up the question.....is there a way to have the print preview window appear in front of the form popup? Or, how could I pass the variables in the code behind so that it's not an issue? thanks. Jill "Gina Whipp" wrote: jillymc, Are you closing the form before the report actually prints? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "jillymc" wrote in message ... I have a report that displays values collected from a form. The Print Preview shows the values correctly, but when I actually print the report (to a printer or pdf) the values show up as #Name? errors. I have the values entered in controlsource field of the report as [=[forms]![frmName]![formvaluename] Any suggestions? . .
|
|
#6
December 16th, 2009, 06:21 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
prient preview okay but actual printing causes #name? error
Jill,
Glad to help! -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "jillymc" wrote in message ... That works perfectly!!!!! Thanks for the Christmas present!!! Jill "Gina Whipp" wrote: Jill, Instead of closing the form use Visible... On Report's On_Close Event Forms![YourFormName].Visible = True On the Report's On_Load Event Forms![YourFormName].Visible = False -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "jillymc" wrote in message ... Yes, that turns out to be the problem. The form opens in a popup window that obstructs the print preview. We were closing the popup before printing. Which brings up the question.....is there a way to have the print preview window appear in front of the form popup? Or, how could I pass the variables in the code behind so that it's not an issue? thanks. Jill "Gina Whipp" wrote: jillymc, Are you closing the form before the report actually prints? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "jillymc" wrote in message ... I have a report that displays values collected from a form. The Print Preview shows the values correctly, but when I actually the report (to a printer or pdf) the values show up as #Name? errors. I have the values entered in controlsource field of the report as [=[forms]![frmName]![formvaluename] Any suggestions? . .
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
