Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-24-2011, 11:14 PM
BluRay BluRay is offline Using data entered in prompt to search database table Windows 7 32bit Using data entered in prompt to search database table Office 2007
Novice
Using data entered in prompt to search database table
 
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
  #2  
Old 03-25-2011, 01:47 AM
BluRay BluRay is offline Using data entered in prompt to search database table Windows 7 32bit Using data entered in prompt to search database table Office 2007
Novice
Using data entered in prompt to search database table
 
Join Date: Mar 2011
Posts: 5
BluRay is on a distinguished road
Default

Someone...........?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using data entered in prompt to search database table Calendar Entries Appearing without being entered billp1955 Outlook 2 12-31-2012 12:40 PM
Using data entered in prompt to search database table Excel data to Word table Jaymond Flurrie Word VBA 2 02-27-2011 07:42 PM
Using data entered in prompt to search database table 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
Using data entered in prompt to search database table Making sure the correct number of characters are entered. leroytrolley Excel 1 07-25-2008 06:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:43 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft