Reference to Library not working

  • Thread starter Thread starter Liz
  • Start date Start date
L

Liz

Hi,

I really, really hope someone can help me. I have been
working on this problem for days and days, etc.

First off please know the following:

I have created a database. I am not a programmer; I am a
researcher. I have taught myself some (or others have
taught me) through these wonderful newsgroups.

Here is my problem. I am trying to connect my offender's
ID (primary key in main table) with MainID (a field in
many other tables). I have established relationships,
careted forms, etc. When you open the main form, it has
some tabbed pages. AT the top of details are spaces for
text boxes: Last Name, First Name, ID, Criminal Case
Number. All these pages have same ofender. On the last
page, I want to be able to click some buttons that will
link me to a separate group of pages where the probation
dept can add info on supervision of offender.

Here is the problem: when I try to connect the ID by
using a filter ( [ID]=Forms![frm Rolo]!ID ) I get an
error. I go to VBA Editor and loko at code. I select ID
in the code line (and coincdentally it has a cursor over
that shows the correct ID) that says that "cannot jump
to "ID" because the library Dom Vio is in ...(the name of
where my database is) and is not referenced in the
library." Huh????? It is obvious there and it kows it is
there! I have read up on this and tortured myself through
hours of fruitless coding. I have used a Public Declare
statement in its own module.

Can anyone please tell me what I am supposed to do? If I
have completely screwed this up, I am going to find an
alternative using a search form, but I am trying to
decrease data entry error. I am running Access 2002, but
in an Access 2000 file format.

THANKS!!!! I hope this is understandable!

Liz
 
Hi Liz,

Open any module in Design View, then select Tools > References. Are any
libraries marked as MISSING? If so, then uncheck them (i.e. clear the
check boxes). Post back if this doesn't take care of the problem.

hth,

LeAnne
 
Thanks for responding, LeAnne. Unfortunately, there is
nothing that says "MISSING" I know my library is missing,
but it's not listed there. When I have tried to browse to
my database and select it, it won't let me b/c it says it
is already being used (or is circular or something)...

-----Original Message-----
Hi Liz,

Open any module in Design View, then select Tools > References. Are any
libraries marked as MISSING? If so, then uncheck them (i.e. clear the
check boxes). Post back if this doesn't take care of the problem.

hth,

LeAnne
Hi,

I really, really hope someone can help me. I have been
working on this problem for days and days, etc.

First off please know the following:

I have created a database. I am not a programmer; I am a
researcher. I have taught myself some (or others have
taught me) through these wonderful newsgroups.

Here is my problem. I am trying to connect my offender's
ID (primary key in main table) with MainID (a field in
many other tables). I have established relationships,
careted forms, etc. When you open the main form, it has
some tabbed pages. AT the top of details are spaces for
text boxes: Last Name, First Name, ID, Criminal Case
Number. All these pages have same ofender. On the last
page, I want to be able to click some buttons that will
link me to a separate group of pages where the probation
dept can add info on supervision of offender.

Here is the problem: when I try to connect the ID by
using a filter ( [ID]=Forms![frm Rolo]!ID ) I get an
error. I go to VBA Editor and loko at code. I select ID
in the code line (and coincdentally it has a cursor over
that shows the correct ID) that says that "cannot jump
to "ID" because the library Dom Vio is in ...(the name of
where my database is) and is not referenced in the
library." Huh????? It is obvious there and it kows it is
there! I have read up on this and tortured myself through
hours of fruitless coding. I have used a Public Declare
statement in its own module.

Can anyone please tell me what I am supposed to do? If I
have completely screwed this up, I am going to find an
alternative using a search form, but I am trying to
decrease data entry error. I am running Access 2002, but
in an Access 2000 file format.

THANKS!!!! I hope this is understandable!

Liz
Click to expand...
.
Click to expand...
 
Liz,

Please post the exact wording of the error message.

LeAnne
Thanks for responding, LeAnne. Unfortunately, there is
nothing that says "MISSING" I know my library is missing,
but it's not listed there. When I have tried to browse to
my database and select it, it won't let me b/c it says it
is already being used (or is circular or something)...
-----Original Message-----
Hi Liz,

Open any module in Design View, then select Tools > References. Are any
libraries marked as MISSING? If so, then uncheck them (i.e. clear the
check boxes). Post back if this doesn't take care of the problem.

hth,

LeAnne
Hi,

I really, really hope someone can help me. I have been
working on this problem for days and days, etc.

First off please know the following:

I have created a database. I am not a programmer; I am a
researcher. I have taught myself some (or others have
taught me) through these wonderful newsgroups.

Here is my problem. I am trying to connect my offender's
ID (primary key in main table) with MainID (a field in
many other tables). I have established relationships,
careted forms, etc. When you open the main form, it has
some tabbed pages. AT the top of details are spaces for
text boxes: Last Name, First Name, ID, Criminal Case
Number. All these pages have same ofender. On the last
page, I want to be able to click some buttons that will
link me to a separate group of pages where the probation
dept can add info on supervision of offender.

Here is the problem: when I try to connect the ID by
using a filter ( [ID]=Forms![frm Rolo]!ID ) I get an
error. I go to VBA Editor and loko at code. I select ID
in the code line (and coincdentally it has a cursor over
that shows the correct ID) that says that "cannot jump
to "ID" because the library Dom Vio is in ...(the name of
where my database is) and is not referenced in the
library." Huh????? It is obvious there and it kows it is
there! I have read up on this and tortured myself through
hours of fruitless coding. I have used a Public Declare
statement in its own module.

Can anyone please tell me what I am supposed to do? If I
have completely screwed this up, I am going to find an
alternative using a search form, but I am trying to
decrease data entry error. I am running Access 2002, but
in an Access 2000 file format.

