R Rick B Jul 21, 2005 #2 Not using any built in functionality. If the database is open, yo ucan have code that runs and checks the system date and time to perform functions.
Not using any built in functionality. If the database is open, yo ucan have code that runs and checks the system date and time to perform functions.
D Dodo Jul 21, 2005 #3 Can you schedule monthly reports to run automatically in Access? Click to expand... There are some command line options available for Access. See: http://www.vb123.com/workbench/help/commandline.htm Using the switch "/x macro_name" will execute that macro, so if you create a shortcut like c:\office\msaccess.exe "C:\path_to_your_database \name_of_your_database.mdb" /x macro and have it executed in (task) scheduler it will at the date/time open that database in Access and run the macro. If you include action to open and print the report you probably get more or less what you are looking for.
Can you schedule monthly reports to run automatically in Access? Click to expand... There are some command line options available for Access. See: http://www.vb123.com/workbench/help/commandline.htm Using the switch "/x macro_name" will execute that macro, so if you create a shortcut like c:\office\msaccess.exe "C:\path_to_your_database \name_of_your_database.mdb" /x macro and have it executed in (task) scheduler it will at the date/time open that database in Access and run the macro. If you include action to open and print the report you probably get more or less what you are looking for.
