Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2009
    Posts
    1

    Question How do I create a name search ?

    Hi everyone , Hope you can help me out with this question.

    I have been given the task of creating in Access a database / form that is capable of searching for an employee by surname and christian name.

    It is required that when the operator uses the prog they can start typing the surname , and in turn as soon as the first letter is typed it displays the relevant surnames starting with that letter , and a list is formed of the surnames beneath.
    Sounds a bit long winded but needs to look like a a phone directory.

    Info that would be required is Surname name , Christain name , Dept , Ext , Location etc.



    If anyone could assist me in what to do , I would be very much appreciated.

  2. #2
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows XP Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    Look at Combo Boxes.

    There is even a Wizard to help do this.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. search function
    By Eric1066 in forum Access
    Replies: 0
    Last Post: 10-23-2009, 10:23 AM
  2. Search
    By DWS in forum Forms
    Replies: 3
    Last Post: 08-24-2009, 12:07 PM
  3. yes/no search query
    By islandboy in forum Queries
    Replies: 7
    Last Post: 06-30-2009, 09:01 AM
  4. Search Facility
    By omegaboy in forum Access
    Replies: 3
    Last Post: 05-21-2009, 09:26 AM
  5. Search All Field
    By robbiebrown34 in forum Access
    Replies: 0
    Last Post: 05-17-2007, 09:40 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums