小弟我接触VB半个月了,现在正跟着一本教材上的实例做,测试运行出现如题情况
代码如下
Private Sub Form_Load()
Dim strNum As String
With Drug_Store.rsShoppingCars
If .State = adStateClosed Then .Open
.Requery
.Filter = "日期 Like '" & Date & "%'"
If .EOF Then
strNum = Format(Date, "yymmdd") & "00001"
Else
.MoveLast
strNum = Right(.Fields("编号"), 5)
strNum = Format(Val(strNum) + 1, "00000")
strNum = Format(Date, "yymmdd") & strNum
End If
End With
txtNumber = "T" & strNum
End Sub
其中.Filter = "日期 Like '" & Date & "%'"为黄色区域
说实话本人还是个菜鸟不怎么懂过滤器这方面,有没有哪个大神来帮忙解释解释,谢谢了
VBFilter
代码如下
Private Sub Form_Load()
Dim strNum As String
With Drug_Store.rsShoppingCars
If .State = adStateClosed Then .Open
.Requery
.Filter = "日期 Like '" & Date & "%'"
If .EOF Then
strNum = Format(Date, "yymmdd") & "00001"
Else
.MoveLast
strNum = Right(.Fields("编号"), 5)
strNum = Format(Val(strNum) + 1, "00000")
strNum = Format(Date, "yymmdd") & strNum
End If
End With
txtNumber = "T" & strNum
End Sub
其中.Filter = "日期 Like '" & Date & "%'"为黄色区域
说实话本人还是个菜鸟不怎么懂过滤器这方面,有没有哪个大神来帮忙解释解释,谢谢了
VBFilter
解决方案 »
- 帮帮俺吧,
- 怎么让VB写的有关闭end的程序 在关闭前进行操作?
- 百万记录级的数据库,如何提高读写效率?
- 使用Inet1.GetChunk(4096, icByteArray)
- 菜鸟提问,创建文件的问题
- vb代码实现播放vcd,比如api,要哪些函数?
- 求高手指导思路!将一段英文文本用“:”分割,要求每段不超过35个字,且一个单词不能被分割在两段中
- 这是ADO的错,还是我们无能为力...
- 如何引用类的事件?
- 怎么实现,把鼠标移进一个对象(比如图片框)内的时侯,鼠标变为自己设定的图标式样?
- 用ACCESS2007如何打开有工作组(MDW)文件加密的ACCESS2003版的数据库文件
- 某列转成行,粘贴
Dim strNum As String
With Drug_Store.rsShoppingCars
If .State = adStateClosed Then .Open
.Requery
.Filter = "日期 Like '" & Date & "%'"
If .EOF Then
strNum = Format(Date, "yymmdd") & "00001"
Else
.MoveLast
strNum = Right(.Fields("编号"), 5)
strNum = Format(Val(strNum) + 1, "00000")
strNum = Format(Date, "yymmdd") & strNum
End If
End With
txtNumber = "T" & strNum
End Sub