gumagamit ako ng visual basic 6.0 sa program ko. and ginamitan ko xa ng date time picker to summarize the reports, pero dun sa reports ko gusto kong ipakita ung daily and monthly and even the yearly report pero ndi ako marunong gumatin ng dtpicker. ndi ko po alam un codes na gagamitin..hope you can help me...

gumagamit ako ng visual basic 6.0 sa program ko. and ginamitan ko xa ng date time picker to summarize the reports, pero dun sa reports ko gusto kong ipakita ung daily and monthly and even the yearly report pero ndi ako marunong gumatin ng dtpicker. ndi ko po alam un codes na gagamitin..hope you can help me...

Use Combobox to select the Month and year nalang

create a combobox with
January
February
...
...
etc


then combobox with
year 2009 to 2010 depending sa range ng report
(this year - 2) 2008
(this year - 1) 2009
(this year) 2010
(this year + 1) 2011

that way exact Month and Year ang nasa GUI

pag nag select ng March 2010
sa code i-translate mo sya ng date range
March 1 to march 31 , 2010
then use the BETWEEN caluse sa SQL Query mo for the report

DtPicker are for exact dates lang


try mo muna sa separate na project and experiment

concat mo lang na parang textbox kc kukunin mo lang naman yung value ng dtpicker eh tapos insert mo sa sql mo gamit ka rin ng string format para ok kung may tanong ka pa pm ka lang

Use Combobox to select the Month and year nalang

create a combobox with
January
February
...
...
etc


then combobox with
year 2009 to 2010 depending sa range ng report
(this year - 2) 2008
(this year - 1) 2009
(this year) 2010
(this year + 1) 2011




that way exact Month and Year ang nasa GUI

pag nag select ng March 2010
sa code i-translate mo sya ng date range
March 1 to march 31 , 2010
then use the BETWEEN caluse sa SQL Query mo for the report

DtPicker are for exact dates lang


try mo muna sa separate na project and experiment



hello po..please..bago po lang po ako d2..need kupo help ninyo..pag-SEARCH po using combobox date picker din po, kc gusto kopong e-search ung old record..having it's year, semester and name..sana po help nyo ako...