Hi,
I've created a VBA driven filter form attached to my staff report which works perfectly. My problem is now I'm trying to add an export to snapshot button to the filter form.
The code bombs when trying to export the report with 'error 2585 - This action can't be carried out while processing a form or report event'.
I've searched the net for this error and all the info points to the open or activate event of my report running while it's trying to export (the open event of my report has the code to open my filter form).
Is there any command in Access that can temporarily turn off report events (like application.enableevent = false in Excel VBA)?
I'm a complete beginner at databases in general but do have some Excel VBA knowledge. Any advice or a nudge in the right direction would be much appreciated.
Thanks,
Knifey
I've created a VBA driven filter form attached to my staff report which works perfectly. My problem is now I'm trying to add an export to snapshot button to the filter form.
The code bombs when trying to export the report with 'error 2585 - This action can't be carried out while processing a form or report event'.
I've searched the net for this error and all the info points to the open or activate event of my report running while it's trying to export (the open event of my report has the code to open my filter form).
Is there any command in Access that can temporarily turn off report events (like application.enableevent = false in Excel VBA)?
I'm a complete beginner at databases in general but do have some Excel VBA knowledge. Any advice or a nudge in the right direction would be much appreciated.
Thanks,
Knifey