By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,863 Members | 853 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,863 IT Pros & Developers. It's quick & easy.

Multi-page access report won't print

P: 15
I have an Access database front end/backend situation. The users create a record in the main form and add subrecords in the subform. When complete, they print a report that is very often multi-page but the report will only print the the subform records which will fit on the first page for some users. Can anyone tell me why that would be?
Dec 26 '07 #1
Share this Question
Share on Google+
7 Replies


jaxjagfan
Expert 100+
P: 254
Are you printing the forms or an actual report?. Forms take a bit more work to print records and subforms and get everything you need printed. Especially if the subforms contain multiple records and scrolling.

Design a report with a sub-report and use a command button to print this report on demand.
Dec 26 '07 #2

P: 15
Are you printing the forms or an actual report?. Forms take a bit more work to print records and subforms and get everything you need printed. Especially if the subforms contain multiple records and scrolling.

Design a report with a sub-report and use a command button to print this report on demand.
I actually designed a report and created a button that prints the report based on the open record. Some computers will print the multiple pages and most will not. I cannot seem to find anything common that would prevent one pc from printing all of the subform records and others not.
Dec 26 '07 #3

jaxjagfan
Expert 100+
P: 254
Try refreshing the data. The current info entered into form/subform is not actually stored in the table (nor available for reports) until a refresh, requery, or you navigate to the next record.
Dec 26 '07 #4

P: 15
All the data is refreshed before the report is printed. This seems to be pc specific. It is not an issue with the database itself. Everyone uses a copy of the same front end however it works for some and not others. It is either something that needs to be installed on the pc or for Access...Even the IT guy can't figure this one out. There is not user security set up on this database either.
Dec 26 '07 #5

jaxjagfan
Expert 100+
P: 254
Take a look at the default printer drivers for each user. Some of my users default to an HP Laser whereas others default to an IBM.
Dec 26 '07 #6

P: 15
We are all defaulted to the same printer. We are all in the same department.
Dec 26 '07 #7

missinglinq
Expert 2.5K+
P: 3,532
These type of problems are usually driver related. Maybe there's a difference in the driver version between PCs that work properly and those that don't, and it's not always the latest version that works correctly! Often, the problem comes because a driver is updated.

Welcome to TheScripts!

Linq ;0)>
Dec 26 '07 #8

Post your reply

Sign in to post your reply or Sign up for a free account.