I have a runtime error in one of my programs '2147352571 9800200005)':

Question

Well i'm trying to open a userform in order to alter an employees status and when i click on the button to open the userform that is used to make this happen i get a runtime error.

Answer 1

The runtime error you're encountering (error code '2147352571 9800200005') may be related to issues with the UserForm you are trying to open. Here are a few potential causes and solutions:

1. Form Compatibility: Ensure that the UserForm you are trying to load is compatible with the version of Visual Basic for Applications (VBA) you are using. If it was created in an earlier version of Visual Basic, it might not be supported. You may need to redesign the form using the UserForm tools within VBA.
2. Unexpected Error: This error can also occur due to an unexpected issue in the system. Try restarting your computer to see if that resolves the problem.
3. Interaction Between Components: If you are using compiled components alongside components running in the IDE, this could lead to compatibility issues. Make sure that all components are either compiled or running in the IDE to avoid this error.

If the problem persists, consider checking the specific circumstances under which the error occurs and consult Microsoft Product Support Services for further assistance.