When I go to debug I'm getting "This action will reset your project, proceed anyway?". The problem occurs in a certain sub-form, with classes & user-declared events... My code is running fine, but this does not seem good practice; or am i being pedantic? I've stepped through code looking at the call-stack & I cannot see any issues.
Is it inevitable that when there are user-declared events/ normal events the code will be in a 'suspended' fashion (do not think so) & the IDE will always prompt this warning or do I have something seriously wrong here? Seems https://www.mztools.com/ will identify the issue but I'd rather save some money & try to figure out where I'm going wrong if possible. Annoyingly I cannot post the db as it something I have been working on for a long-time. I thought it may be when I set a TempVar elsewhere but this is not the case as I'm not getting the prompt when this is done (in another form/ procedure). Any advice on what to look out for?
Is it inevitable that when there are user-declared events/ normal events the code will be in a 'suspended' fashion (do not think so) & the IDE will always prompt this warning or do I have something seriously wrong here? Seems https://www.mztools.com/ will identify the issue but I'd rather save some money & try to figure out where I'm going wrong if possible. Annoyingly I cannot post the db as it something I have been working on for a long-time. I thought it may be when I set a TempVar elsewhere but this is not the case as I'm not getting the prompt when this is done (in another form/ procedure). Any advice on what to look out for?
- Hitting Ctrl & Pause (break appears in top of the IDE window) & it works fine then for that instance of Access. I only need to do this once in that instance of Access & I can open & close the relevant form/ subforms repeatedly without the problem occurring again for that instance of Access - as per https://stackoverflow.com/questions...y-with-message-code-execution-has-been-halted but does not seem a proper fix.
- Some suggest putting DoEvents somewhere in the code to free the App to process events so put this in the Form load event but no joy (nor would I want it to really as this doesn't seem right).
Some advise repairing Microsoft Office as Office can generate a bug apparently; like ghost break-points. Forcing a rebuild of Office's native COM Components. EDIT - did this no joy so problem must be code-related.- I put an Error trap in the Load event & this has shown a type mismatch Error-13; currently investigating where this is & if it bears fruit. I'm not optimistic as if I clear the error I still encounter the issue.
- Decompiles fine with no errors
- Form & relevant sub-forms are not currently open in modal view/ acDialog awaiting user-response. I do have buttons/ procedures to open some in acDialog but these have not been executed in the open event...
- Compact & Repair done
Last edited: