Results 1 to 4 of 4

Thread: type mismatch?

  1. Feb 15th, 2002, 09:01 PM #1
    quipy
    quipy is offline

    Thread Starter
    Lively Member
    Join Date
    Feb 2002
    Posts
    103

    type mismatch?

    got a type mismatch error on:

    Set RS = DB.OpenRecordset(ReportSQL)

    ReportSQL is a SQL string
    any ideas?
    Reply With Quote Reply With Quote
  2. Feb 15th, 2002, 09:03 PM #2
    skald2k
    skald2k is offline
    Fanatic Member skald2k's Avatar
    Join Date
    Feb 2002
    Location
    Sydney, Australia
    Posts
    535
    Set RS = DB.Execute(reportSQL)

    assuming that DM = adodb.connection, and that you have set that connection up properly.
    - If at first you dont succeed, then give up, cause you will never will!
    Reply With Quote Reply With Quote
  3. Feb 15th, 2002, 09:13 PM #3
    quipy
    quipy is offline

    Thread Starter
    Lively Member
    Join Date
    Feb 2002
    Posts
    103
    what? so i have to go to "References" under "Project" and move ADO 's priority above the DAO?
    Reply With Quote Reply With Quote
  4. Feb 15th, 2002, 09:15 PM #4
    skald2k
    skald2k is offline
    Fanatic Member skald2k's Avatar
    Join Date
    Feb 2002
    Location
    Sydney, Australia
    Posts
    535
    Your using DAO? Ahh okay then. I can't answer your question then. It was intended for ADO but you didn't specifiy.
    - If at first you dont succeed, then give up, cause you will never will!
    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