A
Alain
Hi to all,
can anyone explain to me why I cannot udpate a table base on the following
code:
Dim bds As DAO.Database
' mise a jour du champ lenght dans la table Client Principal
CurrentDb.Execute _
"UPDATE [Client Principal] SET [LeaseLenght] = " & dblnum & " WHERE
[ClientNumber] = '" & num & "'"
Set bds = Nothing
the num variable is a string and the dblnum is a bouble, when I run the code
line by line, it give me no error and goes thru well the variable have the
correct numbers I just cannot pinpoint the reason why the value on my table
is the same
Any help in understanding will be greatly appreciated
Alain
can anyone explain to me why I cannot udpate a table base on the following
code:
Dim bds As DAO.Database
' mise a jour du champ lenght dans la table Client Principal
CurrentDb.Execute _
"UPDATE [Client Principal] SET [LeaseLenght] = " & dblnum & " WHERE
[ClientNumber] = '" & num & "'"
Set bds = Nothing
the num variable is a string and the dblnum is a bouble, when I run the code
line by line, it give me no error and goes thru well the variable have the
correct numbers I just cannot pinpoint the reason why the value on my table
is the same
Any help in understanding will be greatly appreciated
Alain