Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rating: Thread Rating: 2 votes, 4.50 average. Display Modes
Old 01-06-2016, 01:18 AM   #1
Kobus-Dippenaar
Newly Registered User
 
Join Date: Oct 2014
Location: Meyerton, Gauteng, ZA
Posts: 50
Thanks: 4
Thanked 0 Times in 0 Posts
Kobus-Dippenaar is on a distinguished road
Question Access printview export to Outlook as pdf or save as pdf problem

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
Attached Images
File Type: jpg Picture01.jpg (91.8 KB, 72 views)
File Type: jpg Picture02.jpg (93.0 KB, 69 views)
File Type: jpg Picture03.jpg (97.0 KB, 73 views)


Last edited by Kobus-Dippenaar; 01-06-2016 at 01:19 AM. Reason: add a note: a Page in MSWord exports, saves correctly as a pdf???
Kobus-Dippenaar is offline   Reply With Quote
Old 01-06-2016, 01:56 AM   #2
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 11,333
Thanks: 40
Thanked 3,670 Times in 3,538 Posts
CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light
Re: Access printview export to Outlook as pdf or save as pdf problem

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.
__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
Old 01-06-2016, 02:27 AM   #3
Kobus-Dippenaar
Newly Registered User
 
Join Date: Oct 2014
Location: Meyerton, Gauteng, ZA
Posts: 50
Thanks: 4
Thanked 0 Times in 0 Posts
Kobus-Dippenaar is on a distinguished road
Re: Access printview export to Outlook as pdf or save as pdf problem

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.
Attached Images
File Type: jpg Picture06.jpg (97.4 KB, 59 views)

Kobus-Dippenaar is offline   Reply With Quote
Old 01-06-2016, 02:35 AM   #4
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 11,333
Thanks: 40
Thanked 3,670 Times in 3,538 Posts
CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light
Re: Access printview export to Outlook as pdf or save as pdf problem

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
__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
The Following User Says Thank You to CJ_London For This Useful Post:
Kobus-Dippenaar (01-06-2016)
Old 01-06-2016, 02:44 AM   #5
Minty
AWF VIP
 
Minty's Avatar
 
Join Date: Jul 2013
Location: UK - Wiltshire
Posts: 6,432
Thanks: 165
Thanked 1,737 Times in 1,706 Posts
Minty is a jewel in the rough Minty is a jewel in the rough Minty is a jewel in the rough
Re: Access printview export to Outlook as pdf or save as pdf problem

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.
__________________
If we have helped please add to our reputation - click the scales symbol on the left, tick 'I approve' and leave a comment.

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Minty is offline   Reply With Quote
Old 01-06-2016, 02:58 AM   #6
Kobus-Dippenaar
Newly Registered User
 
Join Date: Oct 2014
Location: Meyerton, Gauteng, ZA
Posts: 50
Thanks: 4
Thanked 0 Times in 0 Posts
Kobus-Dippenaar is on a distinguished road
Re: Access printview export to Outlook as pdf or save as pdf problem

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 is offline   Reply With Quote
Old 01-06-2016, 02:59 AM   #7
Kobus-Dippenaar
Newly Registered User
 
Join Date: Oct 2014
Location: Meyerton, Gauteng, ZA
Posts: 50
Thanks: 4
Thanked 0 Times in 0 Posts
Kobus-Dippenaar is on a distinguished road
Re: Access printview export to Outlook as pdf or save as pdf problem

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

Kobus-Dippenaar is offline   Reply With Quote
Old 01-06-2016, 03:08 AM   #8
Minty
AWF VIP
 
Minty's Avatar
 
