Visual Basic for applications references

I am working with a client who cannot access the references tools>references tab on the visual basic code window.  Where to I find the configuration option to turn this on?
drjoeusaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
There is no option to turn this on per se.  Can you get a screen shot of what the client is seeing ?

mx
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Tools>References
0
drjoeusaAuthor Commented:
I will try to get the screen shot of what he is seeing.  He tells me that the References option is dimmed and not available.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
IF ... the db is an MDE or ACCDE ... and you open the VBA editor ... the References will be grayed out.

And if I recall ... there is one other situation wherein References might be grayed out ... just cannot remember it at the moment.
0
drjoeusaAuthor Commented:
This is an accdb.  I can run the application on my computer without a problem, but he can't.
0
drjoeusaAuthor Commented:
Here is the error that he is getting.  It shows the 'References' grayed out.
ErrorScreen.pdf
0
IT Project MgrVBA/SQL developerCommented:
You will have to clear the reason for the compile error, before the references menu option will be accessible.

The compile error seems to indicate that the object named btnFillDist does not exist.  Check to be sure this object does exist, or delete this section of code if it has been removed from the form or report.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
After the
.Edit

You have
    .Fields(txtDistField) ....
Should be

.Fields("txtDistField") ....   ' Field name in double quotes
0
drjoeusaAuthor Commented:
The problem with access to the references was that they had not stopped the execution of the procedure.  I feel so stupid that I didn't realize that.  One they got the references right, the application worked fine.   Thanks.
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
You still have the (compile) error I showed above.
0
drjoeusaAuthor Commented:
txtDistField is the name of a text box on the form so that the user can specify the field that receives the distance value.   The procedure works fine once the references are right.

Thanks,
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.