2 Column Rpt-Even numbered questions need different alphabetic ans

  • Thread starter Thread starter Public Schools
  • Start date Start date
P

Public Schools

How do I write statement to change A to F; B to G; C to H; and D to J? For
example:

I have a 2-column report. First column has question with A,B,C,D option
answer. Second column has question with A,B,C,D option answer BUT needs to
have F,G,H, J as the option. How do I make this happen?

1. What is 2 +3? 2. What 4 X 5?
A. 5 A. 23 Should be F.
B. 8 B.17 Should be G.
C. 12 C. 20 Should be H.
D. 1 D. 9 Should be J.

Currently, column two on my report has A, B, C, D due to report design.

Thank you for your assistance.
 
Public said:
How do I write statement to change A to F; B to G; C to H; and D to J? For
example:

I have a 2-column report. First column has question with A,B,C,D option
answer. Second column has question with A,B,C,D option answer BUT needs to
have F,G,H, J as the option. How do I make this happen?

1. What is 2 +3? 2. What 4 X 5?
A. 5 A. 23 Should be F.
B. 8 B.17 Should be G.
C. 12 C. 20 Should be H.
D. 1 D. 9 Should be J.

Currently, column two on my report has A, B, C, D due to report design.
Click to expand...


Assuming the A,B,C,D are in bound text box controls,

