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

    Question Unanswered: prompt for duplicate

    Hi,

    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
    Posts
    1,487
    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 slow...it 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
  •