Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Location
    Dublin, Ireland
    Posts
    13

    Question MS Query parameter queries

    Hi kids,

    I'm developing an Excel workbook that retrieves data from an Access 2000 database. The database query is embedded in the workbook and uses cell references as parameters. The cell references point to cells that are linked to VB form tools such as combo lists etc.

    I am trying to send a wildcard (asterisk) through to the query as a parameter but I get the following clumsy message:

    "Bad parameter. Microsoft Excel is expecting a different kind of value than what was provided."

    Could anyone tell me how to include wildcards in this type of query? Or is there a way to exclude the use of certain parameters when they are not required?

    Thanks,

    Kev

  2. #2
    Join Date
    Aug 2002
    Location
    Dublin, Ireland
    Posts
    13

    Unhappy

    Do I take it from the deathly silenece that there is no solution to my problem?

    Any help, even a pointer in the right direction, would be appreciated.

    Thanks,

    Kevin

Posting Permissions

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