Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
| Search | Today's Posts | Mark Forums Read
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old October 31st, 2005, 01:03 PM
Registered User
 
Join Date: Oct 2005
Location: , Florida, USA.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Print to PDF - Can This Be Done?

I work for a bank owned by a bank holding corporation with 35+ banks and 280+ branches in 5 states. Our corporate IT office has an "approved" list of applications from which we can choose. We cannot purchase and/or install any other applications on our computers, period. :-(

With that said, we do have the Acrobat Distiller on our computers. And I'm wondering if it is possible, with VBA, to take the 40+ reports I have to generate from Access each month and print each page of the reports to a separate PDF file? I want to be able to specify the report name and location in the VBA code, rather than typing it in for each page of each report. These reports are sales incentive reports for loan officers, and each page of the reports has a field that contains the officer names. It would be wonderful to be able to use the contents of that field from each page as part of the file name.

Am I making any sense? Can this even be done? If so, are there any online code examples that will help me figure it out? If you are going to tell me to go anywhere and download anything, please don't respond to my inquiry. As I stated at the beginning of this message, I simply can't do that.

Any help would be most appreciated!
  #2 (permalink)  
Old November 1st, 2005, 04:09 AM
Friend of Wrox
 
Join Date: Jul 2005
Location: Oklahoma City, OK, USA.
Posts: 150
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yes it can be done. Adobe has sample code. You could also use the Access built in Snaphot format and viewer that is part of Office.

I can not give you any code examples since you said that you can not download anything.



Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com
  #3 (permalink)  
Old November 2nd, 2005, 05:53 PM
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

You said you "cannot purchase and/or install any other applications on our computers." Then you said, "If you are going to tell me to go anywhere and download anything, please don't respond to my inquiry. As I stated at the beginning of this message, I simply can't do that."

Please note that those two things -- installing applications vs. downloading -- are not necessarily the same thing.

Here at my job, I can download applications, e.g. EXE files, but I CANNOT INSTALL them without administrator rights. I can, however, download Word documents (DOC), Excel spreadsheets (XLS), etc. and open them up via Microsoft Office, which the IT people already put on my computer. I can DOWNLOAD everything, but I cannot INSTALL anything.

Can you, for instance, download a Word document or an Acrobat PDF file or an ASCII text file? You're downloading a file but you're not installing anything. If you can, someone can copy and paste code into a file for you to download. You can copy and paste into your VBA procedure simply by opening up Word or Acrobat Reader or NotePad, respectively, and getting the code from the file.

If you cannot download AT ALL, whether it be applications or any file whatsoever, people can still point you to a website and you can copy and paste code from there.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
  #4 (permalink)  
Old November 3rd, 2005, 12:54 PM
Authorized User
 
Join Date: Sep 2004
Location: Nanaimo, BC, Canada.
Posts: 37
Thanks: 0
Thanked 0 Times in 0 Posts
Default


I would look into this library:
I haven't tried, it yet, but I would be interested in others feedback.

You may not have to install anything, and just create a reference to this library.

http://ourworld.compuserve.com/homepages/attac-cg/



  #5 (permalink)  
Old January 9th, 2007, 07:45 PM
Registered User
 
Join Date: Jan 2007
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Boyd,

I am interested in the sample Adobe code. Where can I obtain it?

Thanks,
John

Quote:
quote:Originally posted by AccessMaster
 Yes it can be done. Adobe has sample code. You could also use the Access built in Snaphot format and viewer that is part of Office.

I can not give you any code examples since you said that you can not download anything.



Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com
  #6 (permalink)  
Old January 11th, 2007, 05:02 AM
Friend of Wrox
 
Join Date: Sep 2003
Location: Salisbury, Wiltshire, United Kingdom.
Posts: 155
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to leehambly
Default

More advice than anything...

Dont code it.

Your business estate has Adobe Distiller as a print driver, simply let people chose to print to that device or another. If you expect most users to use the distiller, then format the report for the specific driver, but why restrict them ... having said that, there are other perfectly good reasons and some perfectly good code out there for this kind of thing... my 2p worth.

Lee


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to print PDF from a child window disto Javascript How-To 3 September 20th, 2007 05:04 AM
Print to PDF from Access donrafeal7 Access VBA 5 February 25th, 2007 11:30 PM
Print PDF from Form seananderson Access VBA 2 February 20th, 2007 10:11 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.