I have a macro which I want to run once a day when the database is opened without me having to manually click some buttons, how can i make that happen?
How does your db startup? If you use an "Autoexec" macro, you can run it from within there (RunMacro). If you use the Startup facilities, you can type the macro name in the "On Open" event of your Switchboard (or Form) properties.