HI,
I am developping a billing program and now i am creating a secuty form in which the administrator of the sytem will be using to enter new users or edit existing users.
The problem i am encoutering now is that my SQL statement
doesnt work. And i dont know why.
The code is the following
strSql = "SELECT * FROM [USERS] " & _
"WHERE ([USERNAME] Like '" & strUsername & "*')"& _
" ORDER BY [Username] DESC;"
rs.Open strSql, cn, adOpenKeyset
I am not getting any error, the problem is that the recordset is empty, and i have in my table about 50 users that i am testing on.
If someone has a clue why this code does not work please reply.
Thanx.
I am developping a billing program and now i am creating a secuty form in which the administrator of the sytem will be using to enter new users or edit existing users.
The problem i am encoutering now is that my SQL statement
doesnt work. And i dont know why.
The code is the following
strSql = "SELECT * FROM [USERS] " & _
"WHERE ([USERNAME] Like '" & strUsername & "*')"& _
" ORDER BY [Username] DESC;"
rs.Open strSql, cn, adOpenKeyset
I am not getting any error, the problem is that the recordset is empty, and i have in my table about 50 users that i am testing on.
If someone has a clue why this code does not work please reply.
Thanx.