THANKS!!!! I hope this is understandable!

Liz
Click to expand...
.
Click to expand...
Click to expand...
 
The whole message in VBA says, "Cannot jump to 'ID'
because it is in the library 'C:\Documents and
setting.....\Domestic Violence Court Database.mdb' which
is not currently referenced' Keep ni mind that I am
working with the database ti refers to.

However, when I put my mouse over [ID] in the code, it
says "ID="(whatever the number should be).

Thanks for any help you can provide! I really appreciate
it!
-----Original Message-----
Liz,

Please post the exact wording of the error message.

LeAnne
Thanks for responding, LeAnne. Unfortunately, there is
nothing that says "MISSING" I know my library is missing,
but it's not listed there. When I have tried to browse to
my database and select it, it won't let me b/c it says it
is already being used (or is circular or something)...
-----Original Message-----
Hi Liz,

Open any module in Design View, then select Tools > References. Are any
libraries marked as MISSING? If so, then uncheck them (i.e. clear the
check boxes). Post back if this doesn't take care of
Click to expand...
the
problem.
hth,

LeAnne

Liz wrote:

Hi,

I really, really hope someone can help me. I have been
working on this problem for days and days, etc.

First off please know the following:

I have created a database. I am not a programmer; I
Click to expand...
am
a
researcher. I have taught myself some (or others have
taught me) through these wonderful newsgroups.

Here is my problem. I am trying to connect my offender's
ID (primary key in main table) with MainID (a field in
many other tables). I have established relationships,
careted forms, etc. When you open the main form, it has
some tabbed pages. AT the top of details are spaces for
text boxes: Last Name, First Name, ID, Criminal Case
Number. All these pages have same ofender. On the last
page, I want to be able to click some buttons that will
link me to a separate group of pages where the probation
dept can add info on supervision of offender.

Here is the problem: when I try to connect the ID by
using a filter ( [ID]=Forms![frm Rolo]!ID ) I get an
error. I go to VBA Editor and loko at code. I
Click to expand...
select
ID
in the code line (and coincdentally it has a cursor over
that shows the correct ID) that says that "cannot jump
to "ID" because the library Dom Vio is in ...(the
Click to expand...
name
of
where my database is) and is not referenced in the
library." Huh????? It is obvious there and it kows
Click to expand...
it
is
there! I have read up on this and tortured myself through
hours of fruitless coding. I have used a Public Declare
statement in its own module.

Can anyone please tell me what I am supposed to do?
Click to expand...
If
I
have completely screwed this up, I am going to find an
alternative using a search form, but I am trying to
decrease data entry error. I am running Access 2002, but
in an Access 2000 file format.

THANKS!!!! I hope this is understandable!

Liz
.
Click to expand...
Click to expand...
.
Click to expand...
 
Liz,

Some links from http:/support.microsoft.com...


General info about reference issues when distributing database files:

http://support.microsoft.com/default.aspx?scid=kb;en-us;310803&Product=acc


Specific info about broken references when importing modules from older
versions of Access to A2K2:

http://support.microsoft.com/default.aspx?scid=kb;en-us;287413&Product=acc


Hope these help,

LeAnne

The whole message in VBA says, "Cannot jump to 'ID'
because it is in the library 'C:\Documents and
setting.....\Domestic Violence Court Database.mdb' which
is not currently referenced' Keep ni mind that I am
working with the database ti refers to.

However, when I put my mouse over [ID] in the code, it
says "ID="(whatever the number should be).

Thanks for any help you can provide! I really appreciate
it!
-----Original Message-----
Liz,

Please post the exact wording of the error message.

LeAnne
Thanks for responding, LeAnne. Unfortunately, there is
nothing that says "MISSING" I know my library is missing,
but it's not listed there. When I have tried to browse to
my database and select it, it won't let me b/c it says it
is already being used (or is circular or something)...

-----Original Message-----
Hi Liz,

Open any module in Design View, then select Tools >
References. Are any
libraries marked as MISSING? If so, then uncheck them
(i.e. clear the
check boxes). Post back if this doesn't take care of the
problem.

hth,

LeAnne

Liz wrote:

Hi,

I really, really hope someone can help me. I have been
working on this problem for days and days, etc.

First off please know the following:

I have created a database. I am not a programmer; I am
a
researcher. I have taught myself some (or others have
taught me) through these wonderful newsgroups.

Here is my problem. I am trying to connect my
offender's
ID (primary key in main table) with MainID (a field in
many other tables). I have established relationships,
careted forms, etc. When you open the main form, it has
some tabbed pages. AT the top of details are spaces for
text boxes: Last Name, First Name, ID, Criminal Case
Number. All these pages have same ofender. On the last
page, I want to be able to click some buttons that will
link me to a separate group of pages where the probation
dept can add info on supervision of offender.

Here is the problem: when I try to connect the ID by
using a filter ( [ID]=Forms![frm Rolo]!ID ) I get an
error. I go to VBA Editor and loko at code. I select
ID
in the code line (and coincdentally it has a cursor over
that shows the correct ID) that says that "cannot jump
to "ID" because the library Dom Vio is in ...(the name
of
where my database is) and is not referenced in the
library." Huh????? It is obvious there and it kows it
is
there! I have read up on this and tortured myself
through
hours of fruitless coding. I have used a Public Declare
statement in its own module.

Can anyone please tell me what I am supposed to do? If
I
have completely screwed this up, I am going to find an
alternative using a search form, but I am trying to
decrease data entry error. I am running Access 2002,
but
in an Access 2000 file format.

THANKS!!!! I hope this is understandable!

Liz
.
Click to expand...
.
Click to expand...
Click to expand...
 
Back
Top