Word form to inport address info from an Access database file.

[Bramston]

Hi All, I used to do this but it was too long ago to remember and things
have changed drstically since then.

Would someone please tell me the following,

I have a form template in Word for which we have to fill out the address of
up to 7 thousand properties a year. I would like to have the address and
other associated info placed into this form by accessing the Access
database. I assume VBA is the correct method but I need to know where to
look to find the codes. I also need to make other smaller databases for drop
down lists of 40 or so items as Word only allows 25 items in a list. Any
help or even sending me off in the right direction (ie:which is the best
book to read) would be most appreciated.Thanks very much in Advance.
-Bramston

 

[Doug Robbins - Word MVP]

See the following page of fellow MVP Greg Maxey's website:

http://gregmaxey.mvps.org/Populate_UserForm_ListBox.htm



--
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

 

[Bramston]

Hi All, I used to do this but it was too long ago to remember and things
have changed drstically since then.

Would someone please tell me the following,

I have a form template in Word for which we have to fill out the address
of up to 7 thousand properties a year. I would like to have the address
and other associated info placed into this form by accessing the Access
database. I assume VBA is the correct method but I need to know where to
look to find the codes. I also need to make other smaller databases for
drop down lists of 40 or so items as Word only allows 25 items in a list.
Any help or even sending me off in the right direction (ie:which is the
best book to read) would be most appreciated.Thanks very much in Advance.
-Bramston

More specifically, If I type in the address onto the Word doc form I need
the rest of the form filled out with the current owners name, address, etc.
All that info is in an access database which gets updated my another
department as required or I can update the access database from info I have
collected. I know I can use the reply from Mr. Robbins but I am not sure of
the exact process to do so. Of course any more info will help tremendously,
Thanks very much,
-Bramston

 

[Doug Robbins - Word MVP]

With 7,000 properties, you are likely to the same Owner Name applying to
more than one property so a solution that relied on typing the owner name
into a Word document is not likely to be satisfactory. I believe therefore
that you should follow the method that I suggested.

--
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

 

[Bramston]

Sorry for my confusing statement. Actually, the address is the unique
identifier and that is the required to be typed entry, I hope the rest-
owners name etc. will be drawn from the database and filled into the word
form at the required locations. I have every intention and desire to follow
your suggestion to the letter but due to my ignorance am not sure if it will
get me where I need to go. I really appreciate your help.
-Fred

 

[Doug Robbins - Word MVP]

You might find it easier to do this from Access

Take a look at the information referred to in the following post from
fellow MVP, Albert Kallal.

Quote

Actually, use my merge sample. it don't give that warning, and you don't
have to change registiry stuff etc.

The sample I have can be found here:
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

What is nice/interesting about my sample is that is specially designed to
enable ANY form with ONE LINE of code....

Thus, each time you build a new form, you can word merge enable it with
great ease.

Make sure you read the instructions from above, and you should eventually
get to the follwoing page
http://www.members.shaw.ca/AlbertKallal/wordmerge/page2.html


Note that the merge can also use a query, and thus you don't have to merge
just "one" record..

After the merge occurs, you get a plain document WITHOUT any merge fields,
and this allows the end user to save, edit, or even email the document
(since the merge fields are gone after the merge occurs).

Give the above a try.

Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(e-mail address removed)
Unquote


--
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