Can someone please assist me on below.
I want to update the records in microsoft access using VB6. It works fine with below code. But I want to take the column name from user (textbox6) instead of fixed parameter.
What should be the code
Set mySet = mydb.OpenRecordset("Sheet1", dbOpenDynaset)
mySet![Vertical] = data1.Text