Search results

I found that error in the Immediate Code window per your helpful advice and removed the Audit tag and still got the same error from my original post. Unless I somehow missed a field, all of the audit tags have been removed. Thank you for pointing that out to me. I do understand the general idea...

Sorry, I've been out sick. What about the certifications table isn't normalized? Could you be more specific? I went to your link, but that site discusses theory, which is subject to interpretation and I need specific examples of what is wrong with my table. I suppose I could try and make...

@pbaldy, Please check your PM box for instructions. Thanks!

Ok. I removed all sensitive data and replaced it with sample data. Unfortunately, I can't save the DB in an earlier Access format (2003-2007) because it contains elements that require the 2010 version. I'm not sure which elements to remove to save it as an earlier version of Access. Thank you...

No, the tab control does not have the Audit tag in it. In fact, I removed the Audit tag from the individual text boxes within the tab control and I am still receiving the error.

I followed your instructions and the Immediate Window says that one of my tab controls (which I didn't list earlier because there are 26 fields in the control) is triggering the error. So, I removed the "Audit" tag from all of the fields in the tab control, but I am still getting the error. I...

The function is written such that I can't tell which control is causing it to break. But, this error is triggered on all of the controls in the form. It doesn't matter which field I use to make the edit, the error gets triggered. The controls on the form are are as follows: Academy ID Last...

I commented out the line: On Error GoTo AuditChanges_Err Then, I compiled the code. I did not get another error until I used the form live and tried to save the changes. Here is the line of code the debugger flagged: If Nz(ctl.Value) <> Nz(ctl.OldValue) Then And yes, I do have "Audit" in the...

This is not a compile error, so I don't know which line of code is triggering it. It is an error message that pops up when I edit a record using the form that the code is running behind. I will try the Audit Trail code you recommended and let you know what happens. Which Audit Trail code were...

I found some code online that creates an Audit Trail for my database. This code captures all changes (new records, edits and deletions) to my database and writes the changes (old and new values) to a table. It works, but it also gives an error message, “Object Doesn't Support Property or Method...

vbaInet, You made me laugh! LOL!

@RainLover, Thank you for your help! I am very familiar with stepping through code, though. As I mentioned in Post #1, I inherited a form and was trying to use it as is. I have programming experience in C++ and VBA, but I'm still learning each day. I am really enjoying myself!

@RainLover, Yes, the top of the code window contains: Option Compare Database Option ExplicitAs vbaInet mentioned, everything is working properly now. The code you marked in red is working fine as well. Please see posts #19 and #21. Thank you for your help in this as well!

@vbaInet, Yes, I realize that Post #3 has the correct code. As I said, I originally left some lines of code out for reasons that don't quite make sense. Post #19 was used to show my corrections. Thanks for all of your help! Thanks again to everyone who replied!

@vbaInet, I didn't realize a left a few lines of code out. Thank you for your patience! Also, Post #3 was missing the "= 0", so here is the fully functioning code for the benefit of others to use. The code that I originally left out (for some strange reason) is marked in blue...

Again, thank you all for your help so far, but I am still having the same problem as mentioned in Post #12. My Users table is being updated regardless of whether or not all three of my conditions are being met in my New User form (first name, last name and username must be entered). Is there a...

I appreciate all of your help so far. I am using a Bound form. I also changed vbNullsString to vbNullString per your notation and put the Before Update event code back into place. I still have the same problem. The table updates when only 1 of the three conditions have been met unless I delete...

Ok, I had to unmark this thread as solved because I am having more issues. The table tblUsers is being updated whether or not all of the IF statement conditions are being met. For example, if I enter a first name, but no last name, the first name still appears in tblUsers, whereas I expected...

Thank you all for your help! I solved my problem. I created a bound form and inserted the code below into the Save button code. For some reason, the Before Update event did not work properly (i.e. the empty last name field would be recognized, but not the first name field). I'm not sure why my...

vbaInet, I tried your solution, but unfortunately, the code is still not being recognized. I tried your code with table validation rules in place as well as with table validation removed, but it didn't work. I did, however, get table validation rules to work without any Before Update code at...