View original (French)

Date Search in VB6

Solved
hakim_fth Posted messages 157 Status Member -  
hakim_fth Posted messages 157 Status Member -
Hello,

I can't seem to run the date search in VB6/Access. Here's what I've put:

Data1.RecordSource = "Select * from MaTable where Date < #Label1#"

Thank you for your help!

Configuration:  Windows 7 / Internet Explorer 8.0

2 answers

  1.
    f894009 Posted messages 17417 Registration date   Status Member Last intervention   1 717
     
    Hello,

    If Label1 is a label.

    Data1.RecordSource = "Select * from MyTable where Date < #" & Label1.Caption & "#;"

    Have a good continuation
    0
  2. hakim_fth Posted messages 157 Status Member
     
    Hello,

    Thank you very much "f894009", it works very well, that's very kind of you :)
    0