473,224 Members | 1,978 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,224 software developers and data experts.

Access 2003, Question concerning Adobe Acrobat

We recently had to upgrade the computers in our company. Now our
office's website on our company intranet no longer recognizes reports
saved in snapshot format. We get an error message that the file we are
downloading "cannot be opened by the default program. It is either
corrupted or it has an incorrect file type." We had no problem until
our upgrade, but our IT department says there's no fix. My question is
concerning Adobe Acrobat. At the risk of sounding stupid, if I were to
buy and install this software, how would I save my reports as PDF
files? Would Access 2003 automatically recognize that I could output
reports to Adobe Acrobat, giving PDF as an option in the macro design
window as it does Snapshot or HTML, or would I have to write code to
save reports as PDF files?

TIA,
JD

Nov 13 '05 #1
6 5231
On 18 Jul 2005 13:47:32 -0700, jd****@yahoo.com wrote:

You would have to write code to "print" a report to the PDF Printer.
Fairly easy to do since Access 2003 has good support for printing to
various printers (i.e. the new Printer object).

I hope your IT dept meant to say "there is no fix that WE can think
of". Perhaps you could outsource this portion of the project. I don't
think you can't use Snapshot files anymore.

-Tom.

We recently had to upgrade the computers in our company. Now our
office's website on our company intranet no longer recognizes reports
saved in snapshot format. We get an error message that the file we are
downloading "cannot be opened by the default program. It is either
corrupted or it has an incorrect file type." We had no problem until
our upgrade, but our IT department says there's no fix. My question is
concerning Adobe Acrobat. At the risk of sounding stupid, if I were to
buy and install this software, how would I save my reports as PDF
files? Would Access 2003 automatically recognize that I could output
reports to Adobe Acrobat, giving PDF as an option in the macro design
window as it does Snapshot or HTML, or would I have to write code to
save reports as PDF files?

TIA,
JD


Nov 13 '05 #2
Hi JD,

What you could do is install a (free) PDF writer program. You can use the
one from Adobe itself but that cost you some money. When you have installed
the program you will find a new (pseudo) printer that isn't printing on
paper but to a pdf file format which you can open with Adobe reader.

When you can program in your app you can write the report to the pdf file
and next open it in Adobe Reader. I have implemented this solution at a
company who wanted to scan all their documents. I write the images into a
pdf - file and next open them in AR.

Good luck!

Wilbert van Diemen
<jd****@yahoo.com> schreef in bericht
news:11**********************@g43g2000cwa.googlegr oups.com...
We recently had to upgrade the computers in our company. Now our
office's website on our company intranet no longer recognizes reports
saved in snapshot format. We get an error message that the file we are
downloading "cannot be opened by the default program. It is either
corrupted or it has an incorrect file type." We had no problem until
our upgrade, but our IT department says there's no fix. My question is
concerning Adobe Acrobat. At the risk of sounding stupid, if I were to
buy and install this software, how would I save my reports as PDF
files? Would Access 2003 automatically recognize that I could output
reports to Adobe Acrobat, giving PDF as an option in the macro design
window as it does Snapshot or HTML, or would I have to write code to
save reports as PDF files?

TIA,
JD

Nov 13 '05 #3
I'd like to thank each of you for your reply. I was given permission
to buy the Adobe Acrobat Writer software, but before I do, I have a
couple of questions. We output reports from Access to one of our
network drives to which all employees have "read-only rights", then
create hyperlinks to the reports from our intranet website so the
employees can easily view them. Will you share with me the code to
print a report to the PDF printer using Printer Object? Also, how
would I output the report to our network drive? Currently, using a
macro, I'm given the opportunity to enter the full path of the report's
destination. Again, thanks!

Wilbert van Diemen wrote:
Hi JD,

What you could do is install a (free) PDF writer program. You can use the
one from Adobe itself but that cost you some money. When you have installed
the program you will find a new (pseudo) printer that isn't printing on
paper but to a pdf file format which you can open with Adobe reader.

When you can program in your app you can write the report to the pdf file
and next open it in Adobe Reader. I have implemented this solution at a
company who wanted to scan all their documents. I write the images into a
pdf - file and next open them in AR.

Good luck!

Wilbert van Diemen
<jd****@yahoo.com> schreef in bericht
news:11**********************@g43g2000cwa.googlegr oups.com...
We recently had to upgrade the computers in our company. Now our
office's website on our company intranet no longer recognizes reports
saved in snapshot format. We get an error message that the file we are
downloading "cannot be opened by the default program. It is either
corrupted or it has an incorrect file type." We had no problem until
our upgrade, but our IT department says there's no fix. My question is
concerning Adobe Acrobat. At the risk of sounding stupid, if I were to
buy and install this software, how would I save my reports as PDF
files? Would Access 2003 automatically recognize that I could output
reports to Adobe Acrobat, giving PDF as an option in the macro design
window as it does Snapshot or HTML, or would I have to write code to
save reports as PDF files?

TIA,
JD


Nov 13 '05 #4
On 20 Jul 2005 10:01:49 -0700, jd****@yahoo.com wrote:
Will you share with me the code to
print a report to the PDF printer using Printer Object? Also, how
would I output the report to our network drive? Currently, using a
macro, I'm given the opportunity to enter the full path of the report's
destination. Again, thanks!

Hi
I followed the other route and installed Cute PDFwriter (free, though not sure with what licence).
This installs as if it is a printer, so to generate the pdf file from a report you just print it
to the pdfwrite printer. I think it asks for a file name each time though. There was a recent
thread in the group on this.

