As I said, you need to change the code to match the control names you do have. So, if you have a form that has an option frame with a name of Frame21 then you would change the code from Select Case Frame88 to Select Case Frame21. Does that make sense?
Thanks Mr. boblarson!!! you have saved me over and over again!!!! I'm almost there!!!!!!
First (puzzle #1)
How to autofill formulated fields that are hidden but deposits their results in the data table? (Again, because of SPSS it needs to function this way...) is it possible?
Here is the scenario (see attachment)
In this form “p1_Form3_Special_Order” at the bottom highlighted by a big red box (near footer) there are 10 text boxes linked to the main data table. I.e. I plan on hiding these boxes when calculations work.
What I would like to have happen is:
Part one,
When a user enters a numeric figure in this field “fp1_f3_1a_Special_Order” the hidden field “p1_f3_1b_Special_Order” does the following calculation, and the Main_Database captures the result
The calculations for the field “p1_f3_1b_Special_Order” needs to perform are:
________
IF “p1_Form2a_Special_Order”, “Frame84” = a value of “1” (Simple quote (5 or less)) AND field “p1_f3_1a_Special_Order” = <5 (5 or less) then, field “p1_f3_1b_Special_Order” should calculate and result a “1” ß or “True” otherwise if sum is greater than ”5” then it should calculate and result in a “2” ß “False”
AND/OR
IF “p1_Form2a_Special_Order”, “Frame84” = a value of “2” (Complex quote (6-12) AND field “p1_f3_1a_Special_Order” = >5 but <12 (12 or less) then, field “p1_f3_1b_Special_Order” should calculate and result a “1” ß or “True” otherwise if sum is greater than ”12” then it should calculate and result in a “2” ß “False”
_______
Part Two,
When a user enters a numeric figure in this field “p1_f3_2a_Special_Order” the hidden field “p1_f3_2b_Special_Order” does the following calculation, and the Main_Database captures the result
The calculations for the field “p1_f3_2b_Special_Order” needs to perform are:
________
“p1_f3_2a_Special_Order” = 1 then, field “p1_f3_2b_Special_Order” should calculate and result a “1” ß or “True” otherwise if sum is greater than ”1” then it should calculate and result in a “2” ß “False”
________
Second (puzzle #2)
The following forms (listed below) all have optional text boxes based on a response…
Example
Yes
No –> if no, please specify: ____________________
Is there any way to hide the “please specify” text box and label for it until they select “No” from the Yes/No options. This would eliminate clutter on the form, and would prevent false data, incase user click on “Yes” then proceed to enter data in the “if no, please specify:” text box.
I think this is basic questionnaire practice, but I do not see any options to make this happen?
This situation happens in the following forms
· p1_Form1_Stock_Order
· p1_Form2b_Special_Order
· p1_Form5_Special_Order
· p1_Form6_Special_Order
· p1_Form7_Special_Order
· p1_Form8_Special_Order
· p2_Form1_Special Order
Again, I’m a noob, and ignorant to VB and database design principles. I think it’s not too bad for my very first database.
Please do not think I’m not helping myself, I have been working on this since Monday, and I’m sure most of you could have done this in a couple of hours… my plan is to finish this one quick, as it’s needed right away… then rebuild it from the ground up with a better understanding of design or normalization, and I will most definitely pick up a book or two and get right into this, although, it has got me a few headaches, I really enjoyed this… again thanks for your help!
-Pied piper!
