SQL in VB ?

[iangirven]

I am completely new to SQL server stuff so please bear with me. I have read a few posts from various sites and downloaded several documents but to be honest they all seem a bit to indepth for getting me started.

i am quite happy relating the SQL statements to the Actions carried out when compared to Design view in a query.

what id like is some help with getting me started on this new learning curve.

as an example if i had a form with a text box for a user to enter their surname could i then use SQL statement to search the appropriate table for a match then display an appropriate message box as to if a match was found or not.
eg
using a text box of testname how would i search a table called personal1 for a match.

dim strsql as string

strsql = "SELECT Personal1.Name FROM Personal1;"

if strsql = testname then
msgbox "match found"
else
msgbox "match not found"
end if

if i have posted in the wrong section i apologise.
thanx in advance for any help and guidance in kickstarting me off in this new area for me.

ian

 

[scottfarcus]

Is this a VB app or an Access app (VBA)?

 

[iangirven]

VBA

sorry shouldve said its a VBA application. im using a97 on NT4.

 

[iangirven]

Thanx again

Sorry for the delay in responding to your answer Pat. Perhaps I havent put what I wanted across clearly enough. i have used the combo box previously which works fine.

I am not after SQL coding to do any particular task, just some assistance on getting me started. I havent got any particular application in mind either.

So any suggestions of a topic to introduce me to SQL as well as some basic guidence to get me started will be greatfully received.

If i still havent been clear enough let me know and i will try again.

Thanx for your perserverance and help.

ian