Information générale
Titre:
Problem with SELECT statement
!Warning: This is a NEWBIE question!
Can anyone show me the proper way to embed an SQL statement - specifically the SELECT statement - into an event (in my case the click event of a command button)
Actually, I wanted to retrieve a login_id from my table, called tbl_staff, if the input login_id supplied by the user, in this case the login_id entered into a text box called cLoginID, exists in the table.
I tried
(line 1) =SELECT login_id;
(line 2) FROM tbl_staff;
(line 3) INTO cString2;
(line 4) WHERE login_id = ThisForm.cLoginID.value
At Line 3, i wanted to store the return value into a variable so that i can check the variable to see whether it's a valid login_id based on whether the SELECT statement was successful or not
When i run this particular form of mine and pressed the command button after entering a value into the text box, the program run stopped and gave me a message
SELECT variable not found
So...can anyone show me where i went wrong?
Thanx in advance!
Mazlan Bin Mohammad
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement