How can I determine the exact location of an object where an error occurs

Question

0.00/5 (No votes)

See more:

I´m debugging an Access application following step by step the flow of execution from the autoexec macro, and I get an error "Missing project or library reference" (I don´t know if this is the correct translation, the message is in spanish "No se puede encontrar el proyecto o la biblioteca"); I´m very aware I got a missing reference in the app, but which one ?.
I mean, the debug stops at the beggining of the function to be executed, so it´s very difficult to me to know which object inside the error is refering to.

The function is a string type one with one parameter as string and a second one as boolean. Even the first parameter tells me the library is missing if I try to see its content in the inmediate view.

How can I know what is precisely the missing library or libraries ?

What I have tried:

I'm looking for all the missing references in the project in the meantime.

Unfortunately there are few I can´t find. I asked the systems personnel to get me those files.

One of them is a .tlb file ?. What kind are those ?

Posted 19-Sep-17 5:43am

Miguel Altamirano Morales

Updated 19-Sep-17 6:41am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RedDk · Accepted Answer · 2017-09-19T06:41:00

Solution 1

Debugging in Access requires the VBA console to be active in order to step through the code. Once this separate app, the interface to the lines/blocks of the macro you've F11'd show signs of highlights and procession to next line/block starts occuring, if you've referenced the body of a function or method that the native Access VB module is unable to walk into/about/through the interface will cough up an error message.

I assume this the stage at which you are presently at full stop. Notice that there's an icon on which you can click to access (what a poor word to use in this case ... how about "show" instead) ... to show the Object Browser. Make this view your focus and note there's the reference drop down up there on the main menu bar. There you'll be able to show what type libraries/ dynamic link libraries/etc are CURRENTLY associated with the debugging stage as-is ... and if you're really lucky ... there'll be a "reference" that is missing (italics). The function/method body is in THAT MISSING .tlb/.dll (as you say).

Just add that location to the project. And proceed on your merry way.

No idea where this libraryy resides? Try Googling the filename or even googling the function/method name. And finally get ahold of the guys who gave you this project code and tell them exactly what you've told us.

Posted 19-Sep-17 6:41am

RedDk

Updated 19-Sep-17 6:43am

v2

Comments

Miguel Altamirano Morales 19-Sep-17 14:09pm

Thank you very much, RedDk, such a good and complete answer. Just what I needed, though I just found out that there was a lot of installation errors, to the point we decided to install the application again, in a remote server.

I wonder if this answer is going to remain in this page, if not, to take note of it.

God Bless you, my friend.

Miguel Altamirano Morales 19-Sep-17 14:11pm

I made a mistake rating your answer, it should be five stars. How can I fix this ?

RedDk 19-Sep-17 15:57pm

If you're really committed to studying Access I would recommend (an oldie but a real goodie) Getz-Gilbert VBA Progrmmer's Handbook (2000).

Series: Developer's Handbook

Paperback: 1073 pages
Publisher: Sybex Inc (February 2000)
Language: English
ISBN-10: 0782121624
ISBN-13: 978-0782121629

If you can get your hands on a copy and do some exercising of the debugger through the libraries herein contained you will be undaunted by the other cryptic errors like missing reference ...

Miguel Altamirano Morales 20-Sep-17 11:41am

Thanks a lot, I´m going to look for that book immediatly. I hope I´ll be able to get it thru Internet. We´re having very much hard times in México City.

I was not commited to work with Access indeed, I was inactive (I´m a 67 years old man) and I was studying technologies such HTML, CSS, MVC, just for intellectual purposes, to be able to (still) get a job or projects, and to keep myself busy, but I just got this long-term contract that suddenly appears and I really want to completely master this environment. The money is really worth it and they are such good people. They are very aware that old system is really a mess, although the business logic is very suitable for them. maybe I´ll change it to a most recient technology at medium term.

My main hurry is to know how to make changes to the source file .accdb and to compile it into an executable file (accde). You know, suddenly the debug flow stops, it sends me an unknown error message, the macros don´t run, and things like that.

I have no problems with the Visual basic versión involved.

Thank you very much again, RedDk, I hope I could make myself understandable, I´m in a very distressing and nervous situation.