Advance Recordset and Trigger Function...?

[Dan via AccessMonster.com]

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

 

[PC Datasheet]

If you need outside help with this, contact me at my email address below.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

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?

 

[SR]

How about having the function iterate through the recordset in the classic
"for loop" and call the word report for each cycle of the loop?

--
SR

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?