help on vb programming

[benz_jie2005]

---

need help on SQL query about to dates using Visualbasic 6.0
which is from date to date specified
and display data that belong to that date range in a 1 table

..thanks

[godCode]

ha? unsa?

[wailer]

BRO ASA KA NAKAPALIT VB6 kay nangita ko bro kay naa ko application himoon... tnx....

[godCode]

naka palit ko ug vb book sa National Bookstore na naay apil na vb installer. Visual Basic Working Model. ok ra kaayo ni for school projects. dili pwede maka compile ug no activex support. mura 400 kapin to ang book.

[wailer]

OK SALAMAT FOR THE INFO BRO.... :mrgreen: :mrgreen: :mrgreen: :mrgreen:

[uzumaki]

what ru using dude to filter a data base on specified date?
ru using a datepicker or monthview control

if your using a datepicker then you can format it like this one:

text1.text = format(DTP1, 'dd-MM-yyyy')

pass the datepicker value to a text box or u can directly get the datepicker values and on your
query you may use like:

sSQL = "Select * from table1 where date like '%" & text1.text & "%'"

[guyjasper]

if you're using Microsoft Access, use something like this:
strSQL = "SELECT * FROM urTable WHERE DateFrom>=#Jan 01, 2006# AND DateTo<=#Dec 31,2006#"
The query string above will select Dates in between Jan 01 to Dec 31, 2006.

[nax_developer]

note: kinahanglan naa ka ADO active connection
Heres the code:
table name: tSample
field name: date_shift

Private Sub cmdGetDate_Click()
Dim strGetDate as String

strGetDate ="select * from tSample where date_shift between # 01/01/2006 # and #12/31/2006 # "

RS.OPen strGetDate,activeconnection,,1

k...

[dacky]

nice job nax_developer :mrgreen:
i second the motion