I have a number of Sql queries that I have to re run daily and weekly to produce tables with data, and than I have to move that data to the reports, and than I have to move that reports to the local drive to send them via e-mail.
Is there a way in ms access to automate this process, and if so how to do that?
I have a number of Sql queries that I have to re run daily and weekly to produce tables with data
Are you SURE you want to store your queries as tables? Why do you want to duplicate data that's already in your database. There are a couple reasons one might want to do this, but you don't come across them very often.
I have to move that data to the reports
Data doesn't get "moved" to a report, ever. Reports are based on either a table or a query, the report never owns the data it's pointing at and data is certainly never "moved into" a report.
Maybe you should be looking at a parameter report...
I have to move that reports to the local drive to send them via e-mail.
Short Answer: DoCmd.SendObject
Long Answer: Again, ARE YOU SURE you want to be saving your reports to the hard drive? There aren't many scenarios where one would want to do this...