View Single Post
 
Old 03-24-2011, 11:14 PM
BluRay BluRay is offline Windows 7 32bit Office 2007
Novice
 
Join Date: Mar 2011
Posts: 5
BluRay is on a distinguished road
Default Using data entered in prompt to search database table

Hey, i will try to describe what I want to do (hope it will be understandable)

"When I open a document, there will be prompt to enter the EmployeeID. The id entered will be used to search the data source, in this case a database table, and data like name and phone will be retrieved and displayed on the word document like shown:

EmployeeID: (from the prompt)
Name: (from database table)
Phone: (from database table)"

I am able to do the first part. I did it by using a fill-in box. I recorded a macro which selects the fill-in from Quick Parts from Insert. But I have no idea on know to do the rest of the part.

Some help will be greatly appreciated.

Last edited by BluRay; 03-25-2011 at 01:47 AM.
Reply With Quote