asked on

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?

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

There is no option to turn this on per se. Can you get a screen shot of what the client is seeing ?

mx

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

drjoeusa

ASKER

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.

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

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.

drjoeusa

ASKER

This is an accdb. I can run the application on my computer without a problem, but he can't.

drjoeusa

ASKER

Here is the error that he is getting. It shows the 'References' grayed out.
ErrorScreen.pdf

ASKER CERTIFIED SOLUTION

IT Project Mgr

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

After the
.Edit

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

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

drjoeusa

ASKER

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.

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

You still have the (compile) error I showed above.

drjoeusa

ASKER

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,