Results 1 to 3 of 3
  1. #1
    elmousa68 is offline Novice
    Windows XP Access 2003
    Join Date
    Dec 2006
    Location
    Amman, Jordan
    Posts
    6

    "Type Mismatch" Error

    I keep getting a "Type Mismatch" error when running this code

    set rs=db.openrecordset("select * from table_name", dbopendynaset)



    db is initialized by setting

    set db=currentdb

    I would appreciate your help.

    Ammar Hussein
    Amman, Jordan

  2. #2
    StepUP is offline Advanced Beginner
    Windows 7 64bit Access 2000
    Join Date
    Dec 2005
    Posts
    99
    Is the "rs" variable defined as a DAO recordset?

  3. #3
    elmousa68 is offline Novice
    Windows XP Access 2003
    Join Date
    Dec 2006
    Location
    Amman, Jordan
    Posts
    6

    A different problem

    This problem was due to the references declarations in Tools menu of the module.

    I have a different problem. I am trying to bind a text box control on a report page header section to a global variable. Upon opening the report, I get the correct value of the variable as seen through a MsgBox statement, but the control fails to display the value. Instead, I get a #Name? value displayed.

    What is causing this problem?

    I would appreciate your help.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 0
    Last Post: 09-25-2008, 12:19 PM
  2. "Overflow" error message.
    By joeferraro2000 in forum Queries
    Replies: 0
    Last Post: 03-08-2007, 06:36 PM
  3. Export to .rtf of "104-" converts to "-655&qu
    By Sherri726 in forum Import/Export Data
    Replies: 0
    Last Post: 12-19-2006, 03:16 PM
  4. Replies: 2
    Last Post: 08-31-2006, 12:19 PM
  5. "Count" and "Countif" in Reports
    By JMantei in forum Reports
    Replies: 1
    Last Post: 06-20-2006, 02:20 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums