Search results

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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