Solved

MICROSOFT ACCESS 2007

Posted on 2011-02-11
3
234 Views
Last Modified: 2012-05-11
IS THERE A WAY TO ADD A PAGE NUMBER TO A PDF FILE FROM MICROSOFT ACCESS.  I AM EXPORTING MULTIPLE EXCEL FILES INTO ONE SINGLE PDF.  I WOULD LIKE TO NUMBER THE PDF PAGES.
0
Comment
Question by:centralmike
3 Comments
 
LVL 6

Expert Comment

by:andreyman3d2k
ID: 34871153
I am a bit confused -- you said to add page numbers to a PDF you are exporting from Access, but but then said you are exporting Excel files into a PDF. What exactly are you trying to do, and how is the data flowing?

Andrey
0
 

Author Comment

by:centralmike
ID: 34871455
I have ten excel spreadsheets that I had to one pdf file through vba coding.  The excel sheets dont have pagenumbers on them.  When I send the excel spreadsheets to the adobe pdf file it bookmarks each sheet.  I would like to add page numbers to the bottome of each pdf page.
Thanks Mike

0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
ID: 35196052
The easiest way...?

Put the page numbers in the Excel sheets...
(the page numbers do not show up in the worksheet, only in Print Preview (and the actual hardcopy ))

Office Button-->Print Preview-->Page setup-->Header/Footer
Select Custom header or Custom footer, then click the "Insert page Number" icon.

Then create your PDF's, they should now have the Page numbers.

JeffCoachman
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Suggested Solutions

Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

770 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