Create individual reports for FTP

[AlanM]

Hi All

Anyone had any experience of looping through a recordset, creating individual report files (preferably PDFs) based on customer/member number, and then FTP'ing each report to another location?

We want to enable members to view reports on our website rather than send them in the mail, as is the curent practice.

Each report is for an individual, and contains only their information. Currently we produce the report for all members in one run, and physically envelope each members.

Any sample code would be appreciated.

Many thanks
AlanM

 

[shudini]

Do you want to FTP it to another location, or just put it into a specific directory for the member to pick it up from?

Check out this thread http://www.access-programmers.co.uk/forums/showthread.php?t=124020 for my post on looping through a recordset and creating PDF reports.

As far as moving each report to another location, this can be done as well, assuming you maintain a table of the location you want the individual reports to go to. (if you want them to go to one place, you can just hard code it, but i'm assuming this is not the case)

 

[MicroE]

Here is a function to FTP.
http://www.myaccesstips.com/Functionality/ftp.html