Hello,
I hope that this is just 1 problem, and not 2 different ones. I cannot run macros in my Access 2003 VBA project (though users on other machines can), and I cannot run any of the default wizards. I have used this same machine for months for development with no issues, and based on what I've found online, this is likely the result of a MSFT update. However, despite my finding lots of pages/posts about the specific error (see below), I have yet to come across a solution. Many of the forums I've browsed were created years ago, and were left off with someone asking "Did you fix it?" with no response.
So here's the meat of what I've got thus far. The error associated with opening a wizard is as follows:
"Microsoft Access can't find the wizard, or there is a syntax error in the Declarations section of a Visual Basic module. The wizard you need may be missing from the Libraries key of the Microsoft Access section of the Windows Registry. To make sure that the wizard is in the Windws Registry, run Setup to reinstall Microsoft Access, and then compile all Visual Basic modules in the database."
When attempting to (for example) click on a button associated with a coded macro, the database reports that the macro cannot be found and that it is either missing or spelled incorrectly. When I look through the code itself, I can find the entry with no issues. I didn't think there would be an issue here since other users have no problems.
I've found this error from others' posts, some of which are here:
I've also found others online at other sites, but most mirror the same responses.
I've tried each of the following to no avail:
I tried running a repair of the software, both from the main Office setup file as well as the built-in Help->Detect and Repair feature of Access.
I have tried ensuring that modules were compiled, but this did not work. I didn't think this would for a number of reasons. First, this is affecting EVERY DB I try, including a blank default db1.mdb file. Second, other users accessing the same exact file have no issues (on other machines)
I have tried a hotfix download from MSFT (link found on another site, and I didn't save it) that ran successfully, but did not fix the issue.
I do not have any add-ins installed, nor have I ever tried to install or use any. I am not using any special references for the project, and again, see above that other users are working fine.
I have verified that the wizards are available (exist in the appropriate directories). When I run a wizard, even though the error appears, the code editor shows the project (though uneditable) in the project list, so it's not that the file is missing, it's that the code is not running.
Please anyone let me know if they have a working solution to this problem, as I have some coding to do, and borrowing someone else's PC to do so isn't a great option!
Also, if I've been unclear in any part of my explaination, please let me know so I can clarify.
Thanks!
I hope that this is just 1 problem, and not 2 different ones. I cannot run macros in my Access 2003 VBA project (though users on other machines can), and I cannot run any of the default wizards. I have used this same machine for months for development with no issues, and based on what I've found online, this is likely the result of a MSFT update. However, despite my finding lots of pages/posts about the specific error (see below), I have yet to come across a solution. Many of the forums I've browsed were created years ago, and were left off with someone asking "Did you fix it?" with no response.
So here's the meat of what I've got thus far. The error associated with opening a wizard is as follows:
"Microsoft Access can't find the wizard, or there is a syntax error in the Declarations section of a Visual Basic module. The wizard you need may be missing from the Libraries key of the Microsoft Access section of the Windows Registry. To make sure that the wizard is in the Windws Registry, run Setup to reinstall Microsoft Access, and then compile all Visual Basic modules in the database."
When attempting to (for example) click on a button associated with a coded macro, the database reports that the macro cannot be found and that it is either missing or spelled incorrectly. When I look through the code itself, I can find the entry with no issues. I didn't think there would be an issue here since other users have no problems.
I've found this error from others' posts, some of which are here:
I've also found others online at other sites, but most mirror the same responses.
I've tried each of the following to no avail:
I tried running a repair of the software, both from the main Office setup file as well as the built-in Help->Detect and Repair feature of Access.
I have tried ensuring that modules were compiled, but this did not work. I didn't think this would for a number of reasons. First, this is affecting EVERY DB I try, including a blank default db1.mdb file. Second, other users accessing the same exact file have no issues (on other machines)
I have tried a hotfix download from MSFT (link found on another site, and I didn't save it) that ran successfully, but did not fix the issue.
I do not have any add-ins installed, nor have I ever tried to install or use any. I am not using any special references for the project, and again, see above that other users are working fine.
I have verified that the wizards are available (exist in the appropriate directories). When I run a wizard, even though the error appears, the code editor shows the project (though uneditable) in the project list, so it's not that the file is missing, it's that the code is not running.
Please anyone let me know if they have a working solution to this problem, as I have some coding to do, and borrowing someone else's PC to do so isn't a great option!
Also, if I've been unclear in any part of my explaination, please let me know so I can clarify.
Thanks!