Zydeceltico
Registered User.
- Local time
- Yesterday, 21:48
- Joined
- Dec 5, 2017
- Messages
- 843
Hi All -
A legacy database that I've been "gifted" with managing is returning an error on two calculated fields when I open it.
Actually when I open the report, "Calibration Due Report," from the Main Menu, I am first presented with an "Enter Parameter Value" "Format$" msg box. I click ok and the report opens but has tow textboxes that read "#Error."
I am told by my co-worker that those two textboxes should state the Month and Year.
The field on the left side of the page has this expresion as its Control Source: =[Format$]([Recalibration Due Date],"mmm yyyy",0,0)
The field on the right side of the page has this as its Control Source: =[Format$]([Recalibration Due Date],"mmm yyyy")
I've attached the db - which has worked fine until recently.
It should open to "Main Menu." Click on "Calibration Due Report" in green at lower left of form.
Any thoughts are appreciated.
Thank you,
Tim
A legacy database that I've been "gifted" with managing is returning an error on two calculated fields when I open it.
Actually when I open the report, "Calibration Due Report," from the Main Menu, I am first presented with an "Enter Parameter Value" "Format$" msg box. I click ok and the report opens but has tow textboxes that read "#Error."
I am told by my co-worker that those two textboxes should state the Month and Year.
The field on the left side of the page has this expresion as its Control Source: =[Format$]([Recalibration Due Date],"mmm yyyy",0,0)
The field on the right side of the page has this as its Control Source: =[Format$]([Recalibration Due Date],"mmm yyyy")
I've attached the db - which has worked fine until recently.
It should open to "Main Menu." Click on "Calibration Due Report" in green at lower left of form.
Any thoughts are appreciated.
Thank you,
Tim