Access form with corresponding doc.

[micropc]

Hello all,
I have a very simple question. I was wondering if it would be possible for
someone to shed some light a something for me. If I create an access form and
enter into all of the information that I would like to require, is there a
way for me to first, import a word document, and second, have certain parts
of the form link to the corresponding text in my document? If so does anyone
know where I can find some basic instruction! Essentially, is what I am
trying to accomplish is this. I have a proposal that was built in word. I
would like to keep the scope of work the same but create an access form that
I can enter certain items that change. Such as customer info, multiple items
or products that I can select through radio buttons and have the information
populate throughout my document. The key here is that the document dosen't
necessarily have to stay a word document but can I import the template into
access and have access generate the document with the corresponding changes?
I wanted to use access because of the tables and I can essentially store
previous client records.I have spent a little bit of time editing word to
accomplish some of this, maybe you can help further. I so far have
established a table to enter basic information like client information to be
disbursed throughout the document. My trouble's are two fold, first, I have
many item variables that can be added to the scope of work, hence the radio
buttons to select each of them. That was my first problem adding the radio
buttons and getting them to work within the word document. Second, is the
fact that I have some graphic items such as banners placed throughout the
document and by adding these available work items, the justification of my
images gets all jacked up? Any ideas? I'm certain I can do it I just don't
know what I am looking for. But if I can pointed in the right direction I
would greatly appreciate it. Thank you all so much for your help!
Take care,Thanks.
Cort-

Also, what I have seen in access where you can have what looks like a
document or a page formatted for print, but within that page in access it has
drop down lists and can be edited for printing?

 

[Piet Linden]

I'm not even going to try to answer all these questions...

One way to handle this is to use automation to pass data from your
database to a template in Word via automation. You can write values
from your DB into bookmarks and/or pass recordsets and convert them to
tables in Word. There's an example in Access [your version]
Developer's Handbook Volume 1. You can write queries that return
records and then use those to pass data to Word. The code in the book
uses ADO, so you cannot have any characters in your query name that
ADO does not like, e.g. spaces, for one...

Hope that helps a little.

 

[Gina Whipp]

Have a look at Albert Kallal's Word Mail Merge
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

About half way down the page. This should allow you to keep the document in
Word and with the tables in Access get what you want.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index.htm