Search results

I am so sorry. Yes, now I see. I was confused with the table issue. I thought the changes were being recorded and could be viewed horizontally by making the column wider. Now I see the changes are actually there, but I need to make the row taller to see them. What a dork. Thank you so much...

Some how I am still not getting it. Do you see the changes listed in the Audit Trail column of the table. I cannot. Aren't they supposed to be listed there as well from the AuditTrail Module? I modified the database from 125 to 135 in the data column, this I see in the table. I am looking...

I see that it is recording the new entry into the form, but if you were to change the data in the cell, there is no note of it in the table. I think I have a problem in the code that records the changes. Somewhere below this point in the code. 'Set date and current user if the form (current...

RuralGuy Thank you so much for helping me eliminate that error. Your suggestion worked. But I am still having the issue of not being able to record the changes made on the form into the audittrail of the table. Any thoughts on what is wrong? CB

Ok take a look at this. I am hoping it doesn't load as read only, but we shall see. I think you have to extract the file so it isn't read only.

Ok, the problem does not lie with the find and replace button. I removed all command buttons from my form and tried making the changes again to the data. Again I can save the data to the table, but I still get the "Invalid use" error. I had found a discussion about checking references in the...

I copied the audit trail module from your post nine and experienced the Type Mismatch error as soon as I ran it. I made the changes from post 11 and this error went away as I described. I am not sure what other way to edit the module to not flag this error without messing the code up. So no...

Sorry, I am not trying to make this any more difficult. I took the module as is and posted it into my database. When I tried to run the form upon closing I got the 13-Type Mismatch error. I had previously done a search on the audit trail info and had found the fix I listed above. I have...

OK, fixed the ambiguous name problem. I hadn't deleted my previous Audit Trail Module so it was confused. After fixing this I get this error: 13-Type Mismatch from previous threads I found this fix. 1. Pass the form as an argument of the function Function AuditTrail(frm as Form) 2. Comment...

I am trying to load this new audit trail in and when I go to run I get this error with my Before Update Event. Ambiguous name detected:Audit_Trail Here is the Before Update Event. I haven't changed this one yet. Private Sub Form_BeforeUpdate(Cancel As Integer) On Error GoTo...

Ok, now I am totally confused. I had this audit trail working fine and I must have done something nuts to it. Now it only records when I have a new record and any change is not recorded. (I believe this is what you were trying to tell me) Anyway, The field in my table is called AuditTrail...

Can you help me set up the code so that it will continue to add to the memo field? Also, once I fix that issue will the code work in conjuction with the find and replace button on the same form? CB

I am unsure why there are two controls listed. I just copied this from the net. http://support.microsoft.com/default.aspx?scid=kb;en-us;197592. I believe it has been discussed here many times on the proper way to set up the audittrail using this code. I have set it up the best I can, but...

Hi, I have been using the audit trail below, which seems to work fine for adding new records. I am trying to set up a form which will allow me to use a Find and Replace Command button to filter to the specific record I need to change. Once I have completed the change and try and log out of the...

I am having an odd issue with an audit trail I hope someone can help me with. I am using the module below that I got off this website. It seems to work perfectly fine with my forms that have subforms, but on a normal form the audit trail is kinda screwy. I can see it on the form, but it does...

Thanks a bunch. I now have this working. I just have to work out the update query to log in the sign-out times. Appreciate everything. Thanks CB :)

Ok, I figured out the DAO reference by doing a search. Got that part fixed. Now, can anyone help me understand how to set this code up to work on loading my switchboard? I set it up, I thought like the instructions said to, but it doesn't dump anything into the table and it flags an error...

Thanks, But I am not sure how to set up the DAO reference. I am sure this is not set-up because I tried to implement another module earlier and the debugger flagged the DAO reference. Could you help me in setting this up? CB

HI, I performed a search to find some code to track when a user logs in and out of the database. This is what I have been able to find. The problem with it is when I try and run the code the debugger comes up and has a problem with the Line: Dim strUserName As String, db As Database, r As...

:chomp: I am trying to get fields highlighted when they are due. In my report I have dates listed by month they have been on stability. I need to highlight the date when the month/year is current. Example in the report the 12 Month column is all due in Oct of 2005, I would like for it to be...