Pasting a form's content to a Word Document

[smitty691]

I have an Access Database with Customer Returns information in it. My boss uses info from this database as part of her monthly report to her boss.

So what happens now is that the data (return number, date, cause, resolution) populates a form with continuous records. I know I should use a report for that, but i can control the formatting in the next step easier with a form.

I tell Access to select all records, copy, open new Word document, paste in RTF format to that document and the output looks just like the table my boss used to create from her old Excel sheets.

The open new document step is, to me, unneccessary. I'm hoping that someone here can tell me how to tell Access to paste the info at the place her cursor is located in the word document she already has open (her monthly report) so that she doesn't have to copy form the created doc to her report.

Thanks for reading this far!

 

[PHV]

Have you consider to use something like this ?
Set myWord = GetObject(, "Word.Application")
to get the word instance of her already open document.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244