Help problem with dll

[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

I WOULD APPRECIATE ANY SUGGESTIONS A TON!!!
thanks,ga

George Applegate
(e-mail address removed)

 

[Al Campagna]

George,
Sounds like a missing reference.
Check out Doug Steele's comprehensive write up...
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html
Give that a try first...
There may be a chance of a missing dll too.
Search the Access Google groups on "public.access" "error loading dll" for a lot of
info related to this problem.

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."