Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 



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:57 AM.


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