Search results

Need assistance on resolving this 7951 error message. When I run thru debug, it failed on .RecordsetClone.Requery statement. Could someone help me? Here are my codes: Private Sub cmdAddPO_Click() Dim strSQL As String Dim ws As DAO.Workspace Dim db As DAO.Database Dim rst As DAO.Recordset...

I have encountered the same error message with the following codes. Any suggestions are welcome. Private Sub cmdAddPO_Click() Dim strSQL As String Dim ws As DAO.Workspace Dim db As DAO.Database Dim rst As DAO.Recordset Dim bintrans As Boolean On Error GoTo cmdSave_Click_Error If...

Sorry perhaps my previous posting is not clear. The form that I created contains unbound fields. Instead of using a form with bind fields, I added some customization query codes to some input fields. After input the data to these fields, how do I insert a record to the table with all these...

I see the issue. No, the data comes from the input on the form, some from combo box and some from text box. How would the SQL syntax be for data coming from the form input?

I have encountered a similar error message with the following SQL. Can someone provide me some suggestions? Much appreciated. strSQL = "INSERT INTO tblVendors ( cmdVendorID, cmdVendor, cmdVendorType, cmdFacilitator, cmdAddress1, cmdAddress2, cmdCity, cmdState, cmdZip, cmdContact...