Recent content by swicked

  1. S

    Schedule Event Procedure (acOutputReport) to run Daily at specified time

    I have a Module and Macro create to run the event procedure - but due to security feature - I have to manually enable VBA macro. Therefore once the Database is open I can run the Macro - but not have the macro run upon opening. Is there a way around this or a way to schedule the macro to...
  2. S

    Schedule Event Procedure (acOutputReport) to run Daily at specified time

    I have an Access 2007 database in which every morning I manually initiate an event procedure (DoCmd.OutputTo acOutputReport), by clicking a Button, to output 5 preformatted reports as a PDF into a specific folder. This works great - though I'd like to schedule it to run Daily at 6AM. Is this...
  3. S

    Return all dates within a date range as separate result

    :banghead:I have a training database (Access 2007) in which a CLASSNAME is listed with both a STARTDATE and ENDDATE. I would like to create a query that would return all dates from within the date range - to create a calendar type result For example: TABLE=DATE CLASSNAME STARTDATE...
Back
Top Bottom