Solved

MICROSOFT ACCESS 2007

Posted on 2011-02-11
3
238 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…
The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
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 a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

679 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