Deny Export of Empty Tables

[BR549]

Hello, novice here, and new member of AccessForums.net. Thank you for the access to your forums.

My database has 4 tables of which I created queries to gather the information I need out of those tables. I created a form to do all the queries in the background and have created the commands to export the files. Which is where the rub is. If my table is empty, I want the code to ignore exporting the table and move on.

Here is the export code:
strPath = "C:\Users\me\Desktop\Export\Raw Data Path.xlsx"
DoCmd.TransferSpreadsheet acExport, 10, "tbl A Path", strPath, True, "A Path"
DoCmd.TransferSpreadsheet acExport, 10, "tbl B Path", strPath, True, "B Path"



Thank you...

[June7]

Try:

If DCount("*","TableA") <> 0 Then
'export
End If

Are these 4 tables the same in structure?

[BR549]

The queries run on the four tables and create another 20 from each of the 4 for a total of 80 tables. Then I have the export set up to extract 4 tables into 1 excel file with 4 sheets. At the end of this process all the tables including the 4 are deleted and then the following month we import 4 new main tables and run the queries and exports all over again. it is a small database to cut the work down for hours of extracting all the data into a few minutes. The only thing that stays the same are the queries.

[BR549]

I did put that code in and it works like a champ. Thank you very much.