I am attempting to update a table in Access/VBA using SQL. Here is the statement:
MySQL = "UPDATE ParsingTable SET ParsingTable.[Tier1] = intTier1, ParsingTable.[Tier2] = intTier2, ParsingTable.[Tier3] = intTier3, ParsingTable.[Tier4] = intTier4, ParsingTable.[Tier5] = intTier5 WHERE (((ParsingTable .doc_label) = strReference)); "
DoCmd.SetWarnin gs False
DoCmd.RunSQL MySQL
DoCmd.SetWarnin gs True
When I execute the SQL Update it asks me for "data input" for each of the variables intTier1 through intTier2 as well as strReference. All of the intTier1-5 variables are Dim as Integer and have values in them. strReference is DIM as String and has a value in it.
Why is the module asking for input values for all of my variables?
Thx
Mark
MySQL = "UPDATE ParsingTable SET ParsingTable.[Tier1] = intTier1, ParsingTable.[Tier2] = intTier2, ParsingTable.[Tier3] = intTier3, ParsingTable.[Tier4] = intTier4, ParsingTable.[Tier5] = intTier5 WHERE (((ParsingTable .doc_label) = strReference)); "
DoCmd.SetWarnin gs False
DoCmd.RunSQL MySQL
DoCmd.SetWarnin gs True
When I execute the SQL Update it asks me for "data input" for each of the variables intTier1 through intTier2 as well as strReference. All of the intTier1-5 variables are Dim as Integer and have values in them. strReference is DIM as String and has a value in it.
Why is the module asking for input values for all of my variables?
Thx
Mark
Comment