Allen Browne's Audit Trail Code

[TL]

I implemented the use of Allen Browne's Audit Trail Code in a database that I
created for the purpose of tracking errors. The Audit Trail code works great
for all but 4 users. Unfortunately, for those 4 users the following error
occurs:

Compile error:

Can't find project or library

Once "OK" is clicked, "String$" is highlighted in the module under the
Function NetworkUserName() As String. The whole line reads: strUserName =
String$(254, 0)

I am not a programmer, and am a novice at VBA. I am assuming that this
error is occurring because the system file "advapi32.dll" is not found by the
module. Our IT department refused to help me because they did not create the
database in question. I have no idea how to correct this problem. As an
FYI, the Audit Trail code worked great on my computer. I did a search for
the .dll shown above and found it in two separate locations. I did a search
on the computer of a user who was having problems and she had it in both
locations, but in one location, the file was not recognized by Windows in the
same way as it was on my computer. It was an undentified file-type and also
smaller in size. Any help will be greatly appreciated. Please let me know
if any additional information is needed for troubleshooting purposes.

 

[Rob Oldfield]

Sounds like.... http://www.mvps.org/access/bugs/bugs0001.htm

 

[TL]

Thank You! It took an act of God to get our IT department to install the
Reference Wizard. Once this took place, I went through and checked the
references. It is now working. Thank you so much for your help!

Tiffany