Tuesday, August 26, 2008

Access 2007 Developer Extensions Not Showing Up Anymore

I spent a couple hours uninstalling and reinstalling to try to fix this problem. Maybe repeating this section from (http://granite.ab.ca/access/developeredition2007faq.htm) will stop you from doing the same.

Q: I installed the developer extensions but can't find the Developer option in the Office button.

From a fellow Access MVP - The Add-in will disable itself if you switch between Access versions. So if he has more than the 2007 edition installed and he opened the earlier edition after the installation he will need to manually re-enable it through the Access Options dialog (Office Button--Access Options--Add-ins--Manage: COM Add-ins--Go...--Check Microsoft Office Access Developer Extensions COM Add-in--Ok--Close Access Options and look under the Office button again).

Friday, August 8, 2008

Access 2003 Combobox and Listbox Problems

If you are trying to track down why a value is not showing in a combobox or listbox after applying MS Access 2003 Service Pack 3 then you may want to read and apply the hotfix 945674.

http://support.microsoft.com/kb/945674/

945280 (http://support.microsoft.com/kb/945280/) Combo box controls and list box controls display no value or incorrect values in Access 2003 after you install Office 2003 Service Pack 3

943967 (http://support.microsoft.com/kb/943967/) After you install Office 2003 SP3, you encounter various problems in an Access project when you work with a Bit data type column in a linked SQL Server table