Search results

  1. T

    Choosing diagnosis based on number within certain range

    I know you think that sounds really simple but I'm such a noob I have no idea how to use any of those methods...
  2. T

    Choosing diagnosis based on number within certain range

    How would I make it so that when I enter a number into a field on a form, Access recognizes the range in which the number is (ex. between 1-10, 11-20, 21-30, etc.) and associates the number with a given description/diagnosis. I'm trying to connect GAF numbers with diagnoses from the DSM-IV...
  3. T

    List box listing duplicates

    I made a new form to fix some other issues and that worked. Thanks!
  4. T

    List box listing duplicates

    My list box is listing duplicates... How do I fix this?
  5. T

    Error Adding New Data to Form

    I get the following error when I try to add new data to my form. Cannot add record(s); join key of 'tblAppointment' not in recordset. Help please?
  6. T

    Entering data into 2 tables by 1 form

    Is there anything to keep in mind when I build a form that I intend to use to enter data into two tables?
  7. T

    Prevent Duplicates

    Nevermind, looks like I figured it out on my own. Thanks!
  8. T

    Prevent Duplicates

    Ok, my fields are ApptID (Autonum), ApptDate, ApptTime, DoctorID, PatientID. I need it so it won't allow duplicates in date, time, and doctorID collectively. I don't know if this helps, but just trying to clarify.
  9. T

    Prevent Duplicates

    Ok, I see what you're talking about but I don't want each one to be No Duplicates separately. I only want it to reject duplicates of date and time and doctor if all three are duplicates... Can I still do that your way or do I need a module?
  10. T

    Prevent Duplicates

    How do you do that?...
  11. T

    Prevent Duplicates

    Woops. I'm a newbie. Can you tell me more specifically what you need to see?
  12. T

    Prevent Duplicates

    There isn't a way to check using a module with the BeforeUpdate event?
  13. T

    Prevent Duplicates

    I'm making a form in Access which allows someone to set up a doctor's appointment. They can enter a date, time, their first and last name, and the doctor's last name. I need to prevent duplicate appointments (i.e., same time on the same date for the same doctor). How would I do this with VBA...
  14. T

    End Date before Start Date VBA

    I'll keep that in mind for my database project. The question above was for a specific problem in a specific form for a specific control. Thanks!
  15. T

    End Date before Start Date VBA

    Ok, I already added that after I posted it. Thanks a lot!
  16. T

    End Date before Start Date VBA

    Yeah, I definitely need to do it in BeforeUpdate. This is what I have so far: Private Sub EndDate_BeforeUpdate(Cancel As Integer) 'Warn that the End Date is before the Begin Date If Me.EndDate < Me.BeginDate Then MsgBox "The End Date is earlier than the Begin Date."...
  17. T

    End Date before Start Date VBA

    I need help on a VBA module. I need a message box to pop up to warn the user when the End Date is earlier than the Start date when the End and Start dates are entered into a form. Help please?
Back
Top Bottom