Hello Everyone,
I have a form which basically is composed of charts and graphs whose details are fed by queries. The form is in ACCDE format distributed to users and the tables are hosted in our company Sharepoint (2013).
Now sometimes when the form is already open, charts loaded, an error pops out which says "A problem occurred while *database* was communicating with the OLE server" and all charts go empty. So far, my solution is to click "OK" on the error message and click the "Reload" button I made which basically makes a re-query and all information appears again.
Is there a way for me to suppress the error and just automatically make a requery whenever it happens?
I'm pretty new at error handling so I'd appreciate it if someone points the right direction so that I'd learn too in the process. Thank you!
I have a form which basically is composed of charts and graphs whose details are fed by queries. The form is in ACCDE format distributed to users and the tables are hosted in our company Sharepoint (2013).
Now sometimes when the form is already open, charts loaded, an error pops out which says "A problem occurred while *database* was communicating with the OLE server" and all charts go empty. So far, my solution is to click "OK" on the error message and click the "Reload" button I made which basically makes a re-query and all information appears again.
Is there a way for me to suppress the error and just automatically make a requery whenever it happens?
I'm pretty new at error handling so I'd appreciate it if someone points the right direction so that I'd learn too in the process. Thank you!