type mismatch

Discussion in 'Access Forms Coding' started by ted, Sep 24, 2012.

  1. ted

    ted Guest

    converted a 2003 form file to 2007 & get the 'type mismatch' error in this vb program: Set dbsDatabase = CurrentDb
    Set rstMembers = dbsDatabase.OpenRecordset("students", dbOpenDynaset)


    anyone got any ideas? TIA
     
    ted, Sep 24, 2012
    #1
    1. Advertisements

  2. Already answered in microsoft.public.access to which you posted the same
    question. Please don't multipost. If you feel you must post to more than one
    newsgroup, please crosspost instead.

    "ted" wrote in message
    news:...

    converted a 2003 form file to 2007 & get the 'type mismatch' error in this
    vb program: Set dbsDatabase = CurrentDb
    Set rstMembers = dbsDatabase.OpenRecordset("students", dbOpenDynaset)


    anyone got any ideas? TIA
     
    Douglas J Steele, Sep 24, 2012
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Brian

    Type Mismatch

    Brian, Jul 3, 2003, in forum: Access Forms Coding
    Replies:
    6
    Views:
    103
    Andy Cole
    Jul 3, 2003
  2. Hootie

    Type Mismatch Problem

    Hootie, Jul 7, 2003, in forum: Access Forms Coding
    Replies:
    3
    Views:
    119
    Andy Cole
    Jul 7, 2003
  3. Debbie Young

    error "type mismatch"

    Debbie Young, Jul 18, 2003, in forum: Access Forms Coding
    Replies:
    0
    Views:
    84
    Debbie Young
    Jul 18, 2003
  4. Krisse

    Type mismatch error in set statement

    Krisse, Jul 18, 2003, in forum: Access Forms Coding
    Replies:
    1
    Views:
    178
    Krisse
    Jul 19, 2003
  5. Eddy

    Data Type Mismatch?

    Eddy, Aug 29, 2003, in forum: Access Forms Coding
    Replies:
    1
    Views:
    90
    Wayne Morgan
    Aug 29, 2003
  6. tina

    Data type mismatch error

    tina, Aug 30, 2003, in forum: Access Forms Coding
    Replies:
    0
    Views:
    87
  7. Damion

    type mismatch with recordset object?

    Damion, Sep 23, 2003, in forum: Access Forms Coding
    Replies:
    2
    Views:
    169
    Douglas J. Steele
    Sep 26, 2003
  8. mané_uk

    Date type Variable - Type Mismatch

    mané_uk, Jul 8, 2009, in forum: Access Forms Coding
    Replies:
    5
    Views:
    269
    Douglas J. Steele
    Jul 8, 2009
Loading...