I have a simple Access contacts data base that I have used for years. It began as an Access 97 Contacts Template and I have made many additions since then. It uses a switchboard to control contact searches and report queries. Searches are driven by 2 simple combo boxes tied to search/match queries; one for contacts and one for client names.
The program was begun with Windows 2000 / Access 97 and was eventually upgraded to Access 2002 several years ago; everything working fine.
Three weeks ago I began using a different laptop with Windows XP and Office 2003 and transferred my database. After this change, when I attempt to search for a contact or a client using either combo box, I now get an error message in a Microsoft Visual Basic message box: Run-time error 429: ActiveX component cant create object. The error message gives me options to End or Debug.
When I start to debug, the code line in yellow is: Me.RecordsetClone.FindFirst [ContactID] = & Me![Combo55].
Steps I have taken:
I sent the database to another computer also with Windows XP and Office 2003 and the data base Combo boxes work as designed.
I uninstalled Office 2003 and reinstalled a totally different copy of Office 2003 no change, still the same error messages.
I uninstalled Office 2003 reinstalled my old Office XP -Access 2002 no change, still the same error messages.
I have registered the DAO350.DLL using regsvr32 "C:\Program Files\Common Files\Microsoft Shared\DAO\DAO350.DLL successfully, as mentioned in another solution on this website no change, still the same error messages.
I have deleted the combo boxes and attempted to rebuild new boxes and get the following Microsoft Access Message Box error message: ActiveX Component cant create object.
Every other part of the database works fine and all the switchboard command buttons work correctly. All queries work and all reports print correctly. My only issue is with the two search combo boxes.
Any suggestions would be appreciated.