evalesthy,
Sorry, I never found a solution to the issue. I undid what I was doing and made sure the reference libraries were back to what they were when I started with the other project. Fortunately for me, I didn't really need the project that caused the error.
I wish I could be of more...
Thanks for your help Earnie! I'm sure I'll figure it out soon, but I need to leave it alone for the weekend so that I don't pull out the rest of my hair!
Belden
Earnie,
I get "Compile Error: Error in loading DLL" and it highlights "CurrentDb" when it get to here:
Set rsMemberID = CurrentDb.OpenRecordset(sSQL)
Any thoughts?
Thanks!
Belden
SemperFiDownUnda,
Thanks for the input.
Yeah, it does sound like something isn't set up right, but it had been working fine Friday morning.
Could the DLL(s) have gotten corrupted or something, or moved somehow? Where are they normally located?
Just to clarify, what I mean by reference...
I've had an Access application working for about 2 years, until this morning! Now I get "Compile error: Error in loading DLL" when I try to run it.
I should preface this by saying I'm tech savvy, but know next to nothing about VB.
Nothing changed. I think.
The only thing that...
Earnie,
Thanks for the quick reply!
Where the "that last bit of code" begin?
I've been swamped today so I haven't been able to try your code yet. When I do I'll let you know how it goes.
Thanks!
Belden
Hey Earnie!
I have the exact same conundrum that you had last month, but I don't know VB to save my life.
I've got a table in an Access 2000 db that looks like this:
MemberID Designation
1 MBA
1 CPA
2 ABC
2 XYZ
3 MBA
Idealy, I'd like to query the...
Has anyone found a solution to KLewisBPM's issue?
I'm having a similar problem occur. 25 users running Win98, 2000 and XP, accessing an Access DB (80mb) on an NT 4.5 server.
Thanks and have a nice day!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.