I have worked on root causing the "System Resources Exceeded" issue that I am having. Although I have no overcome it yet, I would like to use error handling to get around the Message Box that pops up.
All I am doing is an Ontimer event to requery the report that's on the screen every 5 minutes.
Will error handling in the vba allow me to avoid the prompt coming up? What might be an example of some code to close the report and open it back up again - I am only a novice with VBA.
Thanks so much for your time. It is much appreciated.