Solved

First Page of MultiPage document prints blank but looks fine in Preview

Posted on 2014-01-28
3
432 Views
Last Modified: 2014-01-31
I've set up a multi page report/document for my client.  Each of the 5 pages has its own unique verbiage and pulls different fields from my DB.

Based on advice from EE I created a main report that has all five pages as subforms.  It had been printing fine but I got word this morning that the first page is a blank sheet of paper.  The next 4 print as they should.

I first put the report on the screen in preview mode and everything looks perfect.  All five pages formatted as they should.  It's only use they use the Print... option, selecting all pages to print that this problem occurs.

I suggested as a temporary work around to just print page 1 of 1 in the print dialog box, but that prints a blank sheet of paper also.

I verifed that the margins ares correctly on every individual report/page and on the overall report that holds all five subforms.
0
Comment
Question by:mlcktmguy
  • 2
3 Comments
 
LVL 1

Author Comment

by:mlcktmguy
ID: 39815873
More info,  I was going to suggest that they export to snapshot format and print that.  Snapshot best preserves the formatting.  That didn't work though, first page is blank when exported as snapshot also.

I also0 set the Visible property to No for all report heades and footers since there is nothing in them anyway.  Still had the same result.
0
 
LVL 34

Accepted Solution

by:
PatHartman earned 500 total points
ID: 39816176
The report may be corrupted.  If you have one from a backup, see if it works.  If the old copy works, try the usual compact and repair/decompile/copy all objects into a new empty database to see if you can get rid of the corruption.

If there is a code module to the report, copy the code into notepad and then delete it from the report.  Compact and repair.  Then paste the code back.
0
 
LVL 1

Author Comment

by:mlcktmguy
ID: 39816575
Since posting the issue I discovered what was causing it but I'm keeping the question open because I still don't have a resolution.

Prior to today's release, when the users entered a payment plan for a customer three report/documents were generated in preview mode.  An agreement, a cover letter and payment coupons.  All generated on standard paper in portrait mode.  Everything was cool.

The user requested that an account statement also be generated with the three other documents.  I added the generation of the account statement to this process.  The account statement prints in landscape mode.  That was the only change I made.  After that, all documents looked fine in preview mode but the agreement printed a blank page when sent to the printer.

When the problem occurred today. I made many many changes to the agreement trying to get it to print correctly. What eventually resolved the problem was removing the generation of the account statement.  Once I removed it, the agreement started printing perfectly again.

The big question is why did the generation of the statement. It is simply a DoCmd.OpenReport "Statement", acPreview

The user really want all document to generate together but until I know why this occurred and how to resolve it I can't do that.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now