Search results

  1. A

    Export a form's recordset to a table

    Thanks that worked for just the two fields but I want to add the rest of the fields I'm getting an error '3134' Syntax error in INSERT INTO statement: I'm wondering if my quotes are correct around my values. Here's my code: Private Sub cmdAddToTable_Click() Dim tmpRS As DAO.Recordset...
  2. A

    Export a form's recordset to a table

    oh, you lost me :confused: I can not edit the query because the subform is based on it. Allen Brown's code just filters the fields on the subform based on combo box selection in the main form. Do I need to add a select and where clause to my code? Thanks!
  3. A

    Export a form's recordset to a table

    This is what I got but none of it looks odd to me or should I be including the ID in the output of my query?: INSERT INTO tblResultsTracking (ID, Business_Line) SELECT tblAUCodes.Business_Line, tblPacsData.Created_Date, tblPacsData.Updated_Date, tblPacsData.[Template_ID]...
  4. A

    Export a form's recordset to a table

    Thank you! I attempted the following but got an error 'Run-time error '3346': Number of query values and destination fields are not the same. Private Sub cmdAddToTable_Click() Dim tmpSQL As String tmpSQL = Me.frmPacsVerificationSubForm.Form.RecordSource 'CurrentDb.Execute...
  5. A

    Export a form's recordset to a table

    Hi, I'm using Allen Brown's code for search criteria found at allenbrowne.com/ser-62code.html. I will attempt your suggestion. Where within my module would I add your code? Thank you!
  6. A

    Export a form's recordset to a table

    I have a main form with combo boxes to filter a subform. I want to be able to export the filtered subform data to a table within the database and only include the filtered dataset not all records. I'm new to VB code and need some help. TIA
View older results
Back
Top Bottom