Database Look Up from within Word... shouldn't this be easy?

Z

Zoomiest

From within Word, how do I look up an Access table, and insert the
contents of a field?

THE APPLICATION:
At our consulting company, we respond to a number of RFP's, and it
would be interesting to use a MODIFICATION of the Mail Merge features
of Office, and, specifically:

....hit a button from within Word and look up a couple of fields
located in an Access table, so I can scroll through the records (e.g.
Questions asked in the past of us in RFP's), and then select the right
response, and INSERT it, where the cursor was...

Can anyone give me any guidance on how to do that?

Zoomiest
 
A

Albert D. Kallal

Would oing this the other way around work for you?

If you build that search form and build the user interface in side of access
which is easy to do, then when you find that particular record with the
information that you need, then you could click on a button and it would
launch word and let you slect a word template to use.

in other words it significantly easier to search and find and bring up a
record in access, and then have it selects but word template you want to use
than trying to do the reverse from inside of word.

I have a nice working sample that does a merge of the current record in
access to word.

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 following 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).
 
Z

Zoomiest

Would oing this the other way around work for you?

If you build that search form and build the user interface in side of access
which is easy to do, then when you find that particular record with the
information that you need, then you could click on a button and it would
launch word and let you slect a word template to use.

in other words it significantly easier to search and find and bring up a
record in access, and then have it selects but word template you want to use
than trying to do the reverse from inside of word.

I have a nice working sample that does a merge of the current record in
access to word.

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 following pagehttp://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).


Thanks Albert, for the idea.
I didn't tell the whole story going in. When responding to RFP's often
we get Word documents sent to us, that are usually just edited
(responded to) and returned. So, we keep getting independent
documents.

So, my interest was finding a way to bring up a query interface from
within Word, and could insert the results where the cursor had been.
Your point is well taken, that its significantly easier to control the
entire environment. Another option is to re-write each RFP doc... but
that is clearly a second choice if the first can't be achieved.


-Zoomiest
 

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

Top