Search results

  1. L

    link a search form to data entry form with specific record

    Data entry property is set to "No" for the data entry form The data mode for the macro is Edit.
  2. L

    link a search form to data entry form with specific record

    I have a search form (continue) contain basic information which allow people to filter to a specific record. I have another data entry form (single form) has all the detailed information. These two forms have the same data source. the PK for the table is ParticipantID I add a macro (I do not...
  3. L

    button everywhere?

    I Made a form with one button to open an another form, however, when I click the blank space close to the button, it also open that form. I remember there's some idea to control this and I did it before, but I just forget how to do it.
  4. L

    How to calculate the yes percent

    I have a query which included person's ID, name, DOB, and the answer (Yes/No/Null) for a question. I want to count the Yes Number , Total Number of Respond, and the percentage (Yes Number/ Total Reponded number), How can I do it. Thanks.
  5. L

    two main forms, one subform, is that possible?

    Thanks for the help. I will try it. This is my first time to use Access. I may have more problems later. Thanks again.
  6. L

    two main forms, one subform, is that possible?

    oops! Forgot my questions. My question is I cannot make the form like the outline I descripbe above. I have hard time to put all the questions and responses together in one page. I have to go to next record in subform. Another question is If I use questtion as a subform, I am confused...
  7. L

    two main forms, one subform, is that possible?

    I am working on a survey database. I build three tables: Demographic, Questions and Response. As their name, the demographic include all indiviudal's personal information, the question table include 20 survey questions, and Response table include the responses, comments and other information...
  8. L

    Q: Structure and relationship of tables

    I am totally a first time user for Access. I need to build a review database for several nursing homes. Project description: My company will do review for persons live in nursing home. The data review manager need to enter each person's Demographic information such as: Name, ssn, address...
Back
Top Bottom