Recent content by moyi

Thanks. I got it.

SOLVED Hello, I need to use field (TA113) when the form is loaded. The value of this field needs to be assigned from another field (A1TO13) from another form(frmS3A113). I have my code below: Private Sub Form_Load() Dim x As Integer x = Forms!MainS3!frmS3A113!A1TO13.Value...

Thanks. Plog's answer is wonderful if my respondents only need to select the number of questions that they want to answer, but in this case, they have to answer all 13 questions. This means I need to set up a rule to ask each of them to create 13 records, which I don't know how to do and make...

I'm thinking to use counting function too. For example, if I can count how many answers equal to 1, how many answers equal to 2, then I can use a variable to calculate the total.

Thank you. Do you think it's possible to use loop function in this code?

Dear plog, thanks for the thought. I agree that long table may looks easier to make the query, but it's difficult to put them on a form. Each respondent needs to answer 13 questions (fields), but if I use a long table, I can't guarantee that each respondent will get 13 records.

Hey Bob, Yes, it is bounded to a table and the field stores number instead of the text. The sum needs to be automatically shown once the users give the answers to these 13 fields. Many thanks.

Thank you Ranman, but I need the sum to be automatically shown up once the users enter their answers. I can't create a table manually later.

Hello all, thanks for answering my question. I have a form with 13 fields. Each field has can be coded as "1 = yes, 2= suspected, 3=no, 999=don't know, 888 = not applicable, 998 = refused to answer". I need to sum these 13 fields together ([SUM13]), but 999, 888, or 998 should be treated as...

Thank you, I was looking for this too!

Hello all, I'm a new beginner of Access. I have 23 checkbox. I need to create a report for each user. The report shows fields that the user had checked only. I don't know how to make it. I was told that a query may help, but I don't know how to filter the query either. For example, if I...

Thank you George, I tried Mark's code. It worked very well :)

Thank you so much, Mark!

Hello, I have a question about how to automatically change other field's properties when a filed changes without clicking. on the form, I have a field called "DIADL". it is a sum of D1 to D7. If the sum of D1 to D7 equals to 24, then fields D9 to D15's won't be seen (acPropertyVisible = 0)...

Hey, I just started to learn the Access.:banghead::banghead::banghead::banghead: