prient preview okay but actual printing causes #name? error
in [Reports]
|
Prev: Problems Summing
Next: Send Access Report to MS Word
From: jillymc on 15 Dec 2009 15:25 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?
From: Gina Whipp on 15 Dec 2009 15:43 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" <jillymc(a)discussions.microsoft.com> wrote in message news:046E5F68-7867-4E3F-A5C7-D19DF403ADA4(a)microsoft.com... >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? >
From: jillymc on 16 Dec 2009 10:31 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" <jillymc(a)discussions.microsoft.com> wrote in message > news:046E5F68-7867-4E3F-A5C7-D19DF403ADA4(a)microsoft.com... > >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? > > > > > . >
From: Gina Whipp on 16 Dec 2009 11:14 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" <jillymc(a)discussions.microsoft.com> wrote in message news:0EBEAB02-1E2F-43EE-BA7D-989FFEC3859C(a)microsoft.com... > 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" <jillymc(a)discussions.microsoft.com> wrote in message >> news:046E5F68-7867-4E3F-A5C7-D19DF403ADA4(a)microsoft.com... >> >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? >> > >> >> >> . >>
From: jillymc on 16 Dec 2009 12:30
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" <jillymc(a)discussions.microsoft.com> wrote in message > news:0EBEAB02-1E2F-43EE-BA7D-989FFEC3859C(a)microsoft.com... > > 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" <jillymc(a)discussions.microsoft.com> wrote in message > >> news:046E5F68-7867-4E3F-A5C7-D19DF403ADA4(a)microsoft.com... > >> >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? > >> > > >> > >> > >> . > >> > > > . > |