1,216
社区成员
发帖
与我相关
我的任务
分享
'刷新表格
Public Sub RecordRefresh()
'设置msSql
msSql = msSelect & msTableName & " where kqdate>='" & Format(DateAdd("m", -1, Now), "yyyy-mm-dd") & "' and kqdate<='" & Format(Now, "yyyy-mm-dd") & "'" & msOrderBy
'显示数据
msBarText = "当前数据时间范围:" & Format(DateAdd("m", -1, Now), "yyyy-mm-dd") & "至" & Format(Now, "yyyy-mm-dd")
ShowData
sOrder0 = "+ {kqdate}"
sOrder1 = ""
End Sub
'计发基本工资
Public Sub WageOne()
Dim sSql As String
On Error GoTo myErr
With fMainForm
'设置菜单和工具条
' .mnufile.Enabled = False
' .mnuRecord.Enabled = False
' .mnuMan.Enabled = False
' .mnuBonus.Enabled = False
' .mnuCar.Enabled = False
' .mnuMater.Enabled = False
' .mnuWork.Enabled = False
' .mnuWindow.Enabled = False
' .mnuSysEdit.Enabled = False
' .mnuPreview.Enabled = False
' .mnuPrint.Enabled = False
' .mnuWage.Enabled = False
' .tbToolBar.Enabled = False
End With
With fMainForm.crptPrint
'设定连接串
.Connect = gsCon
'设定打印的报表文件
.ReportFileName = App.Path & "\rpt\one.rpt"
'排序
.SortFields(0) = sOrder0
.SortFields(1) = sOrder1
'指定打印的记录数
sSql = msSql
.SQLQuery = Left(sSql, InStr(1, sSql, "order by") - 2)
.PrinterStartPage = 0
.PrinterStopPage = -1
.CopiesToPrinter = 1
'设定打印预览窗口为frmPreview的子窗体
.WindowParentHandle = frmPreview.hWnd
frmPreview.Show
'设定打印的方式
.Destination = PREVIEWMODE
.Action = PREVIEWMODE
End With
myErr:
ShowError
End Sub