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.
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 #" &...
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...