Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #10  
Old 11-09-2013, 09:48 PM
fumei fumei is offline Retrieving data from a list or database. Windows 7 64bit Retrieving data from a list or database. Office XP
Expert
 
Join Date: Jan 2013
Posts: 440
fumei is on a distinguished road
Default

Quote:
Sorry, I must be naive. I just wanted to know a simple way to be able to type in the first one or two letters of a doctor's name, and have corresponding names appear for me to select one of, and have the corresponding address appear.
Well, it is a little naive.

The names appear...where? Have the addresses appear...where? These things do not appear magically. Word has to be told where and how. YOU have to tell it where and how.

I am not trying to give you a hard time, just trying to give you a stretch of imagination. Say you have Dr. Jones. You type “J” and then “o”. OK. Now where is the “corresponding names” to appear? Right after? So you now have “JoJones”, the Jones following the Jo” you typed?

Now where does the address (assuming you CAN get it) appear? Following the “Jo” (or “JoJones”) ? Someplace else? If so…where?

What you are asking for is not that difficult, it is fairly simple, but it does take effort and planning and very specific instructions. Specifics. Nothing vague.
Quote:
It looks like coding is required.
As you do seem to want to place data gathered from someplace else (lets say your Excel file) at some other defined location, yes coding is likely. How else are you going to tell Word where to put it? Regarding that, part of the build of logic would be to determine if the location to put an address is ALWAYS going to be the same place. No? Then that adds another layer of complexity.

Again, believe it or not it IS (fairly) simple. It just needs to be very very very specific.

As has been mentioned (using a userform) you not need to type in the names. You can definitely pick up your data from Excel.

Last edited by macropod; 11-09-2013 at 10:59 PM. Reason: Fixed formatting
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Retrieving deleted data charles Outlook 0 12-23-2012 10:58 PM
Easy send/save Excel data to Database Table or Stored Procedure TonyHarvard Excel 3 07-11-2012 12:43 PM
Retrieving content control value jillapass Word VBA 4 05-24-2012 05:07 AM
Retrieving data from a list or database. How do I dynamically update data in a Word Document from a database table RSchmidt Word 1 07-14-2011 04:27 PM
Using data entered in prompt to search database table BluRay Word 1 03-25-2011 01:47 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:48 PM.


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