#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Someone...........?
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Calendar Entries Appearing without being entered | billp1955 | Outlook | 2 | 12-31-2012 12:40 PM |
Excel data to Word table | Jaymond Flurrie | Word VBA | 2 | 02-27-2011 07:42 PM |
Use changeable table data in doc text? | rtlight | Word Tables | 4 | 02-25-2011 07:29 PM |
pivot table source data | hannu | Excel | 0 | 07-03-2010 04:54 AM |
Making sure the correct number of characters are entered. | leroytrolley | Excel | 1 | 07-25-2008 06:38 AM |