Access Runtime pdf report problem

I have an Access report which runs fine on Access runtime 2007 but has an extra blank page on Access 2010.
Can anyone help?
HKFueyAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
Advertise Here
 
peter57rConnect With a Mentor Commented:
"this page is crucial as these documents get passed to a pdf file processor,"

So you are not using Access's pdf writer?

In that case what printer are you using to preview/print the reports- are you using each machine's default printer - are they all the same - or have you set the reports to use a specific printer - is that printer installed on all machines (I suppose it's the A2010 machine we are really interested in)

I can't think of any reason why the code you posted should be a factor here, but obviously you can test it  to see.
0
 
peter57rCommented:
Is this happening on the same computer?

Is the extra page at the end?  
Is it completely blank or does it have page header and footer?

All reports or just one report?
0
 
HKFueyAuthor Commented:
OK, 3 PC's run the report fine, 2 have Access 2007 runtime, 1 has Access 2010 runtime.

2 PC's have is a completely blank page at the start of the report, this page is crucial as these documents get passed to a pdf file processor, if the page is blank it does not work.

I want page numbers to start on page 2 so I some code to do this: -

Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As Integer)

    If Me.Page = 1 Then PageFooterSection.Visible = False
   
End Sub

Could the code be causing this?
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Start Now
 
peter57rCommented:
Just one further thought - do you have any  Force New Page settings  set to  'Before Section'?
0
 
HKFueyConnect With a Mentor Author Commented:
Well...

I installed SaveAsPDFandXPS.exe (Access pdf add in)

And Win2PDF (PDF printer)

It now works fine (not sure which of the above did it!)
0
 
HKFueyAuthor Commented:
SaveAsPDFandXPS.exe was the answer, you led me to this, thanks

Andy
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.