Results 1 to 2 of 2
  1. #1
    JackieFeng is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Mar 2016
    Posts
    24

    Duplicated data entry form help!


    I am trying to find a way to prevent double booking.

    In my booking form, i have date(date/time),start time(date/time) and doctor ID(number)-all from tblBooking


    For example, doctor 1 9/6/2016 9:00. then next time i enter this information into form which should prevent me doing this and an error message should display.

    What code should i put into this form? (code for multiple fields)

  2. #2
    Micron is online now Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    I don't see why you split the Date and Time into 2 different fields. You could simply have one and format it to show both date and time. If you want to split that into separate fields in a form, that would be better than having two fields (unless you have a valid reason for splitting it).
    You could then make the DoctorID and Date/Time field a composite index.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Duplicated Data Issue
    By justair07 in forum Access
    Replies: 16
    Last Post: 06-03-2014, 07:19 AM
  2. Replies: 5
    Last Post: 03-09-2014, 07:16 PM
  3. Replies: 1
    Last Post: 02-06-2014, 04:21 PM
  4. Replies: 5
    Last Post: 08-12-2013, 12:53 AM
  5. Combine duplicated data in a report
    By padfoot in forum Reports
    Replies: 3
    Last Post: 03-24-2012, 08:41 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums