Search results

  1. 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...
  2. T

    List box listing duplicates

    My list box is listing duplicates... How do I fix this?
  3. 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?
  4. 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?
  5. 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...
  6. 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