Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2005

    Question Unanswered: prompt for duplicate


    i've created a database which logs events. I want to have a prompt before updating the time field if another event is already logged for that same date and time.

  2. #2
    Join Date
    Nov 2003
    If your Logged time also contains seconds, then you must be logging data quite a bit or quite rapidly (more than one log entry per second). Although this is not necessarily uncommon, it is unique to most applications.

    You can use the DLookup function to see if there is a current date & time match within the database. Since DLookup is a little should ensure that your log entries don't clash.

Posting Permissions

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