Attention Scott McDaniel Please-everyone else feel free to respond please.

[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.

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

 

[Douglas J. Steele]

Your code is using DAO, so you definitely need a reference to Microsoft DAO
3.6 Object Library.

I can't think of any reason how you could "lose" that reference though. The
worst that should happen is that you'll get a missing reference if
something's wrong (unless someone went in and explicitly deleted the
reference, or you created a new database and imported everything from your
old database)

--
Doug Steele, Microsoft Access MVP

Thanks. I did all you said but i'm still having the same
poblem opening my application.

The only thing that I think I had before and I don't have
it now is: Microsoft DAO 3.6 Object Library
This one is not even listed to be selected.

I also visited the web sites recommanded by you, and read
a lot of useful information but none contributed to a
resolution to my problem. It has puzzeled me. The only
thing that has changed is that in the past, I was
developing the application on my machine and then load it
on a workgroup computer at work. Now, I'm connect to an
AD Domian based LAN. My application, previously loaded on
the user machine is still working fine, I made some
changes to the same on my machin but I cannot open it
anymore. Please help resolving this problem.

Regards,

MD

-----Original Message-----
My standard response for References problems:

Your references are probably messed up.

This can be caused by differences in either the location or file version of
certain files between the machine where the application was developed, and
where it's being run (or the file missing completely from the target
machine). Such differences are common when new software is installed.

On the machine(s) where it's not working, open any code module (or open the
Debug Window, using Ctrl-G, provided you haven't selected the "keep debug
window on top" option). Select Tools | References from the menu bar. Examine
all of the selected references.

If any of the selected references have "MISSING:" in front of them, unselect
them, and back out of the dialog. If you really need the reference(s) you
just unselected (you can tell by doing a Compile All Modules), go back in
and reselect them.

If none have "MISSING:", select an additional reference at random, back out
of the dialog, then go back in and unselect the reference you just added. If
that doesn't solve the problem, try to unselect as many of the selected
references as you can (Access may not let you unselect them all), back out
of the dialog, then go back in and reselect the references you just
unselected. (NOTE: write down what the references are before you delete
them, because they'll be in a different order when you go back in)

For far more than you could ever want to know about this problem, check out
http://members.rogers.com/douglas.j.steele/AccessReferenc eErrors.html



--
Doug Steele, Microsoft Access MVP

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.

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

.

 

[MD]

How can I get that microsoft DAO Object Labrary back?

I see that there is an Add option but brows to where?

Thx,

MD

-----Original Message-----
Your code is using DAO, so you definitely need a reference to Microsoft DAO
3.6 Object Library.

I can't think of any reason how you could "lose" that reference though. The
worst that should happen is that you'll get a missing reference if
something's wrong (unless someone went in and explicitly deleted the
reference, or you created a new database and imported everything from your
old database)

--
Doug Steele, Microsoft Access MVP

Thanks. I did all you said but i'm still having the same
poblem opening my application.

The only thing that I think I had before and I don't have
it now is: Microsoft DAO 3.6 Object Library
This one is not even listed to be selected.

I also visited the web sites recommanded by you, and read
a lot of useful information but none contributed to a
resolution to my problem. It has puzzeled me. The only
thing that has changed is that in the past, I was
developing the application on my machine and then load it
on a workgroup computer at work. Now, I'm connect to an
AD Domian based LAN. My application, previously loaded on
the user machine is still working fine, I made some
changes to the same on my machin but I cannot open it
anymore. Please help resolving this problem.

Regards,

MD

-----Original Message-----
My standard response for References problems:

Your references are probably messed up.

This can be caused by differences in either the

location
or file version of

certain files between the machine where the

application
was developed, and

where it's being run (or the file missing completely from the target
machine). Such differences are common when new

software
is installed.

On the machine(s) where it's not working, open any

