打个比方,在DTPICKER里我输入了2002-10-10,在COMBO里动态显示出从2002-10-10开始的十个工作日的日期。
解决方案 »
- 同学给个报价!
- 熟悉网络的各位不要客气阿,有没有人知道SNMP常用的API呀,翻了半天找不到VB资料,顶者有分哦!!!!!!!!!!!
- 无奈啊!对发贴不结贴的无奈!
- 妈的,喝过"黑松沙士"的过来接分,说说那个味道像什么
- 请问文本框里怎样做标记
- 请教软件换肤的原理以及在vb和vb.net里都可用的换肤软件
- 如何用VB6.0安装程序来创建桌面快捷图标
- ie7 webbrowser
- 救救我....
- How to set the system date's format under winnt/win98?
- 我的代码哪里错了?
- 用SetWindowLong函数使MDI窗体的最大化按钮无效时,碰到的窗体尺寸的问题
Dim i As Long
Dim o_Date As Date
o_Date = Me.DTPicker1.Value
With Me.Combo1
.Clear
For i = 0 To 9
If Weekday(o_Date) = 5 Then o_Date = DateAdd("d", 2, o_Date)
'If Weekday(o_Date) = 6 Then o_Date = DateAdd("dd", 1, o_Date)
.AddItem Format(o_Date, "yyyy-mm-dd")
o_Date = DateAdd("d", 1, o_Date)
Next i
End With
End Sub
Dim i As Long
Dim o_Date As Date
o_Date = Me.DTPicker1.Value
' 1 = 星期天
If Weekday(o_Date) = 1 Then o_Date = DateAdd("dd", 1, o_Date)
With Me.Combo1
.Clear
For i = 0 To 9
' 7 = 星期六
If Weekday(o_Date) = 7 Then o_Date = DateAdd("d", 2, o_Date)
.AddItem Format(o_Date, "yyyy-mm-dd")
o_Date = DateAdd("d", 1, o_Date)
Next i
End With
End Sub
看看这个算法:
Private Sub DTPicker1_Change()
Dim ss As Date
Dim da As Date
Dim i As Integer
Dim j As Integer
Dim Toldate As Integer'需要显示的天数
Toldate = 10 '设定显示10天
da = DTPicker1.Value
i = DatePart("w", da, vbMonday)'从周一算
MsgBox i
Do Until i >= 6 Or Combo1.ListCount = Toldate
da = da + 1
Combo1.AddItem da
i = i + 1
Loop
da = da + (8 - i)
ss = da
Do Until Combo1.ListCount = Toldate
For i = 0 To 4
Combo1.AddItem ss
ss = ss + 1
If Combo1.ListCount = Toldate Then Exit For
Next i
ss = ss + 2
Loop
End Sub