Re: Database Data type

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Allen Browne (AllenBrowne_at_SeeSig.Invalid)
Date: 03/01/04 

Date: Tue, 2 Mar 2004 00:24:14 +0800

In an ideal world, Sue, you should not have to know this kind of
information. That was the case until Access 2000, when Microsoft suddenly
disabled this library after having it faithfully in the previous 5 versions.
Fortunately they put the reference back in by default in A2003.

Now you are aware of the references issue, you will know to look at which
library provides the reference. The Help file does show the various trees.
The Object Browser also helps locate objects (F2 from a code window). Since
the DAO library is so useful in Access (JET) databases, there is a picture
of the library in this link also:
    http://allenbrowne.com/ser-04.html 

-- 
Allen Browne - Microsoft MVP.  Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Sue" <susan.c.peirce@uhl-tr.nhs.uk> wrote in message
news:489e01c3ffa6$34455980$a501280a@phx.gbl...
> Wow! So simple, yet so effective. Thanks muchly!
> For future reference, where should I have been able to
> find out this kind of information?
> Sue
>
>
> >-----Original Message-----
> >From any code window, choose References from the Tools
> menu.
> >Check the box beside:
> >    Microsoft DAO 3.6
> >
> >More info on references:
> >    http://allenbrowne.com/ser-38.html
> >
> >-- 
> >Allen Browne - Microsoft MVP.  Perth, Western Australia.
> >Tips for Access users - http://allenbrowne.com/tips.html
> >Reply to group, rather than allenbrowne at mvps dot org.
> >
> >"Sue" <susan.c.peirce@uhl-tr.nhs.uk> wrote in message
> >news:4a6801c3ffa2$9c271e20$a401280a@phx.gbl...
> >> I'm trying to define a database object so that I can use
> >> the CurrentDB method but the statments:
> >> Dim dbs As Database
> >> or
> >> Dim dbs As DAO.Database
> >> both return the error 'User-defined data type not
> defined'
> >> and this type isn't listed in the autocomplete listbox
> >> that comes up when you type 'As '.
> >>
> >> Thanks,
> >>
> >> Sue (pulling-hair-out)
> >
> >
> >.
> >

Relevant Pages

  • Re: M$ goes after software developers
    ... Microsoft in the hope of selling them a pen OS. ... It's a quote from your own reference. ... It illustrates Microsoft's business practices which was the original ...
    (comp.sys.mac.advocacy)
  • Re: M$ goes after software developers
    ... Peter Hayes wrote: ... Microsoft in the hope of selling them a pen OS. ... It's a quote from your own reference. ... It illustrates Microsoft's business practices which was the original ...
    (comp.sys.mac.advocacy)
  • Re: Workbook code works on my machine but noy others
    ... MsgBox "You are using Excel 2007." ... Outlook reference in the project, I had to define each constant. ... Microsoft Office 10.0 Object Library ...
    (microsoft.public.excel.programming)
  • Re: Workbook code works on my machine but noy others
    ... Outlook reference in the project, I had to define each constant. ... Sub MultipleAppointment(Addressee, AddresseeOptional, OnDate, StartTime, ... Microsoft Office 10.0 Object Library ... Weird as the application works ok on some machines but not other ...
    (microsoft.public.excel.programming)
  • Re: Late Binding
    ... You can try unchecking the reference, ... need to add the Microsoft ActiveX Data Objects 2.7 Library reference back. ...
    (microsoft.public.access.queries)