B Bill Mosca, MS Access MVP Jan 18, 2007 #2 Look in Tools/Startup. I bet the switchboard is still listed as the startup form.
K keri Jan 18, 2007 #3 Thanks. Any idea how I can fix my error or what may be causing it - On startup (with switchboard) I get the error Run time error 429 ActiveX component can't create object. If I debug - the first line of this code is highlighted. Set con = Application.CurrentProject.Connection stSql = "SELECT * FROM [Switchboard Items]" stSql = stSql & " WHERE [ItemNumber] > 0 AND [SwitchboardID]=" & Me![SwitchboardID] stSql = stSql & " ORDER BY [ItemNumber];" Set rs = CreateObject("ADODB.Recordset") rs.Open stSql, con, 1 ' 1 = adOpenKeyset
Thanks. Any idea how I can fix my error or what may be causing it - On startup (with switchboard) I get the error Run time error 429 ActiveX component can't create object. If I debug - the first line of this code is highlighted. Set con = Application.CurrentProject.Connection stSql = "SELECT * FROM [Switchboard Items]" stSql = stSql & " WHERE [ItemNumber] > 0 AND [SwitchboardID]=" & Me![SwitchboardID] stSql = stSql & " ORDER BY [ItemNumber];" Set rs = CreateObject("ADODB.Recordset") rs.Open stSql, con, 1 ' 1 = adOpenKeyset
V Van T. Dinh Jan 19, 2007 #4 Check the References collection of your database to ensure that the Library "Microsoft ActiveX Data Object 2.X Library" is included. Also check other References and make sure none is marked as "MISSING". Have you modified the code in the Swichboard Form in anyway?
Check the References collection of your database to ensure that the Library "Microsoft ActiveX Data Object 2.X Library" is included. Also check other References and make sure none is marked as "MISSING". Have you modified the code in the Swichboard Form in anyway?
