User Profile

Collapse

Profile Sidebar

Collapse
Revathi002
Revathi002
Last Activity: Aug 8 '12, 03:42 PM
Joined: Aug 6 '12
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Revathi002
    replied to how to connect date picker values to adodb?
    in Visual Basic
    how to display the selected values as checked one in calender?

    i have inserted two datepicker in this form and make these values drop in the datebase using adodb connection.Thes e values has to be shown as crossed one in the monthview calendar.How to do this one?
    Code:
    Dim esql As String
Dim con As New ADODB.Connection
Dim rs As New ADODB.Recordset
'show
Private Sub Command1_Click()
MonthView1.Value
    ...
    See more | Go to post

      Leave a comment:

    • Revathi002
      started a topic how to connect date picker values to adodb?
      in Visual Basic

      how to connect date picker values to adodb?

      Code:
      Private Sub Command1_Click()
Dim EndDate, CurDate As Date
Dim BusDay, TotBusDays, CalcYear As Integer
TotBusDays = 1
CurDate = DTPicker1.Value
EndDate = DTPicker2.Value
Do Until CurDate = EndDate
BusDay = Format(CurDate, "w")
Select Case BusDay
Case "2" To "6"
TotBusDays = TotBusDays + 1
Case "1"
'Do nothing
Case "2"
      ...
      See more | Go to post
      No activity results to display
      Show More
      Working...