Recent content by ren1104

  1. R

    Multiple choices combo box

    Dkinley, I figured it out on how to link the combo box to a type of question but my next question is on how to add a memo box under each subanswer, example: 2. This is question number two 2a. Sub answer 1 2b Sub answer 2 2c This would be a memo box, where the user can manually type in. I have...
  2. R

    Multiple choices combo box

    Attached is the database. There are 2 tables: - Lookup contains the QNO and Answer - tblQuestions contains the questions and QNO I am using the QNO to determine which choices to go with which type of questions (main or sub) The form is Form2. Thank you so much for helping me.
  3. R

    Multiple choices combo box

    I looked at the cascading combo box but I don't think that's what I need. I am attaching the view of the form, where the drop down menu is either showing "1 or 2 or 3 for 4" or "y or n", it depends on the question number. I did find a way where it shows the choices according to the question...
  4. R

    Multiple choices combo box

    I am working on creating a form where I have the main questions and sub answers, for example: 1. This is question number one 2. This is question number two 2a. Sub answer 1 2b Sub answer 2 3. This is question number three 3a. Sub answer 1 3b Sub answer 2 3c Sub answer 3 For the each of the main...
  5. R

    Randomly pick records for each User

    Is it possible to do it through SQL? I am really new at Visual basic, not sure where to begin. Here's some more information, would you be able to wirte the codes for me? Table name: tbl01ClaimInformation: contains the SSN and the Claim Rep Names Table name: tbl02Result: contains the result of...
  6. R

    Randomly pick records for each User

    I have a query with a list of Customer SSNs and Claim Rep, I want to randomly pick 5 Customer SSNs for each of the Claim Rep. I can't figure out on how to do that, I was able to create an SQL code to just randomly pick the customer SSN. I don't know anything about Visual Basic codes, but if that...
Back
Top Bottom