Hope all are having a good day.
I am running code in VBA to collect data from an Excel file and add that data to a table.
It works fine as long as I have at least one record in the table. But if the table is empty I get an error "Invalid Use of Null" on the following:
Dim MaxDayTest As Integer
MaxDayTest = DMax("[day]", "tbl_Calls_DR") 'Test for last day calls pulled
Does anyone know why or what I can use to test for an empty table before it hits this declaration.
I am running code in VBA to collect data from an Excel file and add that data to a table.
It works fine as long as I have at least one record in the table. But if the table is empty I get an error "Invalid Use of Null" on the following:
Dim MaxDayTest As Integer
MaxDayTest = DMax("[day]", "tbl_Calls_DR") 'Test for last day calls pulled
Does anyone know why or what I can use to test for an empty table before it hits this declaration.