Access/Word Forms

  • Thread starter Thread starter Sharon
  • Start date Start date
S

Sharon

I have a main form and a subform (one to many
relationship).

The main form contains patent information: i.e., Patent
No., Title, filing date, Inventors, etc.
The subform contains a list of inventors and their home
addresses, citizenships, etc.

I have forms in Word that I need to fill in using this
Access database. The problem is that there could be more
than one inventor on each patent. How do I get the Word
document to recognize that there is more than one
inventor listed on the form? The subform record just has
Inventor, Address, City, State, Zip, Citizenship.
 
There is no straightforward way of doing what you want to do by
merging to Word. What you have to do is use Automation to write from
Access VBA code into a Word Document. The 2000 and 2002 editions of
Litwin et al.'s excellent Access 200n Desktop Developer's Handbooks
have very good chapters on this and some valuable sample code.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Two Table Query 3
How to always get the top level form reference, when calling from any subform/subform... 0
Main Form and two Subforms 2
Report/Query Question. 2
Subform Based on Same Table 1
same subform used in two different forms 2
Using an append query in a subform 1
Update subform with combobox change on main form 1

Back
Top