Recent content by statistics

  1. S

    Query on Option Buttons

    The option buttons that I am using are toggle buttons in a group option. Not combo boxes. Any experience there?
  2. S

    Query on Option Buttons

    I have a form created with several option groups to choose from. I want to query based on the selections made from the form. I have change the option button values in the groups to adapt to the information that I am querying on. I have ran the query and the query works fine. I cannot seem to...
  3. S

    Searching table with form

    I have a parent table called patient info. and a child table called fills. The database in the future will become very large, and will be difficult to find a particular patient in the parent table to update fills in the child table. How can I search through the parent table using a form for easy...
  4. S

    Searching Records

    I have a parent table called patient info. and a child table called fills. The database in the future will become very large, and will be difficult to find a particular patient in the parent table to update fills in the child table. How can I search through the parent table with ease so that I...
  5. S

    Two Forms

    Since the patient maybe continuous over a period of time, I look at this as a time saving feature. Once the patients information is provided, then I only have to go back to the oxygen fills form and relate to the account number to fill out the patients oxygen fills for that day? I do not want...
  6. S

    Two Forms

    I have created two forms, one to enter patient information and another to enter oxygen fills. I have a one-to-many relationship between the two tables of patient information and oxygen fills. How can I restrict the user from inputting an account number into the oxygen fills form, that does not...
  7. S

    Date Query

    I have created two different fields, begindate and enddate in a table. I want the user to input two abstract dates and then click the command key to trigger the query. So far I have a between, and statement under criteria for both fields, one that falls into the next record. My problem is that...
Back
Top Bottom