Search results

Hi, I made some minor changes to my login form and I am having a problem when user key in invalid username/password, it will prompt me an error message (run-time error '3201': No current record.) I tried testing with the followings correct username, password and account is active, is working...

Hi, I would like to share an Access file with my classmates. They can add data through the form. However, I do not want them to see the backend data. I changed the access form to modal setting and create an accde file. But is there any other way to prevent them from seeing the backend data...

Hi, I got an edit form where user can edit the saved record. May I know how do I use macro to update the record and save a log of who edit and when the user edit? The user will need to login to edit and I already have set a tempVar to store the username with the login details. I created a...

I have a macro to clear my forms (cbo, txtbox). Recently, I added few listbox to my form and the clear button wont work. Anyone can advise? My current macro is using runmenucommand > UndoRecord

Hi, I am very new to MS Access. I follow this login code from a website. Private Sub login_Click() Dim db As DAO.Database Dim rst As DAO.Recordset Dim strSQL As String If Trim(Me.Username.Value & vbNullString) = vbNullString Then MsgBox prompt:="Username is empty."...

I am new to Access