code
module (or open the

Debug Window, using Ctrl-G, provided you haven't selected the "keep debug
window on top" option). Select Tools | References from the menu bar. Examine
all of the selected references.

If any of the selected references have "MISSING:" in front of them, unselect
them, and back out of the dialog. If you really need

the
reference(s) you

just unselected (you can tell by doing a Compile All Modules), go back in
and reselect them.

If none have "MISSING:", select an additional

reference
at random, back out

of the dialog, then go back in and unselect the reference you just added. If
that doesn't solve the problem, try to unselect as

many
of the selected

references as you can (Access may not let you unselect them all), back out
of the dialog, then go back in and reselect the references you just
unselected. (NOTE: write down what the references are before you delete
them, because they'll be in a different order when you go back in)

For far more than you could ever want to know about

this
problem, check out
http://members.rogers.com/douglas.j.steele/AccessReferenc

eErrors.html



--
Doug Steele, Microsoft Access MVP



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.

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



.

.

 

[Douglas J. Steele]

With any code module open, select Tools | References from the menu bar,
scroll through the list of available references until you find the one for
Microsoft DAO 3.6 Object Library, and select it. If you're not going to be
using ADO, uncheck the reference to Microsoft ActiveX Data Objects 2.1
Library

If you have both references, you'll find that you'll need to "disambiguate"
certain declarations, because objects with the same names exist in the 2
models. For example, to ensure that you get a DAO recordset, you'll need to
use Dim rsCurr as DAO.Recordset (to guarantee an ADO recordset, you'd use
Dim rsCurr As ADODB.Recordset)

The list of objects with the same names in the 2 models is Connection,
Error, Errors, Field, Fields, Parameter, Parameters, Property, Properties
and Recordset


--
Doug Steele, Microsoft Access MVP

How can I get that microsoft DAO Object Labrary back?

I see that there is an Add option but brows to where?

Thx,

MD

-----Original Message-----
Your code is using DAO, so you definitely need a reference to Microsoft DAO
3.6 Object Library.

I can't think of any reason how you could "lose" that reference though. The
worst that should happen is that you'll get a missing reference if
something's wrong (unless someone went in and explicitly deleted the
reference, or you created a new database and imported everything from your
old database)

--
Doug Steele, Microsoft Access MVP

Thanks. I did all you said but i'm still having the same
poblem opening my application.

The only thing that I think I had before and I don't have
it now is: Microsoft DAO 3.6 Object Library
This one is not even listed to be selected.

I also visited the web sites recommanded by you, and read
a lot of useful information but none contributed to a
resolution to my problem. It has puzzeled me. The only
thing that has changed is that in the past, I was
developing the application on my machine and then load it
on a workgroup computer at work. Now, I'm connect to an
AD Domian based LAN. My application, previously loaded on
the user machine is still working fine, I made some
changes to the same on my machin but I cannot open it
anymore. Please help resolving this problem.

Regards,

MD
-----Original Message-----
My standard response for References problems:

Your references are probably messed up.

This can be caused by differences in either the location
or file version of
certain files between the machine where the application
was developed, and
where it's being run (or the file missing completely
from the target
machine). Such differences are common when new software
is installed.

On the machine(s) where it's not working, open any code
module (or open the
Debug Window, using Ctrl-G, provided you haven't
selected the "keep debug
window on top" option). Select Tools | References from
the menu bar. Examine
all of the selected references.

If any of the selected references have "MISSING:" in
front of them, unselect
them, and back out of the dialog. If you really need the
reference(s) you
just unselected (you can tell by doing a Compile All
Modules), go back in
and reselect them.

If none have "MISSING:", select an additional reference
at random, back out
of the dialog, then go back in and unselect the
reference you just added. If
that doesn't solve the problem, try to unselect as many
of the selected
references as you can (Access may not let you unselect
them all), back out
of the dialog, then go back in and reselect the
references you just
unselected. (NOTE: write down what the references are
before you delete
them, because they'll be in a different order when you
go back in)

For far more than you could ever want to know about this
problem, check out
http://members.rogers.com/douglas.j.steele/AccessReferenc
eErrors.html



--
Doug Steele, Microsoft Access MVP



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.

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



.

.