Recent content by Tony1949

Response to replies! pbaldy: You have hit the nail on the head! I have always opened my reports in VBA using the acViewPreview option - and this option does not fire the OnTimer event. I have just tried opening the report using the acViewReport option - and the OnTimer event is now firing...

I have a database which allows a user to open a report in preview mode. The user then has the option whether or not print it. I am trying to use the report's timer event to automatically close the report after a predetemined period of inactivity as users have a habit of leaving reports open...

I just want to change the default to be appropriate for the current report.

I am developing an application in Access 2007 and wish to control various printer options from within VBA code. Specifically I want to control whether pages are printed first-to-last or last-to-first. I am unable to find a suitable property within the the printer object and I'm not aware of...

I am developing a test bed for my Access 2007 application and wish to export various reports in txt format so I can perform a simple automated file comparison to detect any differences between the current and previous versions of the reports. I can successfully export the reports in txt format...

In Access 2003 I used the following command within the report Activate Event to change the default directory... Application.SetOption "Default Database Directory", gstrReportsDirectory ...where gstrReportsDirectory is a global variable containing the required directory name. Then, with the...