Join Date: Jul 2013
Location: UK - Wiltshire
Posts: 6,432
Thanks: 165
Thanked 1,737 Times in 1,706 Posts
Minty is a jewel in the rough Minty is a jewel in the rough Minty is a jewel in the rough
Re: Access printview export to Outlook as pdf or save as pdf problem

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.
__________________
If we have helped please add to our reputation - click the scales symbol on the left, tick 'I approve' and leave a comment.

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Minty is offline   Reply With Quote
The Following User Says Thank You to Minty For This Useful Post:
Kobus-Dippenaar (01-06-2016)
Old 01-06-2016, 03:33 AM   #9
Kobus-Dippenaar
Newly Registered User
 
Join Date: Oct 2014
Location: Meyerton, Gauteng, ZA
Posts: 50
Thanks: 4
Thanked 0 Times in 0 Posts
Kobus-Dippenaar is on a distinguished road
Re: Access printview export to Outlook as pdf or save as pdf problem

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.

Kobus-Dippenaar is offline   Reply With Quote
Old 01-06-2016, 03:51 AM   #10
Minty
AWF VIP
 
Minty's Avatar
 
Join Date: Jul 2013
Location: UK - Wiltshire
Posts: 6,432
Thanks: 165
Thanked 1,737 Times in 1,706 Posts
Minty is a jewel in the rough Minty is a jewel in the rough Minty is a jewel in the rough
Re: Access printview export to Outlook as pdf or save as pdf problem

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 ?
__________________
If we have helped please add to our reputation - click the scales symbol on the left, tick 'I approve' and leave a comment.

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Minty is offline   Reply With Quote
Old 01-06-2016, 03:57 AM   #11
Kobus-Dippenaar
Newly Registered User
 
Join Date: Oct 2014
Location: Meyerton, Gauteng, ZA
Posts: 50
Thanks: 4
Thanked 0 Times in 0 Posts
Kobus-Dippenaar is on a distinguished road
Re: Access printview export to Outlook as pdf or save as pdf problem

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.
Attached Images
File Type: jpg Picture07.jpg (95.9 KB, 62 views)
File Type: jpg Picture08.jpg (97.7 KB, 64 views)

Last edited by Kobus-Dippenaar; 01-06-2016 at 04:03 AM.
Kobus-Dippenaar is offline   Reply With Quote
Old 01-06-2016, 04:11 AM   #12
Minty
AWF VIP
 
Minty's Avatar
 
Join Date: Jul 2013
Location: UK - Wiltshire
Posts: 6,432
Thanks: 165
Thanked 1,737 Times in 1,706 Posts
Minty is a jewel in the rough Minty is a jewel in the rough Minty is a jewel in the rough
Re: Access printview export to Outlook as pdf or save as pdf problem

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?
__________________
If we have helped please add to our reputation - click the scales symbol on the left, tick 'I approve' and leave a comment.

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Minty is offline   Reply With Quote
The Following User Says Thank You to Minty For This Useful Post:
Kobus-Dippenaar (01-07-2016)
Old 01-07-2016, 07:19 AM   #13
Kobus-Dippenaar
Newly Registered User
 
Join Date: Oct 2014
Location: Meyerton, Gauteng, ZA
Posts: 50
Thanks: 4
Thanked 0 Times in 0 Posts
Kobus-Dippenaar is on a distinguished road
Thumbs up 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.

Hallelujah.


Thanks to all.

Blessings.


Kobus

Kobus-Dippenaar is offline   Reply With Quote
Reply

Tags
cutt off , page , pdf , printview

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I export .zip attachments from outlook, open the .zip file to save .xlsx files atr4083 Macros 1 01-31-2014 10:56 AM
Save Outlook Email as link in Access tbl TallMan Modules & VBA 2 06-26-2013 10:46 AM
Question Looking for an easy way to export 1 record from access to outlook dnelsonjga1 General 1 05-15-2009 12:24 PM
Access and Outlook integration without import/export cclambie General 9 11-06-2005 11:09 PM
[SOLVED] Export Access Table to Outlook Contacts? donalmurphy General 3 03-10-2004 04:04 AM




All times are GMT -8. The time now is 05:43 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World