Currently, I run a module which generates a letter (in preview mode) using, as the source, a select query.

The user has to preview each report/letter generated for each record returned by the select query.

However, I now need to create/export a .rtf file for each report/letter previously displayed in preview mode.

I figure I have to create a recordset using the query (or an inline SQL query). I then want to read through each record in the recordset and generate the report/letter and export it to an .rtf file.

Each .rtf filename will be unique as each record in the recordset will be unique based on client id.

The client id will form part of the .rtf's filename.

Then, for each record in the recordset I need to update a value in one of the fields and reflect this back in the original database table.

Could someone please provide the code to do this? I am using DAO recordsets.


Thank you

Gill

Are you using 100% MS Access?
Access accessed through VB6 or .NET?

These sort of details really change the appropriate approach.

Sorry Brian. I am using Ms Access 2003 which uses Visual Basic 6.3

Hello Gill,

Check this link..
http://www.geocities.com/raghavendra...ort_To_RTF.zip

I just done this by reading your post. If anything which is not the way you
expected, then let me know, will do the changes.

It takes the all data from table and filters the report with each record
and exports to .rtf file and goes to second record. (i guess this is what
you looking for)

It puts all .rtf files in MyDocuments (by default).

This db is done in Access-XP, with dao3.6 and open the db and go to the forms section, and open the form1 and click that button. Just
see is this the way, and check the remaining things, like table,
report, code.

Hope this helps.


With Regards,
Raghavendra Mudugal

Thank you very much, Raghavendra .

This is a very usual piece of code.

I gather I can use the initial query that my report currently uses and place output in a temporary table. I can then change my report to read the temporary table instead.

Gill

Hello Gill,

I did'nt understood what you ment. Its better check the code (that link)
and let me know if any.

Hope this helps.

With Regards,
Raghavendra Mudugal