prient preview okay but actual printing causes #name? error
in [Reports]
|
Prev: Problems Summing
Next: Send Access Report to MS Word
From: Gina Whipp on 16 Dec 2009 13:21 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" <jillymc(a)discussions.microsoft.com> wrote in message news:9ECD617F-82D3-48A6-BCDA-6DAE2E772161(a)microsoft.com... > 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 >> >> > 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? >> >> > >> >> >> >> >> >> . >> >> >> >> >> . >> |