Search results

Hello All, I am unable to populate the records fetched from a recordset (r) in Form A into Form B. This is Form A. In this form, I have 3 text boxes which are populated using a sql query that is stored in a recordset (r). Once the user click on EDIT EMP INFO, it should use the CPS_REP_ID and...

Hello, Below is the code where I want to make it using pass through query. Can anyone guide me how can i achieve the below logic and implement using PTQ? Dim rs1 As New ADODB.Recordset Dim strSQL As String strSQL = "SELECT * FROM SQLTABLE;" rs1.Open strSQL, DC.ASSIGNMENT_DATA, adOpenKeyset...

Hello, I have the below code that I am trying to delete the records from access table (listtable) and then adding the records from SQL (SQL table) DoCmd.SetWarnings False DoCmd.RunSQL "Delete * From LISTTABLE;" DoCmd.SetWarnings True strSQL = "SELECT * FROM LISTTABLE;" r1.Open...