Greyed out Tools, References option in VBA

Michelle Collier-Moore

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|Referenc es
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

Subscribe Reply

32207

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.goo gle.com...

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|Referenc es
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

John Mishefske

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

Similar topics

1702

Playing around with Access references

by: Scott Simonson | last post by:

When in the code editor I select TOOLS | REFERENCES I get a list of references. Mainly DLLs that are accessible. Well I assume that they are all accessible. Besides the ones I have to use or might use, what about the others? While scrolling through the list I saw something with AIM, AOL Instant Messaging. Is there something in there to use in an Access app? How do I know. How could I expose the objects contained in it? Are there other...

Microsoft Access / VBA

1529

Setting References

by: Mike Turco | last post by:

Why is it that the references I set on my computer, under tools|references, don't carry through to other computers? For example, if I check "Microsoft DAO 3.6 Object Library", why don't those to whom I send the database automatically have the same references checked? Is there some way to do this programmatically? I am tired of having to explain how this is done every time I email a database. Thanks -- Mike

Microsoft Access / VBA

2486

References in Access and VB

by: Karl Irvin | last post by:

I need to convert a short Access module to regular VB 5 program. I'm not familiar with VB. In Access I have Public qbXMLCOM As QBXMLRP2Lib.RequestProcessor2 and at Tools>References there is a Reference to QBXMLRP2 1.0 Type Library

Microsoft Access / VBA

1544

references

by: ken | last post by:

Hi, I'm using a reference dll file for my database. Its FEBE so the front ends need to have the reference. How can I have the front end automatically detect the reference if its in the same directory as the database? or can this be done? Otherwise how do people work with references and front ends...

Microsoft Access / VBA

1628

tools->option->view->uncheck in taskbar is coding using vba

by: x taol | last post by:

i want to uncheck windows in taskbar using vba. *** Sent via Developersdex http://www.developersdex.com ***

Microsoft Access / VBA

2462

Get list of Available References?

by: Karl | last post by:

Using VBA can you get a list of Available References? I can get a list of selected References but I would like to get the entire list you see when you click Tools>References and scroll down.

Microsoft Access / VBA

3729

VB - "Available References" problem

by: SpaceMarine | last post by:

hello, i am trying to figure something out. the facts: - i have an Access 2000 app that ive converted to Access 2007 (windows Vista) - it uses several external references, DLLs and an EXE. - these are managed in the VB IDE's Tools-->References... dialog.

Microsoft Access / VBA

867

vs2005 list disapear, in tools->option->env->font ?

by: mttc | last post by:

I'm about chage the font for editor. I open: tools->option->enviroment- but I see only 6 item on combo: "Show setting for" where all the items?

.NET Framework

1418

Vista and 2007 - DAO library work, but shows unchecked in References

by: timmg | last post by:

Situation: Single .mdb developed in A97 last Centurary, very stable and minimal enhancements in the last 3 years. Previously converted to A2000 Test conversion to 2007 on Vista works except for: 1) one subform refused to show data. Opening parent form in desing view and looking at it disaprovingly before closing and save solved problem. Not sure why

Microsoft Access / VBA

9518

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10159

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9033

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7538

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6776

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5436

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5560

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4111

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

2917

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General