Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Location
    Myanmar (Burma)
    Posts
    42

    Unhappy Unanswered: How to pass a parameter? (BVA)

    Dear Guru

    I have a parameter query like this

    SELECT * FROM consunti WHERE (((consunti.DATA)=[DD]));

    I don't know how to pass required parameter to this query when I try to write a code in vba

    tks in adv.

    mmlatt
    Cyber : The easiest place to make huge mistake.

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Lightbulb

    Put this parameter in a TextBox on a Form then call your Query using


    "SELECT * FROM consunti WHERE consunti.DATA='" & Forms!yourFormName!yourTextBoxName "'" ;


    in case of strings

Posting Permissions

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