Search results

What do, where should, and how do I write the code for LogError? :)

I got the instructions here: http://allenbrowne.com/appaudit.html And the code here: http://allenbrowne.com/AppAuditCode.html

It would be the last one. I didn't copy it. I have no idea where to look for it, or I'm just really stupid and code-illiterate.

Hi, I have a problem with the code from Allen Browne. I copied the four functions according to instruction. But when I tried to Debug the code, Access highlights Call LogError and tells me . I'm a bit afraid to alter anything in the code because I might not be able to fix it back.

I can never fully understand Allen Browne's although I know it's explained really well. I just really focus on this. Thank you. I'll try to contemplate on this and weigh my choices. Gosh, this is taking me forever.

Gina, I now have a few troubles with the Macros. I'm still trying to get the t_AuditTrail to work because it's being really stubborn. I'm really open to the possibility of just making the audit trail in VBA code. If I do, do you have a sample that I could take a look at? I would want to track...

Yes. I will try it now. Will let you know how it turns out. Thank you!

It still exists but for the purpose of presenting a prototype to the end-user, I got rid of it first. I'm still keeping the t_AuditTrail but I don't how how I could make the end-user see the information.

Thank you! Hmm. In my frustration, I just deleted all "audit trail" objects. If I couldn't figure it out, might as well just get rid of it. Still, I really want to make it work. I just don't know how. :(

Wazzup? :(

No worries. I just really want the user to see the historical data of employees including the change of contract date. For better explanation, I wrote it in another post that no one replied to. :( HAHA.

Hello, I'm a real newbee so please be forgiving. This will be a long post because I want to explain the details. This is the situation that I'm stuck with: I have the following tables 1. t_Employee. It consists of the following fields: EmployeeID Name Job Title Contract Start Date Contract...

Oh no. :( Haha. It's fine. But would it be okay if you could take a look at it before you go MIA? :) Just so I have something to work with. I'm really quite stuck.

Here's my progress so far.

Still didn't work. :( It gave me the same error.

Private Sub Command809_Click() If Me.eEmployeeID = "" Then End If DoCmd.OpenReport "r_AuditTrail_eJobTitle", acViewPreview, , "[atRecordID]=" & Me![eEmployeeID] End Sub Is this correct? Apparently not because it's still giving me the same error. :( This also didn't work...

Yes, it's the name of my control on my form. It is also the name of the control source. And there's no data yet. So I guess it's empty. Is eEmployeeID the problem? Or atRecordID? :)

It didn't work. :( This is my code: Private Sub Command809_Click() DoCmd.OpenReport "r_AuditTrail_eJobTitle", acViewPreview, , "[atRecordID]=" & Me![eEmployeeID] End Sub It says:

Yes, they're both numeric. eEmployeeID is taken from t_Employee white atRecordID is from t_AuditTrail.

Hey. So I made queries for all the fields that I want to filter out for historical data. All of which are taken from t_AuditTrail. After making the query, I went to make a report. Then I tried to add a button on f_HRMSCommonUser so I can open a report (say Job Title history) but only show data...