Yes, there is, but it does get complicated.
A VBScript file can be set to run on a schedule defined in Windows TaskScheduler. Code in the script file calls Access code. Example:
Code:
Set accessApp = CreateObject("Access.Application")
accessApp.OpenCurrentDataBase "C:\Users\June\recur2.mdb"
accessApp.UserControl = False
accessApp.Visible = False
accessApp.Run "TestVBA"
'accessApp.DoCmd.RunMacro "TestMacro"
accessApp.Quit
VBScript is created with a simple text editor (Notepad will serve) then rename with .vbs file extension.
The called VBA procedure would run code sending email with filtered report.
So you really have two parts to solution: 1) the VBA procedure 2) the VBScript.
Tackle one at a time.