RsUsers.Open "select * from Users", conn_mod, adOpenStatic, adLockOptimistic The Connection: Public conn_mod As ADODB.ConnectionĬonn_mod.ConnectionString = "Provider=.4.0 Data Source=" & pathx MsgBox ("Please hit UPDATE to refresh list and unblock list"), vbCritical, "REFRESH" MsgBox ("Error occured"), vbCritical, "Error" MsgBox ("please fill the appropriate fields!"), vbCritical 'This is the code that SHOULD update and overwrite the exsiting record but it doesnt workĪnd this is how the editrec private sub gets called upon. When i try to EDIT/UPDATE an existing record, a new record is created and completely replaces the first record in the table, so i would end up with 2 almost similar records and the first record in the table replaced.
However i cant EDIT/UPDATE already existing records. Most of the controls i have figured out to help me: create new records, delete records and so on. My project (stock control) uses a listview to keep show the records in a Microsoft access database. OK so im really desperate or i wouldn't have brought this up.
0 kommentar(er)
