Command Button Problems

  • Thread starter Thread starter TMSpurr
  • Start date Start date
T

TMSpurr

Please refer to original post of 9/2 at 5:54 pm. Having
problems with my on-click event. Tried to follow some
advise, but what everything boils down to is I get error
message "The Visual Basic for Apps project in the database
is corrupt". Tried some advise from Allen as well and
seem to get error message after error message, one of them
on the "On Compile" was "error accessing the file.
Network communication may have been lost". These seem
like general error messages. Please point me somewhere.
BTW, I HATE Access 2000. Never had problems like this in
97. Thanks for your help in advance. If you have any
questions, I'll repost an answer. Thanks. Theresa
 
Okay, looked up the first error msg about the VB for Apps
being corrupt in MS website. Found that it's a known
problem. Did the fix, created a new db, exported all
tables, queries and forms to the new db. Everything
seemed okay. Started to create the same form and when I
created my command button, got the message "Error
accessing file. Network connection may have been lost".
What could this be? What is this C R A P? Please help.
 
Okay, looked up the first error msg about the VB for Apps
being corrupt in MS website. Found that it's a known
problem. Did the fix, created a new db, exported all
tables, queries and forms to the new db. Everything
seemed okay. Started to create the same form and when I
created my command button, got the message "Error
accessing file. Network connection may have been lost".
What could this be? What is this C R A P? Please help.
Click to expand...

Did you happen to look at this KB article?

http://support.microsoft.com/default.aspx?scid=kb;[LN];304548

*If* that bug is what has bitten you -- read it carefully and check to
make sure -- then Office 2000 SP3 fixes the bug, but unfortunately that
won't repair your corrupted database. You'll have to resort to a
backup, or else try importing all objects to a new database -- some
objects probably won't import, and you'll have to recreate them from
scratch. When you do import the objects, unless you've applied the
service pack, it is *crucial* that you compile and save the project
before closing the database.
 
Back
Top