N
NAS
Whenever I try to open a switchboard I get the following error:
Run-time error '-2147221164 (80040154)':
Class not registered
I have the option to end or debug and when I click debug it highlights the
last line in this code:
' Open the table of Switchboard Items, and find
' the first item for this Switchboard Page.
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 <--this line here
This is causing a major work stoppage in my office and any help in this
matter would be greatly appreciated.
Run-time error '-2147221164 (80040154)':
Class not registered
I have the option to end or debug and when I click debug it highlights the
last line in this code:
' Open the table of Switchboard Items, and find
' the first item for this Switchboard Page.
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 <--this line here
This is causing a major work stoppage in my office and any help in this
matter would be greatly appreciated.