Help - problem with access more info

[George Applegate]

Good morning, I wonder if anyone can offer some suggestions of what
might be going on here.

I have an access db/program that has a from that is filled in, and
that form has some sub-forms. This has been working fine for months.
All of a sudden, when we go to type into one of the sub-forms (any of
the subforms - there are 3 on the form), we are getting this error:

A little box with "Microsoft Visual Basic in the blue at the top) pops
up with "error in loading DLL"

I think this is where it's getting stuck at because this comes up
yellow when it starts debug (Private Sub Form_KeyPress...statement is
in yellow). Has this gotten lost somehow? How do I get it back?

Private Sub Form_KeyPress(KeyAscii As Integer)

If KeyAscii >= 97 And KeyAscii <= 122 Then
KeyAscii = KeyAscii - 32
End If

End Sub

A couple of other points - the mdb is located on the server. One PC
can still update the form and subforms with no problem, all the other
ones I've tried cannot. I have rebooted the server and that made no
difference. Have there been any microsoft updates that would have
caused this problem to occur??

I WOULD APPRECIATE ANY SUGGESTIONS A TON!!!
thanks,ga
George Applegate
(e-mail address removed)

 

[Allen Browne]

There is a problem with the database rather than with the line of code.

1. Make sure no-one else is using the database.
Compact it:
Tools | Database Utilities | Compact/Repair

2. Open a code window.
Choose References from the Tools menu.
Uncheck any references you do not need.
For a list of the ones you typically need in your version of Access, see:
http://allenbrowne.com/ser-38.html

3. Still in the code window, choose Compile from the Debug menu.
Fix any errors, and repeat until it compiles okay.

Post back if it still has errors, for an explanation of how to decompile.

BTW, if that was your real email address, it might be best not to use it.
There be spambots harvesting here.

 

[George Applegate]

Allen,

THANK YOU!!! You hit the nail on the head exactly. When I went into
code there was a reference that was "missing" having to do with web
components 9.0 or something like that. I unchecked that and
reocmpiled it and it is now working. Hopefully I don't need the web
components thing anywhere anyway, I decided to try it without it, if I
need it for something I can always add it back - a current version of
it anyway.

AWESOME!! Thanks a million for the fast resolution to my problem.

Oh yes, and thanks for the heads up on the email address.

ga

There is a problem with the database rather than with the line of code.

1. Make sure no-one else is using the database.
Compact it:
Tools | Database Utilities | Compact/Repair

2. Open a code window.
Choose References from the Tools menu.
Uncheck any references you do not need.
For a list of the ones you typically need in your version of Access, see:
http://allenbrowne.com/ser-38.html

3. Still in the code window, choose Compile from the Debug menu.
Fix any errors, and repeat until it compiles okay.

Post back if it still has errors, for an explanation of how to decompile.

BTW, if that was your real email address, it might be best not to use it.
There be spambots harvesting here.

George Applegate
(e-mail address removed)