VB + SQL (Accept date input from user for search)

Discussion in 'MySQL' started by abstrused00388, Jun 29, 2011.

  1. abstrused00388

    abstrused00388 New Member

    Joined:
    Jun 29, 2011
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    0
    Adodc1.RecordSource = "SELECT * FROM cm1 WHERE dt>=#1/1/2011 02:00:00 AM# AND dt<=#4/1/2011 02:00:00 PM#"

    for searching a database using VB !

    please let me know if there is a way to accept input from the user in a text box and use thm instead of the constant values that i have used
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice