ActiveX cannot create object component -HelpPlease

  • Thread starter Thread starter MD
  • Start date Start date
M

MD

Hi,

I tried to open an Access application that I developed
moths ago but I keep getting the error while trying to
link the front-end to the back-end using link table
manager. Also, I keep getting missing references error
and the ActiveX Control cannot create object control
components.

I have checked the startup, its pointing to the
switchboard and VB error in the following code for the
switch board and the set dbs is highlighted:

Set dbs = CurrentDb()
strSQL = "SELECT * FROM [Switchboard Items]"
strSQL = strSQL & " WHERE [ItemNumber] > 0 AND
[SwitchboardID]=" & Me![SwitchboardID]
strSQL = strSQL & " ORDER BY [ItemNumber];"
Set rst = dbs.OpenRecordset(strSQL)


What refrences must be loaded? and why the subject error
keep comming up? I have not worked for ober six months
and have forgotten many thins. Your help is greatly
appreciated.

Regards,

MD
 
HI Scott,

I don't have any refrences marked "Missing". when I open
the database it asks me for my password and then it load
it by opening the VB editor with the following error:

Compile Error
Error loading DLL

And:
Set dbs = CurrentDb()

Is highlighted.

Here is the declaration:

Private Sub FillOptions()
' Fill in the options for this switchboard page.

' The number of buttons on the form.

Dim dbs As Database
Dim rst As Recordset
Dim strSQL As String
Dim intOption As Integer
THis is the routiong for openinh the switchboard items.
It should be noted that, this has been a working
application. My users are using it but two months ago I
made some changes and I don't want to loss them, After
the changes was made, it was still working but now that I
want to load it on the network I cannot ioen it on my own
machin. Again, the changes were not done on the
switchboard or its items. I tried to reload Office on my
machine again to see if it resolve this issue but no
change! This whole thing happen after I joined my machine
into a new domain and I logged into the domain but not
the machine, If it has anytings to do with it!

thanks,

MD
-----Original Message-----
The first thing to do is check your references. Open the db, then open the
VB Editor, go to Tools - References, then check to see if anything is
labeled MISSING. If it is, note the name, uncheck it, close the dialog, then
reopen the References and recheck that reference. If that doesn't fix it,
post back with your specific error message, including err number, and we'll
try to help.

MD said:
Hi,

I tried to open an Access application that I developed
moths ago but I keep getting the error while trying to
link the front-end to the back-end using link table
manager. Also, I keep getting missing references error
and the ActiveX Control cannot create object control
components.

I have checked the startup, its pointing to the
switchboard and VB error in the following code for the
switch board and the set dbs is highlighted:

Set dbs = CurrentDb()
strSQL = "SELECT * FROM [Switchboard Items]"
strSQL = strSQL & " WHERE [ItemNumber] > 0 AND
[SwitchboardID]=" & Me![SwitchboardID]
strSQL = strSQL & " ORDER BY [ItemNumber];"
Set rst = dbs.OpenRecordset(strSQL)


What refrences must be loaded? and why the subject error
keep comming up? I have not worked for ober six months
and have forgotten many thins. Your help is greatly
appreciated.

Regards,

MD
Click to expand...


.
Click to expand...
 
Back
Top