C
cory
Hi,
Sorry if this message appears more than once my ISP servers seem to be
having problems.
I am trying to create the "Time and Billing" database that comes with Access
2000. I am using the wizard for this. The problem is here it says it cant
create Active X object it seems for the switchboard: (The debug shows the
problem in the "Set con...." line)
' 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
Not sure why this is happening.....this database works on my laptop but not
my desktop. the database will create itself but I
cant get the switchboard to work.
Thaks for any help.
Cory
Sorry if this message appears more than once my ISP servers seem to be
having problems.
I am trying to create the "Time and Billing" database that comes with Access
2000. I am using the wizard for this. The problem is here it says it cant
create Active X object it seems for the switchboard: (The debug shows the
problem in the "Set con...." line)
' 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
Not sure why this is happening.....this database works on my laptop but not
my desktop. the database will create itself but I
cant get the switchboard to work.
Thaks for any help.
Cory