Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2002
    Location
    Leicester - UK
    Posts
    820

    Unanswered: how do you get the DAO cr*p to work

    I've tried the following methods that are included in th eMS Help file and i just get the Error User defined data type hasn't be defined, what am i missing?

    Dim dbs As Database

    Dim dbs As DAO.Database
    Definition of a Beginner, Someone who doesn't know the rules.

    Definition of an Expert, Someone who knows when to ignore the rules.

  2. #2
    Join Date
    Nov 2002
    Location
    San Antonio
    Posts
    20
    Go to Tools/References and make sure there is a reference to the DAO object library, either 3.51 or 3.6.

  3. #3
    Join Date
    Oct 2002
    Location
    Leicester - UK
    Posts
    820
    thanks what other stuff should be on?
    this way i can cure the fault before i meet it.

    ps do you know how to get the help files updated to include the other 90% (or so it seems) that is missing from the help files i've got as i've got lots of commands that might be very useful if i can once figure out how to uses them and unassociated links are no use

    eg keyword DOA returns 240 topics but only 90 or so have page associated with them and a nomber of those are just links to content pages that lead back to the useless links
    Definition of a Beginner, Someone who doesn't know the rules.

    Definition of an Expert, Someone who knows when to ignore the rules.

  4. #4
    Join Date
    Nov 2002
    Location
    San Antonio
    Posts
    20
    It depends on what you are doing, if you are just using DAO you should have a reference to the DAO object library, Visual Basic for Appplications, and if you are using Access, the Access X.X Object Library

  5. #5
    Join Date
    Oct 2002
    Location
    Leicester - UK
    Posts
    820
    lots of odbc and such like, any ideas about the evil MS help files?
    Definition of a Beginner, Someone who doesn't know the rules.

    Definition of an Expert, Someone who knows when to ignore the rules.

  6. #6
    Join Date
    Nov 2002
    Location
    San Antonio
    Posts
    20
    Can't help you there, I've got lots of books around so I don't rely on Help very often. Are you developing in Access or VB?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •