Search

[Vec]

Using a data control form the tool box to conect some text boxes to an access db to display the data, how do I do a simple search of an access table named users and a field named fldUsername to see if an entry exists or not?



-------------------------------------------------------------------------
-------------------------------------------------------------------------

"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Univer

 

[lone84]

Hi,

your SQL should look something like this:
"select * from users where fldUsername = '"&textbox.text&"'"

use the recordcount to check if record exist