Search results

  1. L

    Button on Form to Clear All Table Records

    Thanks so much for the fast reply. That worked perfect!
  2. L

    Button on Form to Clear All Table Records

    Can someone please suggest the VBA code to use on a button in a form that would delete all the records from a table called "tbl_FMC_List"? I am the only person using this form so I just want to click the button and clear all the records from the table.
  3. L

    Problem passing combo box values in form to query

    Should I remove the = after [FNOL Date]?
  4. L

    Problem passing combo box values in form to query

    I believe I have corrected my previous issue but am receiving the following error: "Syntax Error (missing operator) in query expression '[FNOL Date]= Between #3/1/2011# AND #6/30/2011#' Here is my code: 'Set date range for report based off form selection StrWhere = "[FNOL Date]= Between #" &...
  5. L

    Problem passing combo box values in form to query

    Do you or anyone else have any other suggestions on what I am doing wrong? I appreciate any help I can get.
  6. L

    Problem passing combo box values in form to query

    Thanks for the fast reply! I tried your suggestions and still am prompted for the dates.
  7. L

    Problem passing combo box values in form to query

    I am new to this forum so I apologize if I am posting this in the wrong place. I am using a form with 2 combo boxes for the user to enter a start date and end date. I want this to be passed to a query. The form also contains a button to run a report from that query. My issue is I enter the...
Top Bottom