467,161 Members | 894 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,161 developers. It's quick & easy.

Industrial Database

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
Nov 15 '06 #1
  • viewed: 963
Share:
2 Replies
MMcCarthy
Expert Mod 8TB
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
Nov 15 '06 #2
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.
Nov 16 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Cherrish Vaidiyan | last post: by
8 posts views Thread by Kamlesh | last post: by
1 post views Thread by pintur | last post: by
35 posts views Thread by robert d via AccessMonster.com | last post: by
3 posts views Thread by josh.kuo@gmail.com | last post: by
1 post views Thread by =?Utf-8?B?UmFqaXYgRGFz?= | last post: by
40 posts views Thread by walterbyrd | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.