Can I open forms randomly?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • EManning
    #1

    Can I open forms randomly?

    Using A2K. I've got a request to develop a database consisting of
    survey questions. There are 2 sets of questions, set A and set B. A
    has 12 questions, B has 11. The requester of this database would like
    to randomize the questions. The sets would be combined and the
    questions randomized. So the user might see a question from B first,
    then a question from set A, then another from B, maybe the next 2 from
    A, and so on.

    Has anyone done anything like this before and if so, can you share
    what you've done?

    Thanks.

    Tags: None
    • Tom van Stiphout
      #2
      Re: Can I open forms randomly?

      On Thu, 21 Jun 2007 06:32:39 -0700, EManning
      <manning_news@h otmail.comwrote :

      Put all questions in the same table. To select some random questions
      from it, use the code in this article:
      http://www.mvps.org/access/queries/qry0011.htm

      as the RecordSource for your form.

      -Tom.

      >Using A2K. I've got a request to develop a database consisting of
      >survey questions. There are 2 sets of questions, set A and set B. A
      >has 12 questions, B has 11. The requester of this database would like
      >to randomize the questions. The sets would be combined and the
      >questions randomized. So the user might see a question from B first,
      >then a question from set A, then another from B, maybe the next 2 from
      >A, and so on.
      >
      >Has anyone done anything like this before and if so, can you share
      >what you've done?
      >
      >Thanks.

        Comment

        • EManning
          #3
          Re: Can I open forms randomly?

          On Jun 21, 8:41 am, Tom van Stiphout <no.spam.tom7.. .@cox.netwrote:
          On Thu, 21 Jun 2007 06:32:39 -0700, EManning
          >
          <manning_n...@h otmail.comwrote :
          >
          Put all questions in the same table. To select some random questions
          from it, use the code in this article:http://www.mvps.org/access/queries/qry0011.htm
          as the RecordSource for your form.
          >
          -Tom.
          >
          >
          >
          Using A2K. I've got a request to develop a database consisting of
          survey questions. There are 2 sets of questions, set A and set B. A
          has 12 questions, B has 11. The requester of this database would like
          to randomize the questions. The sets would be combined and the
          questions randomized. So the user might see a question from B first,
          then a question from set A, then another from B, maybe the next 2 from
          A, and so on.
          >
          Has anyone done anything like this before and if so, can you share
          what you've done?
          >
          Thanks.- Hide quoted text -
          >
          - Show quoted text -

          Thanks. That was simple enough. Right now, the questions are very
          simple and your suggestion will work fine. I anticipate the user
          wanting to display pictures with each question. So I'm thinking that
          each question will have to be a separate form. If I stored the name
          of the form in the table, instead of the question, then a random list
          of forms would be returned. I could then go down the list and open
          the forms. Does that sound like a good plan or am I missing
          something?




            Comment

            • Tom van Stiphout
              #4
              Re: Can I open forms randomly?

              On Thu, 21 Jun 2007 07:02:46 -0700, EManning
              <manning_news@h otmail.comwrote :

              Store the path to the picture in the Questions table; then depending
              on exactly what you're doing you may either be able to bind that
              column to an image control, or refresh the image control in the
              Form_Current event.

              -Tom.


              >On Jun 21, 8:41 am, Tom van Stiphout <no.spam.tom7.. .@cox.netwrote:
              >On Thu, 21 Jun 2007 06:32:39 -0700, EManning
              >>
              ><manning_n...@ hotmail.comwrot e:
              >>
              >Put all questions in the same table. To select some random questions
              >from it, use the code in this article:http://www.mvps.org/access/queries/qry0011.htm
              >as the RecordSource for your form.
              >>
              >-Tom.
              >>
              >>
              >>
              >Using A2K. I've got a request to develop a database consisting of
              >survey questions. There are 2 sets of questions, set A and set B. A
              >has 12 questions, B has 11. The requester of this database would like
              >to randomize the questions. The sets would be combined and the
              >questions randomized. So the user might see a question from B first,
              >then a question from set A, then another from B, maybe the next 2 from
              >A, and so on.
              >>
              >Has anyone done anything like this before and if so, can you share
              >what you've done?
              >>
              >Thanks.- Hide quoted text -
              >>
              >- Show quoted text -
              >
              >
              >Thanks. That was simple enough. Right now, the questions are very
              >simple and your suggestion will work fine. I anticipate the user
              >wanting to display pictures with each question. So I'm thinking that
              >each question will have to be a separate form. If I stored the name
              >of the form in the table, instead of the question, then a random list
              >of forms would be returned. I could then go down the list and open
              >the forms. Does that sound like a good plan or am I missing
              >something?
              >
              >
              >

                Comment

                • EManning
                  #5
                  Re: Can I open forms randomly?

                  On Jun 21, 9:41 am, Tom van Stiphout <no.spam.tom7.. .@cox.netwrote:
                  On Thu, 21 Jun 2007 07:02:46 -0700, EManning
                  >
                  <manning_n...@h otmail.comwrote :
                  >
                  Store the path to the picture in the Questions table; then depending
                  on exactly what you're doing you may either be able to bind that
                  column to an image control, or refresh the image control in the
                  Form_Current event.
                  >
                  -Tom.
                  >
                  >
                  >
                  On Jun 21, 8:41 am, Tom van Stiphout <no.spam.tom7.. .@cox.netwrote:
                  On Thu, 21 Jun 2007 06:32:39 -0700, EManning
                  >
                  <manning_n...@h otmail.comwrote :
                  >
                  Put all questions in the same table. To select some random questions
                  from it, use the code in this article:http://www.mvps.org/access/queries/qry0011.htm
                  as the RecordSource for your form.
                  >
                  -Tom.
                  >
                  Using A2K. I've got a request to develop a database consisting of
                  survey questions. There are 2 sets of questions, set A and set B. A
                  has 12 questions, B has 11. The requester of this database would like
                  to randomize the questions. The sets would be combined and the
                  questions randomized. So the user might see a question from B first,
                  then a question from set A, then another from B, maybe the next 2 from
                  A, and so on.
                  >
                  Has anyone done anything like this before and if so, can you share
                  what you've done?
                  >
                  Thanks.- Hide quoted text -
                  >
                  - Show quoted text -
                  >
                  Thanks. That was simple enough. Right now, the questions are very
                  simple and your suggestion will work fine. I anticipate the user
                  wanting to display pictures with each question. So I'm thinking that
                  each question will have to be a separate form. If I stored the name
                  of the form in the table, instead of the question, then a random list
                  of forms would be returned. I could then go down the list and open
                  the forms. Does that sound like a good plan or am I missing
                  something?- Hide quoted text -
                  >
                  - Show quoted text -

                  Will do. Thanks for your help.

                    Comment

                    • Tom van Stiphout
                      #6
                      Re: Can I open forms randomly?

                      On Thu, 21 Jun 2007 08:07:01 -0700, EManning
                      <manning_news@h otmail.comwrote :

                      Actually, since you have so few questions, you may also consider
                      storing the picture itself in the database. The horror stories about
                      database bloat don't apply if you have a few dozen static pictures.
                      Then you could bind to an OLE data control.

                      I did this once with the mugshots of 90 state legislators, and it
                      worked perfectly.

                      -Tom.


                      >On Jun 21, 9:41 am, Tom van Stiphout <no.spam.tom7.. .@cox.netwrote:
                      >On Thu, 21 Jun 2007 07:02:46 -0700, EManning
                      >>
                      ><manning_n...@ hotmail.comwrot e:
                      >>
                      >Store the path to the picture in the Questions table; then depending
                      >on exactly what you're doing you may either be able to bind that
                      >column to an image control, or refresh the image control in the
                      >Form_Current event.
                      >>
                      >-Tom.
                      >>
                      >>
                      >>
                      >On Jun 21, 8:41 am, Tom van Stiphout <no.spam.tom7.. .@cox.netwrote:
                      >On Thu, 21 Jun 2007 06:32:39 -0700, EManning
                      >>
                      ><manning_n...@ hotmail.comwrot e:
                      >>
                      >Put all questions in the same table. To select some random questions
                      >from it, use the code in this article:http://www.mvps.org/access/queries/qry0011.htm
                      >as the RecordSource for your form.
                      >>
                      >-Tom.
                      >>
                      >Using A2K. I've got a request to develop a database consisting of
                      >survey questions. There are 2 sets of questions, set A and set B. A
                      >has 12 questions, B has 11. The requester of this database would like
                      >to randomize the questions. The sets would be combined and the
                      >questions randomized. So the user might see a question from B first,
                      >then a question from set A, then another from B, maybe the next 2 from
                      >A, and so on.
                      >>
                      >Has anyone done anything like this before and if so, can you share
                      >what you've done?
                      >>
                      >Thanks.- Hide quoted text -
                      >>
                      >- Show quoted text -
                      >>
                      >Thanks. That was simple enough. Right now, the questions are very
                      >simple and your suggestion will work fine. I anticipate the user
                      >wanting to display pictures with each question. So I'm thinking that
                      >each question will have to be a separate form. If I stored the name
                      >of the form in the table, instead of the question, then a random list
                      >of forms would be returned. I could then go down the list and open
                      >the forms. Does that sound like a good plan or am I missing
                      >something?- Hide quoted text -
                      >>
                      >- Show quoted text -
                      >
                      >
                      >Will do. Thanks for your help.

                        Comment

                        Previous template Next
                        Working...