Access 2000: Bad event procedures - TechRepublic
General discussion
March 19, 2002 at 04:40 AM
ccellist

Access 2000: Bad event procedures

by ccellist . Updated 24 years, 3 months ago

Here’s the type of error that really makes me hate Access 2000 (or rather my knowledge of Access 2000): I’m working on a database that keeps track of computers that are built along with their serial numbers, components, who they were sold to etc. Since I am modifying an existing database, I made a copy of the original and started working on it. Everything was working just fine and dandy, and all my procedures worked just fine. However, when I tried to copy the newly finished form (with all its related code) into the original database, none of the form events (on Load, on Click, etc) would work. I now receive errors that say, “The expression On Click [or any other event] you entered as the event property setting produced the following error: User-type not defined”. This puzzles me because all the VB code is there, exactly as it is in the previous copy of the database (where it worked seemingly flawlessly). I also made sure to copy all relevant module files into the original database soall the code would work correctly.

Any ideas anyone? Thanks.

This discussion is locked

All Comments