Doyce – Is the database file in a trusted location? If it isn't, the VBA code will not run. Seeing how Switchboards are code-driven, I'm betting the file isn't in a trusted location. You can also forgo the blocked VBA by going to the trust center> macro security and setting it to the lowest level.
Regards,
Bill Mosca,
Founder, MS_Access_Professionals
MS Access MVP 2006-2016
That'll do IT http://thatlldoit.com
My Nothing-to-do-with-Access blog
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, March 06, 2018 2:11 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Switchboard trouble on 1 PC
Hello friends,
Access 2016. I have a split database that will not run the switchboard on 1 laptop. It runs on several other PCs with no problems. I have other split databases where the switchboard runs fine on this laptop. When the switchboard opens, it only shows 1 button with no descriptions. I suspected corruption so I created a new db and imported all the objects. No joy. When I try to run the accdb instead of the accde I get a runtime error 429, ActiveX component can't create object. When I click debug I get a highlighted line "Set rs = CreateObject (ADODB.Recordset"). I"ve checked the references. They match. I've run Office repair. I've registered DAO360..dll. I'm not sure what else to try.
Doyce Winberry
Posted by: "Bill Mosca" <wrmosca@comcast.net>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar