Industrial Database

[apartain]

I use MSAccess a lot, but rarely VB code within it.

I need to:
Run a set of reports for customer, output to html (saved in the file folder which is named after the customer number), run reports for second customer, output to html, etc. until this has been done for every record in the customer table.

I also need to ftp each of the reports to web server.

Can this be done all in one click?

File structure on web:
Clients
0015
Equipment Report
Inspection Report
Announcements Report
Employee Training Report
...etc.
0016
Equipment Report
Inspection Report
Announcements Report
Employee Training Report
...etc.


ang

[MMcCarthy]

You would do better to post this in the Access forum. Access uses VBA which is slightly different from VB.

I use MSAccess a lot, but rarely VB code within it.

I need to:
Run a set of reports for customer, output to html (saved in the file folder which is named after the customer number), run reports for second customer, output to html, etc. until this has been done for every record in the customer table.

I also need to ftp each of the reports to web server.

Can this be done all in one click?

File structure on web:
Clients
0015
Equipment Report
Inspection Report
Announcements Report
Employee Training Report
...etc.
0016
Equipment Report
Inspection Report
Announcements Report
Employee Training Report
...etc.


ang

[lordcenon]

I use MSAccess a lot, but rarely VB code within it.

I need to:
Run a set of reports for customer, output to html (saved in the file folder which is named after the customer number), run reports for second customer, output to html, etc. until this has been done for every record in the customer table.

I also need to ftp each of the reports to web server.

Can this be done all in one click?

File structure on web:
Clients
0015
Equipment Report
Inspection Report
Announcements Report
Employee Training Report
...etc.
0016
Equipment Report
Inspection Report
Announcements Report
Employee Training Report
...etc.


ang

Crystal Report is very good in generating reports and which can be converted to HTML specifically for VB.

To automate all in one click you may need to use a MACRO recorder, a separate utility program, or if you are in VB you may try experimenting SENDKEYs.