taverny
asked on
ACCESS 97 send report to pdf in an email
Hi Experts,
we are still using MS ACCESS 97 . I just created a report in it that I would like to be able to be sent by email as a pdf . I know I can generate the report and then click print to PDF and then attach it to an email. but I would like with a click of a button from a form to be able to accomplish this task .
If it's not possible , I wouldn't mind to have a button that will do the print to pdf and naming on it's own the file that will be created and save it to a defined location.
I am trying to make this task easier for my user.
Thank you in advance.
David
we are still using MS ACCESS 97 . I just created a report in it that I would like to be able to be sent by email as a pdf . I know I can generate the report and then click print to PDF and then attach it to an email. but I would like with a click of a button from a form to be able to accomplish this task .
If it's not possible , I wouldn't mind to have a button that will do the print to pdf and naming on it's own the file that will be created and save it to a defined location.
I am trying to make this task easier for my user.
Thank you in advance.
David
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The stuff from Lebans can be fully automated and is what you want.
One other point though and the main reason for my comment; I'd get off A97 fairly soon. Support for JET 3.x has been dropped in all current products. So within a few years, you're going to find it difficult to find anything that will be able to read it. To get data out of it would require using A97 itself, dumping to something like a CSV, then importing to another format.
A97 was a solid release and product, but your dealing with a version of the database engine that is now 18 years old.
JET 4.0/ACE is still in widespread use and will be for some time. So consider upgrading to A2003 or A2010.
Jim.
One other point though and the main reason for my comment; I'd get off A97 fairly soon. Support for JET 3.x has been dropped in all current products. So within a few years, you're going to find it difficult to find anything that will be able to read it. To get data out of it would require using A97 itself, dumping to something like a CSV, then importing to another format.
A97 was a solid release and product, but your dealing with a version of the database engine that is now 18 years old.
JET 4.0/ACE is still in widespread use and will be for some time. So consider upgrading to A2003 or A2010.
Jim.
If you upgrade to Access 2007, you get PDF output for "free". One of the great things about building applications on a platform like Access is that over time, when Microsoft enhances the underlying product, your solutions can take advantage of them at little to no cost. It seems like a wasted opportunity to not take advantage of that, since solutions on other platforms are much more difficult to enhance that way.
Here's a paper I wrote about what you can get by going to Access 2007 or later: Top 13 Features of Microsoft Access That Aren't Available in Access 2003 or Earlier
If you are distributing it to other users, you can use the free runtime version of Access to do so: http://www.fmsinc.com/MicrosoftAccess/runtime/index.htm
Here's a paper I wrote about what you can get by going to Access 2007 or later: Top 13 Features of Microsoft Access That Aren't Available in Access 2003 or Earlier
If you are distributing it to other users, you can use the free runtime version of Access to do so: http://www.fmsinc.com/MicrosoftAccess/runtime/index.htm
taverny,
You may have to tweak the code a bit...
But I am sure you can get it working.
Give it a good try on your own, ...post back if you have any questions...
Jeff
You may have to tweak the code a bit...
But I am sure you can get it working.
Give it a good try on your own, ...post back if you have any questions...
Jeff
I've requested that this question be closed as follows:
Accepted answer: 500 points for Jeffrey Coachman's comment #a40581001
for the following reason:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Accepted answer: 500 points for Jeffrey Coachman's comment #a40581001
for the following reason:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
ASKER
Thank you for your prompt response.
you are right there is no easy way to output to PDF. the only way to do it is to have PDF writer installed on the machine and then when the report is displayed on the screen I can print it to the PDF driver printer, then this way I have the PDF file.
I will take a look tomorrow at your code and link to see if I can figure it out.
Thank you again,
David