selecting data

Results 1 to 3 of 3

Thread: selecting data

  1. #1
    Join Date
    Dec 1969

    Default selecting data

    hello, <BR>im trying to select data from an access db that fits the critera given in the varItemSelected variable<BR><BR>heres what i have <BR><BR>SQLstmt = "SELECT * FROM Products WHERE product = " &_ varItemSelected <BR><BR>set rs = con.Execute(SQLstmt)<BR><BR>but i get this error:<BR><BR>Microsoft JET Database Engine error &#039;80040e10&#039; <BR>No value given for one or more required parameters<BR><BR>any ideas?<BR>thanks<BR>

  2. #2
    Join Date
    Dec 1969

    Default Why post the same thing twice???


  3. #3
    Join Date
    Dec 1969

    Default RE: selecting data

    And what was the *OUTCOME* of your *DEBUG*

Posting Permissions

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