Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #12  
Old 11-13-2013, 09:58 PM
macropod's Avatar
macropod macropod is offline Retrieving data from a list or database. Windows 7 32bit Retrieving data from a list or database. Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by Vic01 View Post
If I type in a list box (or similar appropriate object) "Jo", the name "Robert Jones" appears in the list box and I click on it and the name "Robert Jones" is retrieved from the excel file and 'appears' in that place where the list box is, along with that doctor's address (which is in the excel file)
It's a whole lot more complicated than that. What happens if your database has Dr Robert Jones, Dr Martha Jones, Dr Fred Johns, Dr John Johnson, Dr Ian Johnston and Dr Ann Johnstone? How is typing "Jo" going to get you the required output? Even typing "Jones" or "Johns" won't give you a single match and presumably you don't want your code to choose one at random. The best you'll do in many cases is to obtain a list of possibilities from which you must choose. I ought to know - I worked with electoral rolls for 25 years...
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
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 02:48 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