Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Feb 2001
    Location
    South Carolina, USA
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Who entered what???

    I have a database that is shared among 2 departments. One manager states that program is messing up and the information that is coming from the other department is incorrect. She seems to think there is something wrong with the database. I, however, feel like it is the users and they are not entering the information in a timely fashion. Let me get off of my soap box and ask my question.

    Can I tell when a field was changed? I thought I could create a hidden text box and on click event, insert the currently date and time. Will this work? Is there another method for me to try?

    Thanks,
    Deborah

  2. #2
    RDeShong
    Guest

    Re: Who entered what???

    You could create a transaction file with fields such as "field","datechanged","changedby",etc. Then create a vb module that appends a new rcd and fills in the fields. Then call this module for the "On Change" event.

  3. #3
    DaveShmave
    Guest

    Re: Who entered what???

    Try this Deborah:

    <A target="_blank" HREF=http://odyssey.apana.org.au/~abrowne/AppAudit.html>http://odyssey.apana.org.au/~abrowne/AppAudit.html</A>

    This might be more involved than what you were looking for but I have used this myself and it works great.

    HTH

    Dave

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Who entered what???

    I often include two fields in a table: ChangedBy and LastUpdatedDt. The former is filled in automatically in my form by retrieving the username from the operating system and the latter by putting the current date into the field in the BeforeUpdate event of the form. I normally only do this when questions may arise as to who did it and when.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •