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

Answer 1 / 2
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
Answer 2 / 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