Access prints multiple pages

Access novice here.  Very small, basically uncomplicated Access DB runs a report and subreport from basic queries. For some reason, in the subreport, if there is more than one entry, the print function prints a page per line item.  I dont know how to show you the actual code involved so if you ask for more information, you will have to explain that too.  Also if you make suggestions, keep in mind I may not know exactly where you are referring to.
Thanks in advance!
Sara
LVL 2
samiriseAsked:
Who is Participating?
 
frankyteeConnect With a Mentor Commented:
there were several errors
1) your main report query also included the po details table. i believe you should only include suppliers and po, po details should be in the subreport
2) your subreport query a select statement from your main query, thus it was not showing the data you needed
3) your subreport was not linked to your main report in the report design (i.e linkchildfields, linkmasterfields, both need to be set to PurchaseOrderNumber)
4) your report query had the purchaseordernumber hardcoded in the query. that means you would need to reset the query every time you run the report. this most likely means you are opening the report directly from the db window -> you should open reports using code via a form.(another question altogether, look at below question on how to dynamically filter reports at runtime).
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_22891573.html

5) look at the new reports and queries i created below. it shows all purchases (1 per page) so you would need to use code to filter for a particular purchase order.

main report:      rptSupplyRequest_Frank
report query:      qFrankPOQuery

subreport:      rptPOQuerySubReport
subrpt query:      qFrankReportSubQuery

looks like i can't upload from office so i'll have to load it from home
0
 
frankyteeCommented:
off the top of my head, check something like "force new page" in the report design for the detail group and other groups
0
 
samiriseAuthor Commented:
Nope, I set Force new page to None on all details and other sections. Something else?
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
samiriseAuthor Commented:
Here's an interesting twist to this issue:

The main report :  'Supply Request' has a subreport 'Supply Detail Query'

The subreport will show one page only on print preview.
Whether the subreport is including in the main report or not, the report 'Supply Request' prints a page for every item in the detail or four or so pages.  Its very strange. I have looked at all of the settings I can think of. Is there anyone out there who would be willing to look at a sanitized version of the database in its entirety and play with it?
0
 
frankyteeCommented:
zip up your db and upload it into EE http://www.ee-stuff.com/Expert/Upload/upload.php
and post the link
0
 
samiriseAuthor Commented:
okay will do on Monday. Thanks!
0
 
samiriseAuthor Commented:
Frankytee, Is there a way to save off a copy of the Database without any data? I am not certain that my employer would like me sending this out.
0
 
samiriseAuthor Commented:
Nevermind, I deleted tables that were sensitive. Just have to trust you otherwise.

 https://filedb.experts-exchange.com/incoming/ee-stuff/5024-ADP2002.zip

Thanks!
Sara
0
 
frankyteeCommented:
sami, i'll have a look when i have time. with my current workload and the number of questions i've been attending to EE you dont need to worry about sensitive data.
0
 
frankyteeCommented:
file upload doesnt seem to work now. put your email on your profile, post a comment here and i'll email the file to you.
0
 
samiriseAuthor Commented:
My email is samirise@hotmail.com I am not sure how to export that report into my production database so if you could help in that area, I would appreciate it. He is use to manually editing the PO number field each time he creates a new one. I am not sure why he does it this way except perhaps he doesnt know how to dynamically create a new one. In any case, I need to keep the process as close to the same as before.  Will I have what I need here? It seems like there is something missing.... I guess I'lll just wait and see. Thanks so much btw, you'll make me a star if I turn this around.
0
 
frankyteeCommented:
i've emailed the file to you as EE upload is still not working
0
 
frankyteeCommented:
sami, has this been resolved?
0
 
samiriseAuthor Commented:
I havent forgotten to close it, we just got pulled onto a project last week. I hope to have an update this week. Thanks for checking in!
0
 
samiriseAuthor Commented:
I passed this over to our original DB creator and am not sure where it stands, but I will credit you the solution cause I have every confidence.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.