wlwebb
asked on
Access07 - Report - Unbound textbox in Report Footer #Error but when in layout view it's not
Hello all
Been away a few day.
I have a "Report" that I designed that when I'm in Preview or Form view mode an unbound Textbox shows me the total from it's control source formula...
However, when I "Preview" the form I'm getting #Error...... Is there a 07 bug or am I missing something??????
Been away a few day.
I have a "Report" that I designed that when I'm in Preview or Form view mode an unbound Textbox shows me the total from it's control source formula...
However, when I "Preview" the form I'm getting #Error...... Is there a 07 bug or am I missing something??????
What is the control source of the unbound textbox?
ASKER
Mbiz
=[txtEOD1]+[txtAtLastPull1 ]+[txtAtCu rrPull1]
those three textboxes are in the Report footer as well. Individually they all show amts.... but when I add them in the other textbox #error (if I put them in the control source of one textbox as a formula I get #Error)
=[sRpt_MachPull_ReconcileE OD].[Repor t]![txtEOD SincePullT tl1]
=[sRpt_MachPull_ReconcileL astPull].[ Report]![t xtAtLastPu llTtl1]
=[sRpt_MachPull_ReconcileC urrentPull Time].[Rep ort]![txtA tCurrentPu llTtl1]
=[txtEOD1]+[txtAtLastPull1
those three textboxes are in the Report footer as well. Individually they all show amts.... but when I add them in the other textbox #error (if I put them in the control source of one textbox as a formula I get #Error)
=[sRpt_MachPull_ReconcileE
=[sRpt_MachPull_ReconcileL
=[sRpt_MachPull_ReconcileC
Any chance of seeing a sample copy of your database?
<< =[txtEOD1]+[txtAtLastPull1 ]+[txtAtCu rrPull1] >>
You might have to replace those textbox names with their equivalent expressions based on the underlying table fields.
As to why it would fail in Print Preview... it may have to do with the timing of when those textboxes are available. For example controls in the detail section of a report are not available until the Detail Print or Detail format events.
(But I'm just speculating here.)
<< =[txtEOD1]+[txtAtLastPull1
You might have to replace those textbox names with their equivalent expressions based on the underlying table fields.
As to why it would fail in Print Preview... it may have to do with the timing of when those textboxes are available. For example controls in the detail section of a report are not available until the Detail Print or Detail format events.
(But I'm just speculating here.)
ASKER
Stripping out a small version might be next to impossible......and whole I think will be too large to upload...
The timing is the conclusion I was coming up with too........
I will see if I can whittle the db down for upload
The timing is the conclusion I was coming up with too........
I will see if I can whittle the db down for upload
ASKER
Two parts FE/BE.... the Report is rpt_MachPull
BUT before you open that in forms... open frm_AAASetVariables
and put in an EmpID=2 ShiftID=39 UserID=2 and Date 1/2/14
LVL-Reporting.accdb
BUT before you open that in forms... open frm_AAASetVariables
and put in an EmpID=2 ShiftID=39 UserID=2 and Date 1/2/14
LVL-Reporting.accdb
You can also try replacing those textbox names with expressions based on the actual fields.
Depending on how the report is configured (main report, subreports, etc) you may need to use DLookups or similar to get the needed fields.
Depending on how the report is configured (main report, subreports, etc) you may need to use DLookups or similar to get the needed fields.
Missed your last post. I'll take a look.
ASKER
Bk End
LVL-Mgmt-Reporting-be.accdb
LVL-Mgmt-Reporting-be.accdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thx.... I'll give it a try
ASKER
Get #Error on my
=IIf(IsError(DSum("[1]","C tabqry_LVL InfoDetail EODSinceLa stPulll"," BusDay<=#" & [BusDay] & "#")),0,DSum("[1]","Ctabqr y_LVLInfoD etailEODSi nceLastPul l","BusDay <=#" & [BusDay] & "#"))
And on
=IIf(IsError(DSum("[1]","C tabqry_LVL InfoDetail s_AtLastPu llTime","M axBusDay=# " & [BusDay] & "#")),0,DSum("[1]","Ctabqr y_LVLInfoD etails_AtL astPullTim e","MaxBus Day=#" & [BusDay] & "#"))
I added [BusDay] field in header of rpt_MachPull.............. ..
Tried both without the [] around the 1 also... same result
=IIf(IsError(DSum("[1]","C
And on
=IIf(IsError(DSum("[1]","C
I added [BusDay] field in header of rpt_MachPull..............
Tried both without the [] around the 1 also... same result
ASKER
THANKS!!!! (I had a space in front of the number in the [] was causing the error.......)
Nice job! :)