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?
 
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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
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
All Courses

From novice to tech pro — start learning today.