chanlichin

[QUOTE]My following code is only retrives number month(1,2,3,4....12) and not month name(January,February,.....December). Can anyone help me to retrieves month name in sql query. Before that i had try using function datepart, Monthname and date_format but i still din get my answer.Thanks[/QUOTE] [CODE]con.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = C:\YS.mdb" con.Open() sql = …

[QUOTE]I am facing the problem in select the item dates. This is because i only want the condition of month from table dates. So i think the data set i write it get the error. Any one can help me,Thanks.[/QUOTE] [CODE] con.Open() sql = "SELECT DISTINCT Month(dates) FROM summary WHERE …

[quote]I get the bar as the picture below. But the value for each bar display is too crowded. So can i know how to change the vertical values(each stack bar) into horizontal value.Thanks.Below is my coding.[/QUOTE] [img]<a href='http://img513.imageshack.us/i/58407423.jpg/'><img src='http://img513.imageshack.us/img513/8098/58407423.jpg' border='0' alt='Image Hosted by ImageShack.us'/></a><br/>[/img] [code] myPane.BarSettings.Type = BarType.Stack myPane.XAxis.Type = …

Hi, i am now want to insert data(fault and visual(bold)) into the table. After done the calculation, i would like to insert the fault and visual value into my table summary. My field name in table summary for fault(fo_ratio) and visual(visual) So below is my coding. How can i save …

Hi, I am now want to retrieve only year from my table(summary),field name(dates). So i am facing the problem on how to display the year in combo Box. my sql statement as below. Thanks If i put [b]SELECT DATES[/b], that means day,month and year will display. So, what should i …

hi, the below coding of inserting data into database MS Access. So , may i ask what is the meaning for the coding i bold. Why the maxrow>0 , the message will come out? thanks. [code] con.Open() sql = "SELECT * FROM summary WHERE line = '" & cbLine.Text & …

hi,i am new to vb 8 and i am now facing the problem to write sql statement. i want to retrieved data from MS Access by select the date using date time picker. so my problem is how to write the sql statement. My code is as below: sql = …