Open Report using template and write too it

[lovett10]

I am looking how to create a button that will create a report from the chosen table in the format of my template.

one of the table is called CP001 Field and Plant and the template is called CP Field and Plant Template


I would also like an archive button which would save the databases with the date on it.

Thanks for any help, much appreciated