By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,660 Members | 1,945 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,660 IT Pros & Developers. It's quick & easy.

Greyed out Tools, References option in VBA

P: n/a
Please could someone offer some advice regarding adding references to
an Access database?

I tried to open a project a few days ago sent to me by someone whose
developer had left the company. I found that I had a reference problem
and went to the usual Tools, References place to fix it. The
References option was greyed out and as I have never seen this happen
before, after trying various things, searching here for an answer etc.
gave up!!

Today I have made some changes to one of my own databases where I have
to prioritise DAO over ADO; I've done this numerous times. Again, the
References option on the menu is greyed out. I've searched here and
found a couple of posts relating to this issue. In particular this
one...
Open the Debug Window (Ctrl-G) and on the Tools menu, check
references. Sounds like your ADO reference is not set.

OK, while under the run-time debugger, the "References" >>options was greyed out. However, checking my Access and >>Computer #2's
Access under design conditions revealed that >>both copies appear to
have identical references checked

I have tried what is suggested above and it is still unavailable.

Another post asks the question...
- Is it possible to reactivate VBA at the local machine?

(Tools|References
is greyed out)

Unfortunately the respondent doesn't answer that question.

I haven't changed the configuration of my machine to "deactivate VBA",
not even sure what that means but I've not had problems in the past.

I've made sure that the "Immediate" window is open; this seems to be
mooted as a possible problem in some posts.

Any ideas?

Regards

Michelle
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
TC
I know that you can not change the references in an MDE database. I don't
know whether this causes the Tools : References option to be disabled (and I
don't have Access here to check). Could that be the expanation?

HTH,
TC
"Michelle Collier-Moore" <mi******************@hotmail.com> wrote in message
news:68**************************@posting.google.c om...
Please could someone offer some advice regarding adding references to
an Access database?

I tried to open a project a few days ago sent to me by someone whose
developer had left the company. I found that I had a reference problem
and went to the usual Tools, References place to fix it. The
References option was greyed out and as I have never seen this happen
before, after trying various things, searching here for an answer etc.
gave up!!

Today I have made some changes to one of my own databases where I have
to prioritise DAO over ADO; I've done this numerous times. Again, the
References option on the menu is greyed out. I've searched here and
found a couple of posts relating to this issue. In particular this
one...
Open the Debug Window (Ctrl-G) and on the Tools menu, check
references. Sounds like your ADO reference is not set.

OK, while under the run-time debugger, the "References" >>options was greyed out. However, checking my Access and >>Computer #2's
Access under design conditions revealed that >>both copies appear to
have identical references checked

I have tried what is suggested above and it is still unavailable.

Another post asks the question...
- Is it possible to reactivate VBA at the local machine?

(Tools|References
is greyed out)

Unfortunately the respondent doesn't answer that question.

I haven't changed the configuration of my machine to "deactivate VBA",
not even sure what that means but I've not had problems in the past.

I've made sure that the "Immediate" window is open; this seems to be
mooted as a possible problem in some posts.

Any ideas?

Regards

Michelle

Nov 12 '05 #2

P: n/a
TC wrote:
I know that you can not change the references in an MDE database. I don't
know whether this causes the Tools : References option to be disabled (and I
don't have Access here to check). Could that be the expanation?


Another possibility is that code is still running. Try selecting Run, Reset
from the menu in the VB editor (or click the square VCR-style icon).

--
'-------------------------------
' John Mishefske
'-------------------------------

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.