Results 1 to 4 of 4

Thread: Querying a DB from a VB6 form

  1. Jun 27th, 2001, 09:44 AM #1
    thomasbenita
    thomasbenita is offline

    Thread Starter
    New Member
    Join Date
    Jun 2001
    Location
    New York
    Posts
    3

    Querying a DB from a VB6 form

    Hi guys,

    I'm trying yo develop my first application and need your help here:
    On one form (Form1) I have a txtbox (txtsearch) and a button (CmdSearch), when the user hit the search button I want the program to look up the name(s) associated to the code entered in txtsearch and display it/them in a message box....

    For the data source I have the choice between 2 files:

    1 excel spreadsheet: 3 columns: 'Code' - 'City' - 'Country'
    1 access 2k DB: same fields

    Thanks in advance,

    Tom
    Reply With Quote Reply With Quote
  2. Jun 27th, 2001, 09:47 AM #2
    Skitchen8
    Skitchen8 is offline
    Frenzied Member Skitchen8's Avatar
    Join Date
    Feb 2001
    Location
    Binghamotn, NY
    Posts
    1,943
    read the database tutorial (#2 i think) on vbworld.com... it teaches you that exact example, it uses SQL (structured query language) to search a flexgrid control and get only what you want out of it.
    Government is another way to say better…than…you.
    It’s like ice but no pick, a murder charge that won’t stick,
    it’s like a whole other world where you can smell the food,
    but you can’t touch the silverware.
    Huh, what luck. Fascism you can vote for.
    Humph, isn’t that sweet?
    And we’re all gonna die some day, because that’s the American way
    -Stone Sour
    Reply With Quote Reply With Quote
  3. Jun 27th, 2001, 10:04 AM #3
    thomasbenita
    thomasbenita is offline

    Thread Starter
    New Member
    Join Date
    Jun 2001
    Location
    New York
    Posts
    3
    Thanks for the tip
    Reply With Quote Reply With Quote
  4. Jun 27th, 2001, 10:07 AM #4
    Skitchen8
    Skitchen8 is offline
    Frenzied Member Skitchen8's Avatar
    Join Date
    Feb 2001
    Location
    Binghamotn, NY
    Posts
    1,943
    no problem... just learning databases myself
    Government is another way to say better…than…you.
    It’s like ice but no pick, a murder charge that won’t stick,
    it’s like a whole other world where you can smell the food,
    but you can’t touch the silverware.
    Huh, what luck. Fascism you can vote for.
    Humph, isn’t that sweet?
    And we’re all gonna die some day, because that’s the American way
    -Stone Sour
    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