Eddie Nugroho
Last Activity: Jun 30 '15, 02:52 PM
Joined: Nov 24 '14
Location:
-
Sorry for the late reply... I think I had done all that and didn't help. Thanks anyway. -
Thanks for your attention. Appreciate it.Leave a comment:
-
Access 2007: how to make Memo content flow to next page
My report contains a memo field (Richtext) that I put in Detail Footer section.
- The report is based on a SELECT query
- No grouping
- I couldn't put it in Detail section or report footer section. I want the memo to be written after the calculated Total
- The report seems OK in ReportView, but in the PrintPreview, the memo is printed in Page 2, leaving Page 1 with a large blank area.
Is there a way to force the memo to be...Last edited by zmbd; Dec 2 '14, 07:30 PM. Reason: [Z{Made attached images visible}][Z{Unrequested attachments are discouraged for various reasons - Please clearly explain the issue instead}] -
Thank you all... Solved the issue. In the main form I write DoCmd.OpenForm "FrmPrice". Below this line I wait for the control in the opened FrmPrice to get its value:
Then the open report command line. It works.Code:While Forms!FrmPrice!ctrlXxx = 0 DoEvents Wend
Thanks again...
I had used the DoEvents before, but without waiting for the control to get its value.Last edited by zmbd; Dec 2 '14, 06:37 PM. Reason: [Z{Please use the [CODE/] button to format posted script and formatted text - Please read the FAQ}]Leave a comment:
-
Yes, the control is empty when the report is opened. Hence the error. Tried the acDialog, but I couldn't get it to work (open the report without closing the form). Thanks anywayLeave a comment:
-
Yes, correct. It works OK if I open the report AFTER the form is fully opened.Leave a comment:
-
Vb. Open report error based on a form that is just opened.
I have a main form, FrmMain. Put a button to open "FrmPrice". Works OK. In FrmPrice I put another button that open a report, ReportOffer, based on FrmPrice. Works OK too.
I tried to put a button in FrmMain to directly open FrmPrice and then open ReportOffer, the code failed in calculated control with #error.
Tried to...Code:DoCmd.Openform "FrmPrice" DoCmd.Openreport "ReportOffer"
Last edited by zmbd; Dec 2 '14, 06:36 PM. Reason: [Z{Please use the [CODE/] button to format posted script and formatted text - Please read the FAQ}]
No activity results to display
Leave a comment: