Search results

Thanks u very much Sir , it is working now, if there is anything or anywhere i will stuck, i will ask i a am new in VBA Coding , that's need help

Not working and from where ID will get the value? it is supposed to come from Excel Sheet Range. sql = "SELECT * FROM Table1 WHERE Invoice = " & id

when i put If .Supports(adUpdate) Then .Edit, the error is coming saying Compile error. One more thing sql = “SELECT * FROM Table1 WHERE Invoice = ” & id Instead of using "& id , if i am using '12345' (the data which is already in my database) it is updating the fields related to this...

Public Const Conn As String = “Data Source= C:\Users\Atif\Desktop\New Database\Sample.accdb;” Sub ADODBUpdating() On Error GoTo ErrorHandler Dim sql As String Dim rs As ADODB.Recordset Dim cn As New ADODB.Connection Dim id As String id = Range(“H1”) cn.Open...

Using someone's code found on internet and modified it I want to use cell value from Excel sheet. It is picking the value from the cell but not searching the record in my access database to update the fields of the same record. Can u please help me out. Thanks. Records are adding without any...