Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


Tools/References is not available

Posted on 2003-03-24
Medium Priority
Last Modified: 2012-05-04
My VB code says
>>>> Public db As Database

But that gives me a
>>>> User-defined type not defined

I've looked around for answers, and they say to go to Tools/References and make sure that DAO is referenced. My problems is that when I go to Tools, "References" is disabled (grayed-out, you know what I mean).

What is wrong? How do I get to the references?

This is a plain Access 2000 system. Is there some kind of option or add-on I need to flip?

Question by:Keeves
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2

Author Comment

ID: 8194898
AAAK! I'm sorry! I meant to change the title to "Tools/References is not available"
LVL 28

Accepted Solution

TextReport earned 180 total points
ID: 8194913
Try resetting / stopping the current code that is executing then it should be enabled.

Cheers, Andrew

Author Comment

ID: 8251107
I just now tried stopping the code, and that worked fine. I can't figure out why I didn't think of trying that before.

I had thought that I'm supposed to get an automatic email when someone responds to my question, and I don't think I ever got it. I just figured it out myself, so I came here to cancel the question. Lo and behold, TextReport answered it just a few minutes after I asked it last week. I wish I had seen the answer sooner, but fair is fair, and I am now marking it as answered so that TextReport will get the points. Thanks.

Featured Post

How Blockchain Is Impacting Every Industry

Blockchain expert Alex Tapscott talks to Acronis VP Frank Jablonski about this revolutionary technology and how it's making inroads into other industries and facets of everyday life.

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

705 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