Re: Help with Allen Brown's (wonderful!) audit trail code.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

You will need to add the fields to both the audit table, and also the temp
table.

Then you will need to modify the Append query statements so they include
these fields as well. Be careful to maintain the same order, and to include
the quote delimiters around the string values.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Janet" <Janet@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:582EAB9F-05BB-4357-87F3-9DB16070E0F8@xxxxxxxxxxxxxxxx
> Thank you, Allen :-). I'm not sure how to incorporate it into the audit
> trail code I got from you, though. That is, I already have the code for
> the
> other (current user, machine name, etc.) but when I try to add it to the
> audit trail code, I get error messages saying something like "the input
> query
> must have a query or table" (or something like that. So I know I'm doing
> something wrong, and think it must be something really simple, but I'm not
> getting it. I'm very new at this and not sure how to add to the existing
> audit trail code to make it all work right.
>
> "Allen Browne" wrote:
>
>> The database use name is given by:
>> CurrentUser()
>>
>> The machine name is here:
>> http://www.mvps.org/access/api/api0009.htm
>>
>> Not sure what you mean by the network full name.
>> And potentially the person could be on multiple networks?
>> You could try opening a Windows command prompt, and entering:
>> SET
>> If you see the name there, you be able to use Environ()
>>
>> "Janet" <Janet@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:877A3B18-5B48-4C74-B7CA-2C8A61AAB355@xxxxxxxxxxxxxxxx
>> >I used Allen Brown's instructions for creating an audit trail. It works
>> > very, very well (thank you, Allen!). It shows the type of audit,
>> > date/time
>> > audit occurred, and the network username of the person who inserted,
>> > updated,
>> > or deleted a record.
>> >
>> > I would like to add a few more things, though, and have no idea how to
>> > do
>> > this. I want to add: 1) network full name (in addition to network
>> > username),
>> > database username, and machine name.


.

Relevant Pages

  • Re: Populating a text box from query results
    ... We do an audit process of every area so there are numerous audits ... I also have a query called qrySection that calculates the average of each ... I can't seem to figure out how to get the values of avgSection1, ...
    (microsoft.public.access.forms)
  • RE: Random selection - multiple criteria
    ... tremendous amount of work to the audit. ... "KARL DEWEY" wrote: ... Then the next query -- ... I have a query that I am using to generate a random selection of customer ...
    (microsoft.public.access.queries)
  • Re: Form Result Source ->Query/Table (Or)
    ... is stored in the tag property for a form based on a query ... field I need to store as part of the audit trail. ... >i think the best is to store primary key fields name also ...
    (microsoft.public.access.modulesdaovba)
  • Re: Determining if a form has a table or query recordset source
    ... Not just any query. ... used the Products Table as the .RecordSource property. ... how to obtain the primary key of a query? ... >> I have an audit routine that monitors all user activity ...
    (microsoft.public.access.security)
  • Re: Help with Allen Browns (wonderful!) audit trail code.
    ... I'm not sure how to incorporate it into the audit ... trail code I got from you, ... > Not sure what you mean by the network full name. ... >> audit occurred, and the network username of the person who inserted, ...
    (microsoft.public.access.modulesdaovba)