gigifarrow
asked on
Report Prints out more than one form.
I am trying to print out a reports that only print out one form.
I checked the width and the height and they are all under size for the paper format.
When I print them out with no data it only shows one form for each report in print preview.
When I try to print them with data in them it shows 8 to 10 versions of the report. I have tried everything and I dont know what else to do. below is a copy of my database with the reports in it.
helpinductionsubform.zip
I checked the width and the height and they are all under size for the paper format.
When I print them out with no data it only shows one form for each report in print preview.
When I try to print them with data in them it shows 8 to 10 versions of the report. I have tried everything and I dont know what else to do. below is a copy of my database with the reports in it.
helpinductionsubform.zip
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I'm having a hard time replicating your problem. I open frmMainHistory, select a serial number and then select print report. This opens all the reports in print preview. If I print any of the reports I get only one page. One thing you might want to change is the control source of the serial text box in rptMainHistorypg1. Currently it is unbound, which is why it's blank when printed. Also, you have rptInductionpg2b opening with the rest of the reports, however, it uses the serial text box in frmInductionChecks as a row source, which is why you get the parameter dialog box.
gigifarrow,
Please post the exact steps to reproduce this issue.
Your question title states:
"Report Prints out more than one form"
So I am confued as to why you have a "Report" that prints a "Form"
(Why not just print a Report, ...where you have much more control over the printed output)
Jeff
Please post the exact steps to reproduce this issue.
Your question title states:
"Report Prints out more than one form"
So I am confued as to why you have a "Report" that prints a "Form"
(Why not just print a Report, ...where you have much more control over the printed output)
Jeff
ASKER
What I meant to say is that I have reports that are printing out more than one copy of the report.
ASKER
Could it be my printer? When you at the print preview there is an arrow down below. That shows more than one report to print? I am so frustrated. Thanks for all you guys help though.
ASKER
It prints fine until you add data in the memo fields.
Perhaps Flyster has a better grip on this then I do, so you may wish to see if he posts back.
For me, I would like to see a sample and I would like you to post the explicit steps to recreate this issue...
For me, I would like to see a sample and I would like you to post the explicit steps to recreate this issue...
ASKER
I really Have on step and that is to input the serial number in the serial field then hit print. I have attached the database earlier.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes sir, If you look at the print view. On the lower left bottom it shows more than one page for each report to print.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I just want to thank you for all your help. Until I get the code corrected I will not ask for further help. I will give each of you points for trying.
gigifarrow,
You know how I roll.
No points if I did not help.
;-)
Just request that the Q be deleted, then repost when you get the code squared away.
;-)
Jeff
You know how I roll.
No points if I did not help.
;-)
Just request that the Q be deleted, then repost when you get the code squared away.
;-)
Jeff
ASKER
helpappendsubformInductionCheckL.zip