I have a module that imports invoice line item details from an Excel file. At the completion of the import I would like to display the number of records successfully imported into a table named "Invoices". I was using the ImportDate field to specify the records to count. Here's what I was trying:
'MsgBox DCount("*", "Invoices", "ImportDate = #" & Date & "#") & " records imported into Invoices table", vbInformation, "Import"
The MsgBox returns "0 records imported into Invoices table" which is incorrect. All records are being imported correctly. Is someone able to help me with my syntax? The full text of the module is attached in case anyone wishes to offer additional comments or improvements. Thanks.