Getting information from Access into Word

[Luc Weyn]

Hi all,

I'm very new to VBA, so my question here may look stupid or has been
answered here a dozen times. Anyway I was not able to find the answers to my
question.

I have made a small Access database in which I have 4 tables.
Table one contains (in every table there is of course a ID field) the names
of products that we do analyses on, like wheat, flour, soyabeanmeal

Table two contains the sort of analyses that we do on these products, like
humidity, protein, etc

Table three contains different methods that can be used to do these
analyses, like ISO 712, EC, etc

Table four contains the fields from the previous three tables, where we make
all the possible combinations:
for example: wheat can be analysed on humidity by method ISO something, but
also by method ICC something.

Now I want to make a letter in a Word template that shows on startup a user
form with a number of comboboxes. In the first combobox the user can choose
a product let's say wheat. When the user then clicks on the following
combobox he will only see the different analyses possible for wheat, let's
say humidity. When he then clicks on the third combobox he will only see the
different methods that can be used to analyse the humidity of wheat.

All this information should then go to the appropriate bookmarks in the Word
document.

I managed to connect to the database, because I can load a list of
laboratories in a combobox that we can have these analyses assigned to (in
case we are too busy) and then put name, address, postcode, town, etc on the
appropriate bookmarks of the Word document.

Any help is greatly appreciated.

Luc

 

[Word Heretic]

G'day "Luc Weyn" <[email protected]>,

I think you'd be better off with an access form that obtains the
values and places them into a Word template by loading the word
application with your template, and filling in the bookmarks.

Steve Hudson - Word Heretic

steve from wordheretic.com (Email replies require payment)
Without prejudice


Luc Weyn reckoned:

 

[Luc Weyn]

Hi Steve,

Many thanks for your answer, but I'm not sure that I understand what you say
:-(

Regards,

Luc

 

[Doug Robbins - Word MVP]

Take a look at the single document merge item on the following page of
Albert Kallal's website at:

http://www.members.shaw.ca/AlbertKallal/wordmerge/index.html

BTW, Albert looks so much like Bill Gates that Steve Ballmer did a double
take when he saw him sitting in the audience at a presentation that Steve
was making.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP