Results 1 to 4 of 4

Thread: Finding Records [resolved]

  1. Jul 21st, 2003, 11:43 AM #1
    squirrelly1
    squirrelly1 is offline

    Thread Starter
    Frenzied Member
    Join Date
    Jun 2001
    Location
    USA
    Posts
    1,026

    Finding Records [resolved]

    Does any1 out there have a way to find records based upon the first letter of a value in one of the DB's fields?

    I am using ADODB...

    For example:
    I have a text field that may have the following values...

    Bob
    Mary
    jim
    Joe

    if my user selects "J" from a combo box, i would like to have a list box fill up with "jim" and "Joe" from the Database...


    Thank you for your help,
    Squirrelly1
    Last edited by squirrelly1; Jul 21st, 2003 at 12:51 PM.
    Now happily married and still crankin' away at the keyboard. Life is grand for a coder, no?
    Reply With Quote Reply With Quote
  2. Jul 21st, 2003, 11:52 AM #2
    Maldrid
    Maldrid is offline
    Fanatic Member
    Join Date
    Jun 2003
    Location
    IL
    Posts
    739
    You can do something like this

    VB Code:
    1. Query = "SELECT * FROM TableName WHERE [Name] LIKE '" & combobox & "%'"
    Reply With Quote Reply With Quote
  3. Jul 21st, 2003, 12:52 PM #3
    squirrelly1
    squirrelly1 is offline

    Thread Starter
    Frenzied Member
    Join Date
    Jun 2001
    Location
    USA
    Posts
    1,026

    Thank you...

    Thanx for the help Maldrid, I was playing around with that but couldn't get the right syntax...



    Squirrelly1
    Now happily married and still crankin' away at the keyboard. Life is grand for a coder, no?
    Reply With Quote Reply With Quote
  4. Jul 21st, 2003, 12:53 PM #4
    Maldrid
    Maldrid is offline
    Fanatic Member
    Join Date
    Jun 2003
    Location
    IL
    Posts
    739
    So you have it working now right?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width