Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

MICROSOFT ACCESS 2007

Posted on 2011-02-11
3
Medium Priority
?
254 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 2000 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

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Question has a verified solution.

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

User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
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…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

963 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