[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Visual Basic for applications references

Posted on 2014-08-21
11
Medium Priority
?
261 Views
Last Modified: 2014-08-22
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?
0
Comment
Question by:drjoeusa
  • 5
  • 5
11 Comments
 
LVL 75
ID: 40277484
There is no option to turn this on per se.  Can you get a screen shot of what the client is seeing ?

mx
0
 
LVL 75
ID: 40277493
Tools>References
0
 

Author Comment

by:drjoeusa
ID: 40277612
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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 75
ID: 40277627
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
 

Author Comment

by:drjoeusa
ID: 40277683
This is an accdb.  I can run the application on my computer without a problem, but he can't.
0
 

Author Comment

by:drjoeusa
ID: 40279554
Here is the error that he is getting.  It shows the 'References' grayed out.
ErrorScreen.pdf
0
 
LVL 1

Accepted Solution

by:
IT Project Mgr earned 2000 total points
ID: 40279655
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
 
LVL 75
ID: 40279693
After the
.Edit

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

.Fields("txtDistField") ....   ' Field name in double quotes
0
 

Author Closing Comment

by:drjoeusa
ID: 40279832
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
 
LVL 75
ID: 40279871
You still have the (compile) error I showed above.
0
 

Author Comment

by:drjoeusa
ID: 40279939
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

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question