Recent content by writer2000

Your gut served you well! I found an empty cell that had the audit tag on it!@ That was causing all the fuss! Thank you so much!!!!!!!!!!!!!!!!!!!!!!!!! :D

Well I recreated the form from the ground up and now it works fine. So weird. Still no clue as to what was causing the issue, but thanks everyone for your help!

Odd. When I do that I no longer get the error message. However, only the first field (the first name) gets recorder by my audit trail table. None of the other fields are being recorded when changes are made.

Yes. I haven't found anything wrong with it. Here's the code for the module: Sub AuditChanges(IDField As String) On Error GoTo AuditChanges_Err Dim cnn As ADODB.Connection Dim rst As ADODB.Recordset Dim ctl As Control Dim datTimeCheck As Date Dim strUserID As String...

I installed an Audit Trail on my database. It works throughout the entire database. However, in one section of the database, on a single form, I keep getting an error message: Object doesn't support this property or method. Now, the audit still works. But i keep getting this message. What gives?

No I didn't haha. I am still learning access (picked up Access 2010 VBA Programming Inside and Out-going through it now). I am able to do tables, forms, queries, and reports really well. I am still learning VBA and SQL. Definitely a novice. Thank you so much for your help!

I agree. But how do I implement that into this code though?

The code below works great. The thing is, I need it to be modified a bit. I have 5 user types for this database. I wonder if there is a way to modify it so only certain user types will be logged out? Or, if can be set to only log out a user who is idle? Option Compare Database Option Explicit...

Never mind. Issue solved!

I don't have a query yet. So I am assuming I need to make a query that checks the LoginID and the Password. I am not 100% certain on the exact coding I need to write after that though. Here is the code I have for the change user password form: Private Sub Command178_Click() On Error GoTo...

Let's see, on the change user password form has just the simple embedded Marco (save prompt). It is linked to my user table (it stores the loginID, password, and usertype). The following code is set for when you hit Ok on the Login Form: Option Compare Database Private i As Integer Private...

So I have a login system established with loginID, passwords, and different user types. I also have a User Change Password form. However, this form only allows the user to change their password to something new. Also, for some reason the form only allows the first user in the table (ID#1) to be...

Thank you!

How do I tell Access to check it each time?

This is for a legit business with government contracts (and deals with a lot of PII), but the situation is an interesting one. We are going from mostly paper to paperless. I am the jack of all trades at my work whose specialty is writing (books, not code haha). I was tasked with learning MS...