|
-
Jun 27th, 2001, 09:44 AM
#1
Thread Starter
New Member
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
-
Jun 27th, 2001, 09:47 AM
#2
Frenzied Member
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
-
Jun 27th, 2001, 10:04 AM
#3
Thread Starter
New Member
Thanks for the tip
-
Jun 27th, 2001, 10:07 AM
#4
Frenzied Member
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
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
|