Search results

  1. M

    assign a value from another form

    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...
  2. M

    Create a sum query based on specific values

    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...
  3. M

    Report only checked fileds

    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...
  4. M

    automatically change other fields' properties after a calculated filed changes

    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)...
    • moyi
    • Thread
    • Replies: 4
    • Forum: Forms
  5. M

    Hello from Cleveland

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