If Me.Left >= {the report's left margin in twips} _
+ {the column width in twips} Then
Me.txtA = "F"
Me.txtB = "G"
. . .
End If
 
Mr. Barton,
I apologize for my delay in responding. I've been trying to do as you
instructed for almost a week and still cannot get it to work. Would you
please help me a little more?

My report is called: Grade 6 Mathematics Test Selection. It is pulling
selected questions from a query. The answers -- A,B,C,D are labels to bound
object frames (i.e. Label: AnswerA_Label is attached to Bound Object Frame A,
Label: AnswerB_Label is attached to Bound Object Frame B, etc.).

My reports left margin is 0.5" and column width is 3.65"; so my twips for
left margin would be 720 twips and 5256 twips for column width. When I put
in the code I either get an error on Me. or Left, or >=. Then when I go back
to the report, there are no changes.

Please help! I am in design view, I select the VBA icon, then I type in

Public Sub Column_Alpha_Change()
'Change Alpha in second column.

If Me.Left >= 720 + 5256 Then

Me.txtA = "F"
Me.txtB = "G"
....

End If

Should txtA be AnswerA_Label?

Help! This is the key to the puzzle.

Thanks again.
 
Public said:
I apologize for my delay in responding. I've been trying to do as you
instructed for almost a week and still cannot get it to work. Would you
please help me a little more?

My report is called: Grade 6 Mathematics Test Selection. It is pulling
selected questions from a query. The answers -- A,B,C,D are labels to bound
object frames (i.e. Label: AnswerA_Label is attached to Bound Object Frame A,
Label: AnswerB_Label is attached to Bound Object Frame B, etc.).

My reports left margin is 0.5" and column width is 3.65"; so my twips for
left margin would be 720 twips and 5256 twips for column width. When I put
in the code I either get an error on Me. or Left, or >=. Then when I go back
to the report, there are no changes.

Please help! I am in design view, I select the VBA icon, then I type in

Public Sub Column_Alpha_Change()
'Change Alpha in second column.

If Me.Left >= 720 + 5256 Then

Me.txtA = "F"
Me.txtB = "G"
...
End If

Should txtA be AnswerA_Label?
Click to expand...


If AnswerA_Label is a label control (instead of my assumed
text box control), then try using:

If Me.Left >= 720 + 5256 Then

Me.AnswerA_Label.Caption = "F"
Me.AnswerB_Label.Caption= "G"
....
End If

Make sure you call the procedure from the report's detail
section's Format event procedure.
 
OMG!!!!!! IT WORKED! YOU ARE THE GREATEST! I could cry!

Thank you, thank you, thank you!
 
I'm sorry to bother you again, but I've encountered another problem with this
process. Page 1 works great in print preview. Second column is listed as F,
G, H, J; however, columns 1 and 2 of the pages that follow are F,G,H,J. Also
when it prints, page 1 converts to F, G, H, J. So when I print my report all
the questions in both columns are F,G,H,J. Am I doing something wrong?
Please help me. I've searched the community for information on references to
the second column but could not find an aswer.

Thank you, in advance, for your time.

P.S. You are a blessing!
 
Public said:
I'm sorry to bother you again, but I've encountered another problem with this
process. Page 1 works great in print preview. Second column is listed as F,
G, H, J; however, columns 1 and 2 of the pages that follow are F,G,H,J. Also
when it prints, page 1 converts to F, G, H, J. So when I print my report all
the questions in both columns are F,G,H,J. Am I doing something wrong?
Please help me. I've searched the community for information on references to
the second column but could not find an aswer.
Click to expand...


What do you want them to be?

What is in the first column?

How does the second column relate to the first column?
 
Background: I am developing a test for students. Teachers randomly select
questions on a form I designed. I've developed a query for the selected
questions. This produces the report/test for the kids to take. The test has
to be 2 columns per page. I had to use object fields for the answer options
because this is a math test which has a lot of equations and graphics. I
pasted pictures in MSWord and copied and pasted picture and question into
object field.

Question: I've set page to have 2 columns using the page setup on the
report. I added a text box to allow numbers to flow succinct. I've hidden
actual question number because the query generated random test questions but
I still needed to link question ID to report for test purposes .

I would like page 1 to have question 1 and 2 of test. Question 1 answer
selection should be A, B, C, D and Question 2 answer selection should be F,
G, H, J. On page 2, Question 3 answer selection should be A, B, C, D and
Question 4 answer selection should be F, G, H, J and so on.

ex.
Page 1
Name ____________
Date _____________

1. What is 2 +3? 2. What 4 X 5?


A. 5 F. 23
B. 8 G.17
C. 12 H. 20
D. 1 J. 9

Page 2
3. Which of the following shapes 4. Which of the following could
is a triangle? not be the graph
of function x?

A. Picture of circle F.Picture of a graph
B. Picture of triangle G. Picture of a graph
C. Picture of square H. Picture of a graph
D. Picture of rectangle J. Picture of a graph

Page 3 ....

The answers -- A,B,C,D are labels to bound object frames (i.e. Label:
AnswerA_Label is attached to Bound Object Frame A, Label: AnswerB_Label is
attached to Bound Object Frame B, etc.). I need all the even numbered
questions to be labeled F, G, H, J. What you suggested worked great for the
first page. However when I hit print it changed to FGHJ.

I also tried to add a subreport for column 2 with the FGHJ but was unable to
generate the questions to flow on the test correctly and there is no way of
knowing the exact number of questions on the test because teachers will be
randomly selected them.

Thanks for you time,
I anxiously await your help.
 
Public said:
Background: I am developing a test for students. Teachers randomly select
questions on a form I designed. I've developed a query for the selected
questions. This produces the report/test for the kids to take. The test has
to be 2 columns per page. I had to use object fields for the answer options
because this is a math test which has a lot of equations and graphics. I
pasted pictures in MSWord and copied and pasted picture and question into
object field.

Question: I've set page to have 2 columns using the page setup on the
report. I added a text box to allow numbers to flow succinct. I've hidden
actual question number because the query generated random test questions but
I still needed to link question ID to report for test purposes .

I would like page 1 to have question 1 and 2 of test. Question 1 answer
selection should be A, B, C, D and Question 2 answer selection should be F,
G, H, J. On page 2, Question 3 answer selection should be A, B, C, D and
Question 4 answer selection should be F, G, H, J and so on.

ex.
Page 1
Name ____________
Date _____________

1. What is 2 +3? 2. What 4 X 5?


A. 5 F. 23
B. 8 G.17
C. 12 H. 20
D. 1 J. 9

Page 2
3. Which of the following shapes 4. Which of the following could
is a triangle? not be the graph of function x?

A. Picture of circle F.Picture of a graph
B. Picture of triangle G. Picture of a graph
C. Picture of square H. Picture of a graph
D. Picture of rectangle J. Picture of a graph

Page 3 ....

The answers -- A,B,C,D are labels to bound object frames (i.e. Label:
AnswerA_Label is attached to Bound Object Frame A, Label: AnswerB_Label is
attached to Bound Object Frame B, etc.). I need all the even numbered
questions to be labeled F, G, H, J. What you suggested worked great for the
first page. However when I hit print it changed to FGHJ.
Click to expand...


Let's try changing the code to:

If Me.Left < 2000 Then
Me.AnswerA_Label.Caption = "A"
Me.AnswerB_Label.Caption= "B"
Me.AnswerC_Label.Caption = "C"
Me.AnswerD_Label.Caption= "D"
Else
Me.AnswerA_Label.Caption = "F"
Me.AnswerB_Label.Caption= "G"
Me.AnswerC_Label.Caption = "H"
Me.AnswerD_Label.Caption= "J"
End If
 
Back
Top