Results 1 to 4 of 4

Thread: MDB

  1. Jun 4th, 2000, 09:20 PM #1
    HeSaidJoe
    HeSaidJoe is offline

    Thread Starter
    _______ HeSaidJoe's Avatar
    Join Date
    Jun 1999
    Location
    Canada
    Posts
    3,946
    Option Explicit

    Public MDB as Database, RS as Recordset

    When I type this in I get an error
    type not defined....

    What reference am I missing? I've used it
    before but I don't even recall using a reference
    "A myth is not the succession of individual images,
    but an integerated meaningful entity,
    reflecting a distinct aspect of the real world."
    ___ Adolf Jensen
    Reply With Quote Reply With Quote
  2. Jun 4th, 2000, 09:29 PM #2
    DavidRidgway
    DavidRidgway is offline
    Junior Member
    Join Date
    Jan 1999
    Location
    Halifax, NS Canada
    Posts
    30
    I had the same problem. It has something to do with using ADO controls but I cannot explain why the error occurs.

    Someone told me to declare the recordset like this and it worked:

    Dim DAO.RS as Recordset
    Reply With Quote Reply With Quote
  3. Jun 4th, 2000, 09:51 PM #3
    HeSaidJoe
    HeSaidJoe is offline

    Thread Starter
    _______ HeSaidJoe's Avatar
    Join Date
    Jun 1999
    Location
    Canada
    Posts
    3,946

    DAO

    OK..found it...
    Need to reference DAO 3.51 under references.

    Tried your solution
    Public DAO.RS as Recordset
    and it didn't work for me

    Thanks,
    "A myth is not the succession of individual images,
    but an integerated meaningful entity,
    reflecting a distinct aspect of the real world."
    ___ Adolf Jensen
    Reply With Quote Reply With Quote
  4. Jun 5th, 2000, 07:13 PM #4
    michelle
    michelle is offline
    Hyperactive Member
    Join Date
    Jul 2002
    Location
    Canada
    Posts
    455
    Hello HeSaidJoe,

    Please goto [Project] - [References]
    Choose for [Microsoft DAO 2.5/3.5 compability]

    Use next source:

    Option Explicit
    Private RS As Recordset
    Private DB As Database

    This works!

    Nice regards,

    Michelle.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width