1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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