Question Access printview export to Outlook as pdf or save as pdf problem

[Kobus-Dippenaar]

Good day to you all.

All of a sudden my Access 2007 causes a problem when converting a printview page as a pdf file to outlook. Even when I save/publish it as a pdf to disc.
(It vertically cuts off a quarter of the page vertically.
see images.

Appreciate your feedback.

Blessings,

Kobus

 

[CJ_London]

just some suggestions - perhaps you have modified the report and it will no longer fit on the page - or perhaps you have changed the paper size, borders/orientation.

 

[Kobus-Dippenaar]

CJ Thanks, but I haven,t change to program, it was standard for 3 years!!!
I have a novaPDF printer installed. In word it picks up the driver but not in Access.
The save as option when selecting PDF as output, what does the save as dialog box use, or windows for that matter to format the pdf page? Also within the print option Access doesn't see the novaPDF driver. It comes back with a no printer driver installed.

 

[CJ_London]

I'm out of suggestions - all I can say is if something that has worked for years just stops working or changes the way it works - then something else has changed.

Perhaps run from a backup and see if that resolves the problem, if so, implies a corruption in your code

 

[Minty]

It sounds like something else has been installed or updated that has caused the issue. I'd check for recently added programs that may use a print to pdf option.

 

[Kobus-Dippenaar]

Minty,

I do not understand. I have'nt made changes to this DB set. I worked on other Data bases. I havetested another DB, my Cashbook and it exports to outlook, change the file to pdf, margins are fine.

OK. I'll open a Blank DB import some forms and tabels, and do a test.

Blessins.

 

[Kobus-Dippenaar]

I forgot. On my wife's PC the same DB set running under MS2010 works!!!

 

[Minty]

I meant that some other program may have been installed / updated on that specific PC that has caused the print to pdf issue.
The fact that it works on another PC would indicate this is the case.

 

[Kobus-Dippenaar]

Minty, Thanks, I can't think of any programs, the last programs installed were virus programs, and then i modified my startup nemu.

I have 5 data bases current running, only the one is effected.

I imported the modules into a new DB......It did not solve the problem... The problem stayed.

I have converted the mdb to accdb.... did not solve it either.

:banghead:

 

[Minty]

Have you tried creating another report just to test things out ?
Logically it has to be something on your machine.

Have you tried reinstalling Access ?

 

[Kobus-Dippenaar]

Minty, OK someone said something about orientation. My Standard landscape report in a different db comes out at 75%, hence dropping off 25%.
see samples.
So the convertion via Microsoft from out of Access to the finishedpdf file in Outlook is not according to the printview.

Hope someone has an answer?

I'll redo a report and keep re-installing as the last option.

 

[Minty]

My initial thought was it looked like portrait on a landscape page - but the scaling put me off that and it had already been suggested.

Maybe the default paper size is all wrong somewhere on the windows side?

 

[Kobus-Dippenaar]

Re: [Solved] Access printview export to Outlook as pdf or save as pdf problem

Minty, Yes, It was on the Windows side. I have come to learn that the printview when exported to Outlook and converting to pdf, needs an uncorrupted default printer driver.

I have installed a new printer driver and all works fine.

[FONT=&quot]Hallelujah.


Thanks to all.

Blessings.


Kobus[/FONT]