Recent content by puuts

I've now added the execute SQL command, but everytime it runs, it always prompting "to append". I've just only want to insert the record not to append :( Dim db As DAO.Database Dim rs As DAO.Recordset Dim strSQL As String Set db = CurrentDb() strSQL = "INSERT INTO...

Hi Foe, Thanks for the correcting. Could you please help me with the 'case sensitive' problem?

Hello plog, txt_fds contains names, and I've set the fdsname in the table to text. But it seems it didn't populate in the database

Hello pbaldy, Thanks for the reply. I've tried your suggestion but it seems it didn't save in the database? Or do I missed something?? Private Sub cmdSAVE_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Dim strSQL As String Set db = CurrentDb() strSQL = "INSERT INTO...

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 jdraw, Thanks for the reply, my problem is the coding of the logic as I'm new to database :(

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...