On the snapshot front.the same occurred to my programs when the client changed the server,
but I just downloaded and re-installed the latest SNP viewer and it worked. However pdf output
is less hassle all around.
Nov 13 '05 #5
I need a little more help as I am fairly new to VBA. I have purchased
and installed Adobe Acrobat 7.0. On a form in my database in a
button's on click event, I placed the following code:

Application.Printer = Application.Printers("Adobe PDF")
DoCmd.OpenReport "rptPet", acViewNormal
Application.Printer = Nothing

After running the code above, I get a "save as" dialog box that prompts
me to select the location to which to save the file. What I want to do
is write some code to include with the code above that will
automatically save the file in a location on our network - for example,
save the file as Z:\Accounting\rptPet.pdf. This way, all the user has
to do is click the button and he's done.

I would appreciate any help you can offer.

TIA, JD
rude person wrote:
On 20 Jul 2005 10:01:49 -0700, jd****@yahoo.com wrote:
Will you share with me the code to
print a report to the PDF printer using Printer Object? Also, how
would I output the report to our network drive? Currently, using a
macro, I'm given the opportunity to enter the full path of the report's
destination. Again, thanks!

Hi
I followed the other route and installed Cute PDFwriter (free, though not sure with what licence).
This installs as if it is a printer, so to generate the pdf file from a report you just print it
to the pdfwrite printer. I think it asks for a file name each time though. There was a recent
thread in the group on this.

On the snapshot front.the same occurred to my programs when the client changed the server,
but I just downloaded and re-installed the latest SNP viewer and it worked. However pdf output
is less hassle all around.


Nov 13 '05 #6
I just wanted to post the fix that I found for this in case anyone else
has the same problem I've been having. I never found any code - I
changed a setting in the properties of the printer. I went to Start,
Printers. I right-clicked on Adobe PDF printer and selected
Properties. On the Advanced tab, I selected Printing Defaults. On the
Adobe PDF Settings tab, the Adobe PDF Output Folder was defaulted to
"Prompt for Adobe PDF filename". I changed this to the folder on our
network where I want my file to be saved.
jd****@yahoo.com wrote:
I need a little more help as I am fairly new to VBA. I have purchased
and installed Adobe Acrobat 7.0. On a form in my database in a
button's on click event, I placed the following code:

Application.Printer = Application.Printers("Adobe PDF")
DoCmd.OpenReport "rptPet", acViewNormal
Application.Printer = Nothing

After running the code above, I get a "save as" dialog box that prompts
me to select the location to which to save the file. What I want to do
is write some code to include with the code above that will
automatically save the file in a location on our network - for example,
save the file as Z:\Accounting\rptPet.pdf. This way, all the user has
to do is click the button and he's done.

I would appreciate any help you can offer.

TIA, JD
rude person wrote:
On 20 Jul 2005 10:01:49 -0700, jd****@yahoo.com wrote:
Will you share with me the code to
print a report to the PDF printer using Printer Object? Also, how
would I output the report to our network drive? Currently, using a
macro, I'm given the opportunity to enter the full path of the report's
destination. Again, thanks!

Hi
I followed the other route and installed Cute PDFwriter (free, though not sure with what licence).
This installs as if it is a printer, so to generate the pdf file from a report you just print it
to the pdfwrite printer. I think it asks for a file name each time though. There was a recent
thread in the group on this.

On the snapshot front.the same occurred to my programs when the client changed the server,
but I just downloaded and re-installed the latest SNP viewer and it worked. However pdf output
is less hassle all around.


Nov 13 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Avalanche | last post by:
Greetings all. I'm building a database (Access 2003) of applicants. Included in this database I would like to include the PDF applications for individuals in the database, accessable from a form...
7
by: dog | last post by:
I've seen plenty of articles on this topic but none of them have been able to solve my problem. I am working with an Access 97 database on an NT4.0 machine, which has many Access reports. I...
11
by: Grasshopper | last post by:
Hi, I am automating Access reports to PDF using PDF Writer 6.0. I've created a DTS package to run the reports and schedule a job to run this DTS package. If I PC Anywhere into the server on...
12
by: DGB | last post by:
Hello All, I have been doing quite a bit of research in this group and have not been able to find the answer that I am looking for. Here is my issue. We currently have Adobe Acrobat v5...
2
by: BikeToWork | last post by:
I found code online which uses Windows API's to save Access reports to pdf format files. I'm using the full version of Adobe Acrobat Professional 7.0. The problem is that regardless of what I put...
0
by: musicloverlch | last post by:
I used to be able to create PDFs, automatically save them to a file, and mail them out to people. This was on Access 97 with Windows NT. We've changed to Windows XP and Access 2003. Doesn't work...
0
by: Per | last post by:
Is there anyone who's been able to program the new Adobe Acrobat Javascript (7.05) using Visual Basic in Access 2003? I have downloaded the documentation from Adobe's website (Programming Acrobat...
6
by: Filips Benoit | last post by:
Dear All, All 3 codes, copied from internet, triggers error 429 : ActiveX component can't create object ! No compile error. I have the reference set to Adobe Acrobat 7.0 Type Library I do not...
1
by: billelev | last post by:
Here is some code that I have adapted slightly. It allows a report to be printed to a specific location. It works by calling SaveReportAsPDF and specifying the access report name, and the root...
1
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
0
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
by: jimatqsi | last post by:
The boss wants the word "CONFIDENTIAL" overlaying certain reports. He wants it large, slanted across the page, on every page, very light gray, outlined letters, not block letters. I thought Word Art...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.