Access VBA SQL Update - Too few Parameters expected 1

Question

I am new to access VBA.

I am trying to add 1 to all numbers in a field that are equal or greater than the value in text box [TP_Bld_OrderNum_Txt].

This is my code:

CurrentDb.Execute "UPDATE TP_Matrix " & _
      "SET TP_Matrix.Order_" & Me.TP_Bld_TP_Cbo & " = TP_Matrix.Order_" & Me.TP_Bld_TP_Cbo & "+1 " & _
      "WHERE TP_Matrix.Order_" & Me.TP_Bld_TP_Cbo & ">= Me.TP_Bld_OrderNum_Txt"

I get this error:

too few parameters expected 1

I believe it relates to the text box value.

If I replace Me.TP_Bld_OrderNum_Txt with a number, the query works fine.

I have the text box set up as a number.

Why doesn't it recognize its value?

AHeyne · Accepted Answer · 2020-02-17 11:27:55Z

2

You provided Me.TP_Bld_OrderNum_Txt as a literal (as a fixed string) and not its value:
& ">= Me.TP_Bld_OrderNum_Txt"

Try this instead:
& " >= " & Me.TP_Bld_OrderNum_Txt.Value

Also, it is a good practice to use .Value to explicitely use the value of the control.

answered Feb 17, 2020 at 11:27

AHeyne

3,5052 gold badges13 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Access VBA SQL Update - Too few Parameters expected 1

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related