Select ... From

[omozali]

I still new to SQL think and trying to learn but its not easy

I have a table called table2, it has 2 fields user and password. In a form I have a textbox that will contain input

I want to do search on this table to find if user exist or not
How can I do that?

I tried
SELECT user FROM table WHERE box.value=user

but get error on 'user' saying expected: Case

[blyxx86]

I still new to SQL think and trying to learn but its not easy

I have a table called table2, it has 2 fields user and password. In a form I have a textbox that will contain input

I want to do search on this table to find if user exist or not
How can I do that?

I tried
SELECT user FROM table WHERE box.value=user

but get error on 'user' saying expected: Case

Try...

SELECT table2.User FROM table2 WHERE (((table2.[User])=[Forms]![frmName]![textbox]));
 

[NeoPa]

If you're getting the message 'Expected Case' then you are entering SQL code into VBA.
You need to run

DoCmd.RunSQL strSQL

after you've set up the VBA String strSQL to be your SQL string. There are various examples of these here in TheScripts.
If you can't find anything or you need more help then come back and let us know.
Perhaps I should explain about the Case bit :
In VBA you have a Select Case statement which allows you to do some complicated If like processing.
If the compiler is expecting Case after the Select bit, then you must have tried to execute it directly from within VBA rather than pass it to the SQL interpreter.