Simple Code Doesn't Work in a Converted DB

[Yisroel Markov]

Greetings,

I have converted an Access 97 database with quite a bit of code in it
to Access 2000. After fixing a few data types (old database contained
statements like "Dim DB as Database" and "Dim RS as RecordSet," and
A2K choked on them), everything runs, except for one thing: one of the
forms has code attached to BeforeInsert property. When I begin typing
in that form, execution breaks *at the Private Sub Form_BeforeInsert*
line* with the "Can't find object or library" message. It doesn't even
get into the code - it's like A2K doesn't know what "Private Sub
Form_BeforeInsert(Cancel as Integer)" means.

Any ideas as to what could be wrong? Thanks!

[Phil Stanton]

You need a reference to the Microsoft DAO 3.6 Object Library

See Tools ->References

Best to move the position somewhere about line no 4 otherwise sometimes it
will not compile
Phil
"Yisroel Markov" <ey*******@iname.com> wrote in message
news:2f**************************@posting.google.c om...

Greetings,

I have converted an Access 97 database with quite a bit of code in it
to Access 2000. After fixing a few data types (old database contained
statements like "Dim DB as Database" and "Dim RS as RecordSet," and
A2K choked on them), everything runs, except for one thing: one of the
forms has code attached to BeforeInsert property. When I begin typing
in that form, execution breaks *at the Private Sub Form_BeforeInsert*
line* with the "Can't find object or library" message. It doesn't even
get into the code - it's like A2K doesn't know what "Private Sub
Form_BeforeInsert(Cancel as Integer)" means.

Any ideas as to what could be wrong? Thanks!

[Alan J. Weiner]

It's hard to diagnose blind. If you want to foward me the code, I'd
be happy to take a look at it...

ey*******@iname.com (Yisroel Markov) wrote in message news:<2f**************************@posting.google. com>...

Greetings,

I have converted an Access 97 database with quite a bit of code in it
to Access 2000. After fixing a few data types (old database contained
statements like "Dim DB as Database" and "Dim RS as RecordSet," and
A2K choked on them), everything runs, except for one thing: one of the
forms has code attached to BeforeInsert property. When I begin typing
in that form, execution breaks *at the Private Sub Form_BeforeInsert*
line* with the "Can't find object or library" message. It doesn't even
get into the code - it's like A2K doesn't know what "Private Sub
Form_BeforeInsert(Cancel as Integer)" means.

Any ideas as to what could be wrong? Thanks!

[Yisroel Markov]

"Phil Stanton" <ph**@stantonfamily.co.uk> wrote in message news:<3f*********************@mercury.nildram.net> ...

You need a reference to the Microsoft DAO 3.6 Object Library

See Tools ->References

Best to move the position somewhere about line no 4 otherwise sometimes it
will not compile
Thank you very much - this worked!

(I had to un-check the reference to Microsoft DAO 2.5/2.5
Compatibility Library (Program Files\Common Files\Microsoft
Shared\DAO\Dao2535.tlb), otherwise it gave me the "Name conflicts with
existing module, project, or library" message. I hope this will not
screw up something else...)

Yisroel

P.S. Alan, thanks for responding. It seems to me that the "Can't find
object or library" error is not ever likely to be related to code
itself.
Phil
"Yisroel Markov" <ey*******@iname.com> wrote in message
news:2f**************************@posting.google.c om...

Greetings,

I have converted an Access 97 database with quite a bit of code in it
to Access 2000. After fixing a few data types (old database contained
statements like "Dim DB as Database" and "Dim RS as RecordSet," and
A2K choked on them), everything runs, except for one thing: one of the
forms has code attached to BeforeInsert property. When I begin typing
in that form, execution breaks *at the Private Sub Form_BeforeInsert*
line* with the "Can't find object or library" message. It doesn't even
get into the code - it's like A2K doesn't know what "Private Sub
Form_BeforeInsert(Cancel as Integer)" means.

Any ideas as to what could be wrong? Thanks!