stevekos07
Registered User.
- Local time
- Today, 08:22
- Joined
- Jul 26, 2015
- Messages
- 174
I have a problem with a runtime error 2046. It relates to a macro not being able to run on the close of a form. This form is a hidden form that has an OnClose event that runs two macros.
The first macro is macDailyStatsBackup which runs perfectly. This macro opens a series of update and append queries to perform backups to various tables.
The second macro is macDailyCallSheetsBackup which is a series of 18 ExportWithFormatting events that saves individual call sheets as PDF's which are then backed up to a USB via a Windows batch file, for use if there is a system interruption the following morning. (These call sheets are used to call aged vulnerable clients who receive daily welfare check calls as part of their care package).
It is this second macro that is causing the error.
I have read some information regarding this bug but as my knowledge of VBA is limited I might need some "hand holding" in dealing with this.
The first macro is macDailyStatsBackup which runs perfectly. This macro opens a series of update and append queries to perform backups to various tables.
The second macro is macDailyCallSheetsBackup which is a series of 18 ExportWithFormatting events that saves individual call sheets as PDF's which are then backed up to a USB via a Windows batch file, for use if there is a system interruption the following morning. (These call sheets are used to call aged vulnerable clients who receive daily welfare check calls as part of their care package).
It is this second macro that is causing the error.
I have read some information regarding this bug but as my knowledge of VBA is limited I might need some "hand holding" in dealing with this.
