send report to web server

  • Thread starter Thread starter ad
  • Start date Start date
A

ad

Hi
I have automated the process of sending a report to customers by attaching the report (html format) to an email. It has been working
pretty well except from time to time they say they didn't receive the report.

DoCmd.SendObject acSendReport, "TheReport", acFormatHTML, Me!email, "", "", _
"emailSubject", "emailBody greetings etc", True, "template1.html"

What I would also like to do is to send the same html file to a web server so the customer can always check from the website if they
feel they didn't receive a certain report.

How do I send a report as html to a folder of a web server? Does it involve ftp or stuff like that?

Thanks in advance.

ad
 
AD:

Yes, it would normally involve FTP'ing the file up to the web server and to
a target directory specified there. Of course you'd have to come up with
some virtual folder and file naming convetion that would make sense for the
amount of files that you are likely talking about.

However, rather than doing that, would you'd normally do (as a FAR better
solution) is to have a connection between your db and the web server where
the information that you are currently e-mailing as a report, could be
retrieved dynamically as a query from the db source and output as an html
page for the user to view in the browser rather than having a file to
download. They can then print the information from their browser.

--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

ad said:
Hi
I have automated the process of sending a report to customers by attaching
Click to expand...
the report (html format) to an email. It has been working
pretty well except from time to time they say they didn't receive the report.

DoCmd.SendObject acSendReport, "TheReport", acFormatHTML, Me!email, "", "", _
"emailSubject", "emailBody greetings etc", True, "template1.html"

What I would also like to do is to send the same html file to a web server
Click to expand...
so the customer can always check from the website if they
feel they didn't receive a certain report.

How do I send a report as html to a folder of a web server? Does it
Click to expand...
involve ftp or stuff like that?
 
Steve
That sounds like a perfect solution. But I have no idea of how to connect the two. The Access database is in our local network drive
and the website is hosted remotely, actually in US. To some extend I can code Access and I can use php to program on the web server
side, but I don't know if I can connect the two and how.

Please advise. Thanks in advance.

ad
 
ad:

What you'd need to do is to ftp up to the web server a "snapshot" of the
database data, i.e. a static copy of the data on a periodic (daily?) basis.
You can notify your customers that the update is daily should they want to
query the web site. Check with your ISP as to what programming interfaces
they support e.g. PHP, ASP, Cold Fusion etc.


--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

ad said:
Steve
That sounds like a perfect solution. But I have no idea of how to connect
Click to expand...
the two. The Access database is in our local network drive
and the website is hosted remotely, actually in US. To some extend I can
Click to expand...
code Access and I can use php to program on the web server
 
Have you considered using the Pages option in Access. Version 2000 and up should allow you to create a webpage which is always current. There is a wizard similar to reports, and you should be about to recreate the report that way. The other option is to open your report and do a save as Data Access Page, the only problem with the second method is that if the report is more then one page, you will have more then one html page. But either way your customer will have access to the most current information at all times

Jessica
 
Steve
Yes PHP on the web server. So all I need is to make this daily ftp transfer automatic. Do you have any ideas as how to do so?

ad
 
Back
Top