打印报表后,然后更改打印条件,预览时发现还是上一次的数据,除非再点击一次预览按钮,才会变化,很是奇怪。 预览的代码:
With ARWendu
.DataControl1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + App.Path + "\Data_Sys.mdb;Jet OLEDB:Database Password=hellobcb31023;Persist Security Info=False"
.DataControl1.Source = conString
.DataControl1.Refresh
.Field1.DataField = "记录号"
.Field2.DataField = "机器号"
.Field3.DataField = "温度"
.Field4.DataField = "报警上限"
.Field5.DataField = "报警下限"
.Field6.DataField = "值班操作员"
.Field7.DataField = "采样时间"
.Field8.Text = Now
.Field9.Text = curUser.userName
.Show
End With打印的代码:
With ARWendu
.DataControl1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + App.Path + "\Data_Sys.mdb;Jet OLEDB:Database Password=hellobcb31023;Persist Security Info=False"
.DataControl1.Source = conString
.DataControl1.Refresh
.Field1.DataField = "记录号"
.Field2.DataField = "机器号"
.Field3.DataField = "温度"
.Field4.DataField = "报警上限"
.Field5.DataField = "报警下限"
.Field6.DataField = "值班操作员"
.Field7.DataField = "采样时间"
.Field8.Text = Now
.Field9.Text = curUser.userName
..PrintReport True
End With
With ARWendu
.DataControl1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + App.Path + "\Data_Sys.mdb;Jet OLEDB:Database Password=hellobcb31023;Persist Security Info=False"
.DataControl1.Source = conString
.DataControl1.Refresh
.Field1.DataField = "记录号"
.Field2.DataField = "机器号"
.Field3.DataField = "温度"
.Field4.DataField = "报警上限"
.Field5.DataField = "报警下限"
.Field6.DataField = "值班操作员"
.Field7.DataField = "采样时间"
.Field8.Text = Now
.Field9.Text = curUser.userName
.Show
End With打印的代码:
With ARWendu
.DataControl1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + App.Path + "\Data_Sys.mdb;Jet OLEDB:Database Password=hellobcb31023;Persist Security Info=False"
.DataControl1.Source = conString
.DataControl1.Refresh
.Field1.DataField = "记录号"
.Field2.DataField = "机器号"
.Field3.DataField = "温度"
.Field4.DataField = "报警上限"
.Field5.DataField = "报警下限"
.Field6.DataField = "值班操作员"
.Field7.DataField = "采样时间"
.Field8.Text = Now
.Field9.Text = curUser.userName
..PrintReport True
End With
解决方案 »
- 求vb+mapx二次开发高手 我已经实现了地图的加载,和一般的功能,现在需要,点击一个区改变区的颜色?
- 求助vb打开txt第一次不显示问题
- 请教个分隔字符串的问题
- VB中如何获取SQL数据库的数据?
- 请求,各位高人,给我提供个VB做界面的网站,介绍一下。
- OLE1中为Excel 另存和打印问题
- 在线等待:DTPicker时间段查询
- 异步存取数据库,FetchProgress 与 进度条 ProgressBar1 的问题? 急急...
- VB的工作不好找呀?
- vb生成.exe文件,oracle运行时报告TNS错误:无法处理服务器名
- 各位哥哥姐姐小弟有些问题大家帮忙解答一下好吗?——在线等 急急!!
- [100分全部送]大家快来帮帮俺
With myARWendu
.DataControl1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + App.Path + "\Data_Sys.mdb;Jet OLEDB:Database Password=hellobcb31023;Persist Security Info=False"
.DataControl1.Source = conString
.DataControl1.Refresh
.Field1.DataField = "记录号"
.Field2.DataField = "机器号"
.Field3.DataField = "温度"
.Field4.DataField = "报警上限"
.Field5.DataField = "报警下限"
.Field6.DataField = "值班操作员"
.Field7.DataField = "采样时间"
.Field8.Text = Now
.Field9.Text = curUser.userName
.Show
End With
set myARWendu=nothing原因在于你打开了AR的窗体(默认对象),但却没有关闭它,那么它还保存上次的数据,并没有刷新.解决的办法是每次都定义一个新的对象,然后对这个新对像进行操作.