J
Jamal
I have the below script to update a table;
Dim db3 As DAO.Database
Dim rst3 As DAO.Recordset
Set db3 = Access.Application.CurrentDb
Dim sql3 As String
sql3 = "update [DTII & DTM Hardware assests] set [Machine Name] = '" &
CompName & _
"', [Dealer #] = '" & dlrnm & _
"', [Unit ID] = '" & ui & _
"', [dtiiversion] = '" & dtiiv & _
"' where [unitid] = '" & ui & "'"
db3.Execute sql3
db3.Close
Set rst3 = Nothing
Set db3 = Nothing
For some reason update sql command is not working.
I see the values are there because I add watch to each variable.
please help.
Dim db3 As DAO.Database
Dim rst3 As DAO.Recordset
Set db3 = Access.Application.CurrentDb
Dim sql3 As String
sql3 = "update [DTII & DTM Hardware assests] set [Machine Name] = '" &
CompName & _
"', [Dealer #] = '" & dlrnm & _
"', [Unit ID] = '" & ui & _
"', [dtiiversion] = '" & dtiiv & _
"' where [unitid] = '" & ui & "'"
db3.Execute sql3
db3.Close
Set rst3 = Nothing
Set db3 = Nothing
For some reason update sql command is not working.
I see the values are there because I add watch to each variable.
please help.