Search results

  1. J

    SQL Update Field based on Two Fields

    On my form, I am trying to update one field in a table where results are based on two fields. My code that is not working is: DoCmd.RunSQL ("UPDATE tbl_1 SET [Field3]=(""" & Yellow & """) WHERE [Field1]=(""" & Brown & """) & [Field2]=(""" & Blue & """);") I have only been able to update with...
  2. J

    Update Multiple Tables with Form Fields

    After creating all the DIM statements and setting the statement to the correct field, I type: DoCmd.RunSQL ("INSERT INTO tableA (Field1,Field2) VALUES (""" & iField1 & """),(""" & iField1 & """)") DoCmd.RunSQL ("INSERT INTO tableB (Field3,Field4) VALUES (""" & iField3 & """),(""" & iField4 &...
  3. J

    Some Query Fields not Appearing on Form

    I have a query that has two tables linked many to one. When I view the query results, all four field(three from table A and one from table B are visible. When I pull the query into the form, the three from table A are populated in text boxes but the field from table B is blank. Please help.
  4. J

    Hello

    From Texas. Intermediate Access user but I want to get better on the advanced things.
Back
Top Bottom