Search results

Hello, I'm receiving an error "Syntax error in INSERT INTO statement" for the below code. I can't figure it out where/what is the error. Please help. CurrentDb.Execute "INSERT INTO tblTrans(fdsname, project, so) " & _ " VALUES (" & txt_fds & " ,'" & txt_name & "','" &...

Hello Gurus, I'm new to access vba and I'm trying to create a login form. I have already my code to login but i want to validate the password in 'case sensitive' basis. Below is only what I've got so far. Thanks in advance! Private Sub cmdLogin_Click() Dim login_validation As Variant...

Hello Gurus, I'm new in access and I would like to ask how can i validate the username and password in a textbox? I have a frmLogin and frmMain. I have also a table called 'tblUsers' with column fields 'username and password'. If username is not found in database then a msgbox will prompt...