Recent content by daikaio94

Well, if the subform is opened in table view I don't think this is going to work. You're only going through all controlls with this routine and in table view there are no controlls. I'm not sure if there is a solution for auditing changes that are made directly to a table but the code you are...

Hi, I had similar problems with the audit code. I'm not sure if Screen.ActiveForm.ActiveControl.Form returns the correct value. My solution was this: Set frm = Screen.ActiveForm For Each ctl In frm![SubFormName].Controls You could swap the hard coded Name of the subform with a...

Hello, I threw another example together. This time I included the search function I'm using and the audited form is now a subform as it is in my main Project. I still need to make adjustments to the code for using it in a subform but that is no problem, just didnt had the time yet. Some of...

Hello, I reconsidered my data model and built a new one from scratch. Actually I did not need the extra table "tblUser_Rechner". Because I only Need to know the current user and not past (or future) users of a pc I can simply put the User_ID and Verwendung_ID in tblRechner. That also solves the...

That can happen when there is a pc without a user assigned. In reality the pc would then be stored in our office untill we decide what to do. If there is no user there has to be something entered for "Verwendung" (I handled this with vba in my main Project, in the example i uploaded it's not...

I want to search for pc's either by using the Servicetag, Username or the Usage (Verwendung). Example: The user "John Doe" has 3 laptops and 1 workstation The user "Max Mustermann" has 1 workstation 10 laptops are used as "Pool" laptops (they do not have a user assigned, only a usage) 2...

That is correct, but if you remove tag Audit (see screenshot attached) from every control but the Hostname the OldValue works. I'll test the suggested data model tomorow and let you know any results.

Hello, Backstory: I'm working on an invetory database to document all the pc's and their users. I want to implement the AuditTrail to my Edit_Form so i can later view a log on what was changed to the selected entry. The code itself should not be the problem, as @Uncle Gizmo pointed out it has...

does no one else have any ideas?

Hello, sorry for not posting any updates, I was busy last week and could not work on the project. I tried to delet the relationships but without any success, still the same errors. I understand that the error comes propably from the query but I dont understand WHY. As fas as I understand...

Yes, I can update and modify the records and create new ones without any Problems. The only thing I have to pay attention to is to use existing id's when the control is bound to an id. This is regardless if I use combo- or textboxes, I tested both again just to be sure. And of course it...

Good morning, I did some changes and testing and found out something interesting. I added the required fields to the query so I can create a new record now. Unfortunately the code does still throw the same error when I try to update the two combo boxes on existing entries. What...

I will try to update it but I don't have the time today. I'll test it tomorrow and let you know the results! @jdraw: thanks, that is the link i couldn't use in post#1

nope, everything is in the same form.

No, the error occurs only with the two comboboxes. Also I'm checking if the control is tagged to be audited, so I can add specific controls only and not Audit the entire form. It works fine on other controls and even another combobox I added works...... Just to be sure I deleted everything...