A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Display question in random order OR Use variable to define properties



 
 
Thread Tools Display Modes
  #1  
Old April 11th, 2007, 03:26 PM posted to microsoft.public.access.forms
[email protected]
external usenet poster
 
Posts: 1
Default Display question in random order OR Use variable to define properties

I am building a survey in Access 2003. One of the questions has 5
possible answers, and respondents can select all that apply. I have
created a checkbox for each of these questions.

Each time the form is opened, I want the questions to display in a
random order. I have created a random number generator selecting 1 to
5 only once that works fine. Each checkbox on the form is named in
the following format chkq31, chkq32, etc... I know the position on
the form that I want for each checkbox using the Top and Left
properties. I created a variable for each question order (not the
question #), and using the number generator, dynamically change the
name of the question that is assigned to a certain position on the
form.

For example:

q1chknm = "chkq3" & array(1) (The result would be something like
chkq32)

This works for all the questions

What I'm trying to next does not work

q1chknm.top = 1000

Is there a way to get this last step to work?

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:14 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.