F
fi.or.jp.de
Hi All,
I have userform in excel to search & get data from Access database.
I need to update some values from excel to access.
Right now i am using this code
txt1 = trim(userform1.textbox1.value)
txt2 = Trim(userform1.textbox2.value) ( This is Auto generated number
in Access table )
sSQL = "UPDATE table1 SET table1.[account number] = " & txt1
sSQL = sSQL & " WHERE ID= " & txt2
Similarly I have lot of Textbox and combo box
I don't want to create
if textbox1.value <> "" then perform this operation
elseif do something
elseif do more....
end if
Please help in providing single sql statement which solve all the
queries.
Thanks in advance.
I have userform in excel to search & get data from Access database.
I need to update some values from excel to access.
Right now i am using this code
txt1 = trim(userform1.textbox1.value)
txt2 = Trim(userform1.textbox2.value) ( This is Auto generated number
in Access table )
sSQL = "UPDATE table1 SET table1.[account number] = " & txt1
sSQL = sSQL & " WHERE ID= " & txt2
Similarly I have lot of Textbox and combo box
I don't want to create
if textbox1.value <> "" then perform this operation
elseif do something
elseif do more....
end if
Please help in providing single sql statement which solve all the
queries.
Thanks in advance.