Results 1 to 4 of 4

Thread: Quick question

  1. #1
    Join Date
    Oct 2002
    Posts
    15

    Unanswered: Quick question

    When I use this line in my VB procedure:

    Dim QDb As Database


    I get this error message:

    Compile Error:
    User Defined Type not Defined


    I can't figure it out, why the error message? Thanks.
    -The enemy of good is better...

  2. #2
    Join Date
    Aug 2002
    Location
    Québec, Canada
    Posts
    109
    Try :

    Dim QDb As DAO.Database

    Make sure you have DAO object library well referenced

    JefB

  3. #3
    Join Date
    Oct 2002
    Posts
    15

    Thanks Jeff

    I went in an Referenced the 3.6 Library and kept the code the same, it seems to work now :-)
    -The enemy of good is better...

  4. #4
    Join Date
    Aug 2002
    Location
    Québec, Canada
    Posts
    109
    Yeah, actually, it is the same thing DAO.Database or Database will give the same result, but if you add a reference to ADO (another library with recordset and database objects), then if you don't specify DAO.Database or ADO.Database, you might come with errors

    JefB

Posting Permissions

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