Ben, you can create a form that has a Timer event. Set the form's Timer Inverval to check once per hour, for example. When the desired time of day occurs, use the DoCmd.RunSQL code to run the queries. To turn your queries into SQL code just open them up in design view and click VIEW > SQL VIEW to get the statement.
Have a flag, say, fDone set false and when the SQL is run, set it to true so that the queries don't run for the rest of the day. Then at midnight, set the flag back to false.
Michigan Dept. of Environmental Quality, Air Quality Division