代码已经测过一,一切都正常,可以预览,可以打印,你应该是没有装打印机的缘故 unable to initialize printer.你的出错也说明了不能初始化打印机而已
大哥:可是当我开始调用它时,就打印预览不了,为什么?怎么解决? Function SetPrinterFunc(ByRef f1b As F1Book) Dim printSetup As F1PageSetup Set printSetup = f1b.GetPageSetup With printSetup .ColHeadings = True .HeaderMargin = g_Repuse.pageTop .FooterMargin = g_Repuse.pageBotton .LeftMargin = g_Repuse.pageLeft .RightMargin = g_Repuse.pageRight .Header = f1b.Title .Footer = "第 &P 页(共 &n 页)" .CenterHoriz = True Select Case g_Repuse.pageSize Case 8: .PaperSize = F1PaperA3 Case 9: .PaperSize = F1PaperA4 Case 11: .PaperSize = F1PaperA5 Case 12: .PaperSize = F1PaperB4 Case 13: .PaperSize = F1PaperB5 Case Else .PaperSize = F1PaperA4 End Select .Landscape = True End With f1b.SetPageSetup printSetup End Function
之后我按打印按纽没有反映,为什么?
之后我按打印按纽没有反映,为什么?
我不知道你为什么时候没反映,我这里可以的啊
很抱歉 谢谢!
你在用for i=0 to rs.RecordCount 当然会出错,
你用前面的Rs.open Ssql,conn.1,3你最好在LOAD过程中跟踪调试一下,看看到底错在哪里,
你只给我代码,我说的窗体文件一起拿过来,我来调试,OK
我给你发过来form文件了,你看一下,我看了
rs.Open strSql, conn, adOpenKeyset, adLockOptimistic
和
Set rs = conn.Execute(strSql)
rs.recordcount都有值
unable to initialize printer.你的出错也说明了不能初始化打印机而已
Function SetPrinterFunc(ByRef f1b As F1Book)
Dim printSetup As F1PageSetup
Set printSetup = f1b.GetPageSetup
With printSetup
.ColHeadings = True
.HeaderMargin = g_Repuse.pageTop
.FooterMargin = g_Repuse.pageBotton
.LeftMargin = g_Repuse.pageLeft
.RightMargin = g_Repuse.pageRight
.Header = f1b.Title
.Footer = "第 &P 页(共 &n 页)"
.CenterHoriz = True
Select Case g_Repuse.pageSize
Case 8:
.PaperSize = F1PaperA3
Case 9:
.PaperSize = F1PaperA4
Case 11:
.PaperSize = F1PaperA5
Case 12:
.PaperSize = F1PaperB4
Case 13:
.PaperSize = F1PaperB5
Case Else
.PaperSize = F1PaperA4
End Select
.Landscape = True
End With
f1b.SetPageSetup printSetup
End Function