Search results

Do i need to change this: Set rst = dbs.OpenRecordset(sql) DoCmd.RunSQL "update proveedores set nrefs=0" While Not rst.EOF DoCmd.RunSQL "update proveedores set nrefs=" & CDbl(rst!cuantos) & " where idproveedor='" & rst!Proveedor & "'" for this?: set dbs = Currentdb dbs.execute "update...

Is actually added

Data type mismatch in criteria expression But its weird because in another computer with same code and references is working

Well i don't really know about access and VB... and for what i've been told, this is an old access database... it was working time ago, but i think that with 365 version of Access it doesnt work properly

Hi, I'm getting error 3464 while executing this code: Sub PonerNRefsProveedores() Dim dbs As DAO.Database Dim rst As DAO.Recordset Dim sql As String sql = "SELECT * from nrefs" Set dbs = CurrentDb Set rst = dbs.OpenRecordset(sql) DoCmd.RunSQL "update proveedores set nrefs=0" While Not...