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 6 5269
On 18 Jul 2005 13:47:32 -0700, jd****@yahoo.co m 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
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.c om> schreef in bericht
news:11******** **************@ g43g2000cwa.goo glegroups.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
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.c om> schreef in bericht news:11******** **************@ g43g2000cwa.goo glegroups.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
On 20 Jul 2005 10:01:49 -0700, jd****@yahoo.co m 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.
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.Pri nter = Application.Pri nters("Adobe PDF")
DoCmd.OpenRepor t "rptPet", acViewNormal
Application.Pri nter = 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\r ptPet.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.co m wrote: Will you share with me the code toprint 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.
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.co m 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.Pri nter = Application.Pri nters("Adobe PDF") DoCmd.OpenRepor t "rptPet", acViewNormal Application.Pri nter = 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\r ptPet.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.co m wrote: Will you share with me the code toprint 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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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 or table within Access (not a
hyperlink). Any ideas on how to make this work?
Thanks...
|
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 want my users to be able to select a report, click on a command
button on a form, which will then automatically create the report as a
pdf file and save it to the user's machine.
I am using Adobe Acrobat (5.0 I think) and have Adobe Distiller as a
|
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 where the job is
running, the job runs sucessfully, PDF files got generated, everything
is good. If I scheduled the job to run at the time that I am not
logged into the server, Access is not able to print to the printer.
The error is pretty...
|
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 installed on our
system (under Windows 2000 Professional). Currently, we are using MS
Access 2000. Early next year we will be moving to Windows XP (probably
converting to MS Access XP as well) and have been told that Adobe
Acrobat v6 is to be installed...
|
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 in the
code as a filename it automatically saves the report based on the
report name instead of the string passed to the registry key. The code
is as follows:
'******************************************************************
'Setting value...
| |
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 anymore.
Part of the problem is that the users have no access to the registry
and can only save files on the C:\ drive to their My Documents folder.
I found this code on the web, but it doesn't work either. The files
continue to print out of my...
|
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 JavaScript
Using Visual Basic, Acrobat JavaScript Scripting Reference, Acrobat
JavaScript Scripting Guide) but I'm having trouble using the examples
for calling Acrobat Javascript from VB code. Is this something that can
only be done in Visual...
|
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 have the full version of Adobe Reader 7.0 !
The final goal is to print a PDF-file from access after selecting the file
in a browser.
|
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 directory to which the filename should be saved. The routine adjusts registry values to achieve its aim.
Now, it works, but not quite as I would like it. I originally thought that I would be able to adjust a registry key (such as...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| | |