I am using access 07 and (sorry) I sometimes use the wizards. if I add a button the wizard always makes a macro, on older versions of access it used to be VBA, is there a setting that can be changed to make the wizard perform VBA rather than an embedded macro
Wizards
- Thread starter ddrew
- Start date
I am looking for a solution to the Access 10 wizard problem with the 32-bit version. The error codes vary from syntax error to wizrds not insalled or in a bad state. There are many requests found through Google but I can't find any updated information that is helpful. I have gone through the usual: uninstall/install; renaming the extensions of the wizards to ".old"; doing a repair; deleting VB6 and making sure the "Trusted Location" pointed to is Office 14 and not 12. I can't find anyone who has posted something that works beyond these solutions. Is there any new information to be found?
boblarson
Smeghead
- Local time
- Today, 08:22
- Joined
- Jan 12, 2001
- Messages
- 32,059
Hopefully he figured out an answer, and wasn't needing yours, because the question was asked over a year ago.
boblarson
Smeghead
- Local time
- Today, 08:22
- Joined
- Jan 12, 2001
- Messages
- 32,059
Sorry, but when dealing with errors, it is much easier to diagnose when you can post the exact error message and what you were trying to do just before it occurred (placing a text box on the form, etc.).
Your question is just not specific enough to track down a problem (at least that I can see).
I disagree, but will be more than happy to supply you with the information you ask.
It has been my experience with this type of problem (because this is not the first time this same thing has happened) that there are multiple tasks that produce the same error codes just like the same problem can produce multiple error codes and we are given multiple "solutions" to fix these problems.
With this Access wizard problem once you correct that one thing it opens up everything else. I have had this happen several times and the error must be caused by an update or patch and then eventually it is usually corrected by the same. It is hard to believe that there is not more information available on this topic. What do you do when you had gone through the list of the standard responses and you still don't have a solution? Most responses come from a script and then once the script has been read and the items attempted there is nowhere else to go.
But let's just say I want to create a Macro and I get this error code: (Because it has).
"This feature isn't installed, or has been disabled.
To install this feature, rerun the Microsoft Access or the Microsoft Setup program, or you're using a third-party add-in, reinstall it. To re-enable this wizard, click the File tab, and then click Options. Click Add-ins, and then in the Manage list, click Disabled Items, and then Click Go."
Or I want to place a combo box on a form (and I know that I have enabled wizards from the design/more options box) and I get this error code: (Because this too has happened).
"Microsoft Access can't start the wizard, builder, or add-in.
*The library databse containing the wizard, builder, or add-in may not be installed. Point to Add-ins on the Tools menu, and then click Add-in Manager to see if the library is installed.
*The wizard, builder, or add-in code may not be compiled and Microsoft Access can't compile it. There may be a syntax error in the code.
*The key for the add-in in the Windows Registry file may be incorrect.
There has to be someone out there who knows what is causing this problem and can offer the solution."
Thank you.
It has been my experience with this type of problem (because this is not the first time this same thing has happened) that there are multiple tasks that produce the same error codes just like the same problem can produce multiple error codes and we are given multiple "solutions" to fix these problems.
With this Access wizard problem once you correct that one thing it opens up everything else. I have had this happen several times and the error must be caused by an update or patch and then eventually it is usually corrected by the same. It is hard to believe that there is not more information available on this topic. What do you do when you had gone through the list of the standard responses and you still don't have a solution? Most responses come from a script and then once the script has been read and the items attempted there is nowhere else to go.
But let's just say I want to create a Macro and I get this error code: (Because it has).
"This feature isn't installed, or has been disabled.
To install this feature, rerun the Microsoft Access or the Microsoft Setup program, or you're using a third-party add-in, reinstall it. To re-enable this wizard, click the File tab, and then click Options. Click Add-ins, and then in the Manage list, click Disabled Items, and then Click Go."
Or I want to place a combo box on a form (and I know that I have enabled wizards from the design/more options box) and I get this error code: (Because this too has happened).
"Microsoft Access can't start the wizard, builder, or add-in.
*The library databse containing the wizard, builder, or add-in may not be installed. Point to Add-ins on the Tools menu, and then click Add-in Manager to see if the library is installed.
*The wizard, builder, or add-in code may not be compiled and Microsoft Access can't compile it. There may be a syntax error in the code.
*The key for the add-in in the Windows Registry file may be incorrect.
There has to be someone out there who knows what is causing this problem and can offer the solution."
Thank you.
boblarson
Smeghead
- Local time
- Today, 08:22
- Joined
- Jan 12, 2001
- Messages
- 32,059
If you are having this problem and I am not, the key is trying to figure out the difference between your system and my system. So many, many questions need to be asked (and answered) in order to troubleshoot the problem. To just blame it on Access or an update automatically isn't a good path to take because immediately that limits you to what you are looking for. A good troubleshooter looks for any differences between something that is working and something that is not. And, while it may end up as something inside some update or inside Access itself, to just immediately assume so can be extremely disappointing because you may not find the root cause when you could have if you had not assumed something to begin with.
The reason I state this is that not all error messages give you the exact problem. So in order for us to diagnose we need as much information as possible.
That being said, you say this happens when you go to the Macros and click NEW to create a new macro?
Next, you are using Access 2007 and is this on the new accdb file format or the older mdb file format? Also, does it happen on both formats?
If this is an accdb file format, was it an upgraded version from an older mdb file format? If it is upgraded how did you upgrade it (do the save as or import everything into a new accdb file)?
The reason I state this is that not all error messages give you the exact problem. So in order for us to diagnose we need as much information as possible.
That being said, you say this happens when you go to the Macros and click NEW to create a new macro?
Next, you are using Access 2007 and is this on the new accdb file format or the older mdb file format? Also, does it happen on both formats?
If this is an accdb file format, was it an upgraded version from an older mdb file format? If it is upgraded how did you upgrade it (do the save as or import everything into a new accdb file)?
Thank you for responding. I appreciate what it takes to be a good troubleshooter. That being said, I am using Access 2010 from Office 2010 Professional Plus. Truthfully I cannot say that it is an update but I can say that mysteriously it stops working after there have been updates. I also know from reading that some of Microsoft’s MVP’s have note there is a problem between the 64-bit version and SP-1. They are currently working on it and are hopeful for a patch to be released. So far I have not found anyone able to address a very similar problem with the 32-bit version.
No matter what I need to do with my current state of Access, if it involves a wizard it won’t work.
The first error code comes when I attempt to create a combo box for an existing form. Once selecting the button from the menu and draw the place for it I get the following:
“The code contains a syntax error, or a Microsoft Access function you need is not available.
If the syntax is correct, check the Control Wizards subkey or the Libraries key in the Microsoft Access section of the Windows Registry to verify that the entries you need are listed and available.
If the entries are correct, either you must correct the Microsoft Access Utility Add-in, or the file acWzlib or this wizard has been disable. To reenable this wizard, run Microsoft Access or Microsoft Office Setup again to reinstall Microsoft Access. Before you reinstall Microsoft Access, delete the Windows Registry keys for the Microsoft Access Utility Add-in and acWzlib.”
The second error code comes when I attempt to place an Input Mask in a short date field for either an existing table or a new table and might I add I have even created several new databases to get around this. When I click on the ellipsis for the Input Mask I get this:
“Microsoft Access can't start the wizard, builder, or add-in.
*The library database containing the wizard, builder, or add-in may not be installed. Point to Add-ins on the Tools menu, and then click Add-in Manager to see if the library is installed.
*The wizard, builder, or add-in code may not be compiled and Microsoft Access can't compile it. There may be a syntax error in the code.
*The key for the add-in in the Windows Registry file may be incorrect.”
As I have stated, I have attempted repairs; I have uninstalled the Access portion of Office and reinstalled it; I have uninstalled Office completely and reinstalled it; I have made sure the “Trusted Locations” points to the correct location; and I have renamed the extensions to the Add-ins in C:\...Office14\ACCWIZ to .old and allowed the software to repair itself. No matter what I attempt I have not been able to find a solution. This has been my experience and I have found others on other forums with the same question as recently as last week and they are also waiting on a solution. I am open to any suggestion you may give.
No matter what I need to do with my current state of Access, if it involves a wizard it won’t work.
The first error code comes when I attempt to create a combo box for an existing form. Once selecting the button from the menu and draw the place for it I get the following:
“The code contains a syntax error, or a Microsoft Access function you need is not available.
If the syntax is correct, check the Control Wizards subkey or the Libraries key in the Microsoft Access section of the Windows Registry to verify that the entries you need are listed and available.
If the entries are correct, either you must correct the Microsoft Access Utility Add-in, or the file acWzlib or this wizard has been disable. To reenable this wizard, run Microsoft Access or Microsoft Office Setup again to reinstall Microsoft Access. Before you reinstall Microsoft Access, delete the Windows Registry keys for the Microsoft Access Utility Add-in and acWzlib.”
The second error code comes when I attempt to place an Input Mask in a short date field for either an existing table or a new table and might I add I have even created several new databases to get around this. When I click on the ellipsis for the Input Mask I get this:
“Microsoft Access can't start the wizard, builder, or add-in.
*The library database containing the wizard, builder, or add-in may not be installed. Point to Add-ins on the Tools menu, and then click Add-in Manager to see if the library is installed.
*The wizard, builder, or add-in code may not be compiled and Microsoft Access can't compile it. There may be a syntax error in the code.
*The key for the add-in in the Windows Registry file may be incorrect.”
As I have stated, I have attempted repairs; I have uninstalled the Access portion of Office and reinstalled it; I have uninstalled Office completely and reinstalled it; I have made sure the “Trusted Locations” points to the correct location; and I have renamed the extensions to the Add-ins in C:\...Office14\ACCWIZ to .old and allowed the software to repair itself. No matter what I attempt I have not been able to find a solution. This has been my experience and I have found others on other forums with the same question as recently as last week and they are also waiting on a solution. I am open to any suggestion you may give.
