Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to send a subform datasheet field data to Word by automation

Status
Not open for further replies.

2378

Technical User
Apr 20, 2002
1
US
Hi'
I have designed an ACCESS database which has a form and subform with a sub subform in it. I have tried automating to send a current record to Word and succeeded all the way except the sub sub form data.

The sub sub form is in datasheet view with few records in it and I could only reference one record in it. The Book mark techniq works but only one record data is sent.IS THERE A WAY I CAN TRANSFER ALL THE RECORDS From A SPECIFIC field of my sub-form datasheet; to my book mark in MS Word, either by delimited or fixed length, or any other way? Pl. help!
 
Have you tried creating a temp table with the data you want and then using that for for the word datasource?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top