CliffHanger9
zigga zigga
- Local time
- Today, 18:02
- Joined
- Nov 1, 2004
- Messages
- 20
hi all -
I have a form with a lot of records in it ( > 150)
on this form is a button which generates a word document report based on the info in the form
I need to create a macro/function that will trigger the report generation function advance the form recordset and repeat until it gets to the end.
(in word i have a document_open event which will send the report to the printer spool and close doc)
I think this is a simple thing to do but i dont know enough VBA to acomplish this recordset advance, and call function... probably on somekind of loop or something?
Any help is greatly appreciated in advance!!!!!!!!!!!!!!!!!!1
Cheers-
Dan
I have a form with a lot of records in it ( > 150)
on this form is a button which generates a word document report based on the info in the form
I need to create a macro/function that will trigger the report generation function advance the form recordset and repeat until it gets to the end.
(in word i have a document_open event which will send the report to the printer spool and close doc)
I think this is a simple thing to do but i dont know enough VBA to acomplish this recordset advance, and call function... probably on somekind of loop or something?
Any help is greatly appreciated in advance!!!!!!!!!!!!!!!!!!1
Cheers-
Dan
