为什么我的报表只能显示一页呀,该怎么解决呀!!
Private Sub printM_Click()
Dim mon As String
Dim yea As String
yea = Year(Date)
mon = Month(Date)
Dim str As String
Dim rs As New ADODB.Recordset
str = "select ucode as 票据号,uway as 车道,udate as 日期,unumber as 车牌号,utype as 车型,umoney as 金额,utext as 备注 from udoc where month(udate)='" & mon & "' and year(udate)='" & yea & "' and udepose='否'"
rs.Open str, cn, 1, 3
Set DR1.DataSource = rs
DR1.Show vbModal
End Sub
Private Sub printM_Click()
Dim mon As String
Dim yea As String
yea = Year(Date)
mon = Month(Date)
Dim str As String
Dim rs As New ADODB.Recordset
str = "select ucode as 票据号,uway as 车道,udate as 日期,unumber as 车牌号,utype as 车型,umoney as 金额,utext as 备注 from udoc where month(udate)='" & mon & "' and year(udate)='" & yea & "' and udepose='否'"
rs.Open str, cn, 1, 3
Set DR1.DataSource = rs
DR1.Show vbModal
End Sub
解决方案 »
- 求助,VB的属性有没有集合啊
- 恭请高手lyserver入内!~~其它人非请勿入!~
- 马上要变成小星星了,散分啦!变星后立即结贴哦。。。
- 如何将c的头文件转换为vb模块
- msflexgrid问题,在Scroll事件中如何计算窗口内的row值
- 高分求解:如何把任意二制制数转成一个两位十六进制数
- Unicode輸入字符問題
- 从不同的窗体间传递参数(不使用全局变量)在线等待
- 请问vbscript中有没有将word和excel文档转换为txt文件的函数?
- 请问怎样实现菜单的渐变?就是鼠标移动到一个菜单的时候就出现一个渐变的选单背景。谢了。
- 使用Winsock做的客户端和服务器端程序通讯怎么样可以自由的退出而不影响通讯???急,请知道的人指点一下,谢谢!!!
- 用winsock下载文件,如何做到同步??
.....
rs.movenext
loop
set Set DR1.DataSource = rs