Lookup MS Access table from MS Word 
Author Message
 Lookup MS Access table from MS Word

Is it possible to build a lookup field on a Word document
and looking up that index field in a MS Access table,
returning row entries?  

e.g. Enter "101" in customer field of a Word document,
looking up "101" in a MS Access "CustomerTable" and
returning "101", "ABC Store", "1400 Broadway", etc in MS
Word.

Can anyone be kind enough to provide a link to a site that
shows how this is done?

many thanks!



Sun, 18 Dec 2005 05:21:31 GMT  
 Lookup MS Access table from MS Word
Hi Eric,

See the article "Access a database and insert into a Word document the data
that you find there" at:

http://www.mvps.org/word/FAQs/InterDev/GetDataFromDB.htm

Please respond to the newsgroups for the benefit of others who may be
interested.

Hope this helps
Doug Robbins - Word MVP

Quote:
> Is it possible to build a lookup field on a Word document
> and looking up that index field in a MS Access table,
> returning row entries?

> e.g. Enter "101" in customer field of a Word document,
> looking up "101" in a MS Access "CustomerTable" and
> returning "101", "ABC Store", "1400 Broadway", etc in MS
> Word.

> Can anyone be kind enough to provide a link to a site that
> shows how this is done?

> many thanks!



Sun, 18 Dec 2005 05:59:18 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Accessing current record in MS Access with DDE from MS Word

2. How does one look at data in an open MS access aplication from MS Word

3. Working with MS Word and MS Access

4. MS Access & MS Word Automation/Security Issue

5. How does one look at data in an open MS access aplication from MS Word

6. mail-merge MS Word and MS Access via ASP

7. How can I attach External MS-Access Tables to MS-AccessDatabases

8. Q:Envoking MS-Word from VB4 when Exchange is using MS-Word

9. Regarding Accessing External database using MS-Access and MS-Visual Basic

10. Link MS Access on PocketPC to Desktop MS Access

11. MS Access DB - Copy Table A from Database A to Table A Database B

12. MS PJ 2000 and MS Word via VBA

 

 
Powered by phpBB® Forum Software