Private Sub Report_Open(Cancel As Integer)
If DCount("*", "查询1") Mod 20 <> 0 Then
Me.RecordSource = "Select * from 查询1 UNION ALL select TOP " & (20 - DCount("*", "查询1") Mod 20) & " * from Blank"
Else
Me.RecordSource = "Select * from 查询1"
End If
End Sub
Private Sub Report_Page()
Dim rpt As Report, lngColor As Long
Dim i As Integer
Set rpt = Reports!送货单
rpt.ScaleMode = 7
rpt.Line (3.783, 5.097)-(6.998, 11.521), lngColor, B
rpt.Line (9.683, 5.097)-(11.797, 11.521), lngColor, B
rpt.Line (13.201, 5.097)-(15.497, 11.521), lngColor, B
rpt.Line (15.495, 5.097)-(18.497, 12.105), lngColor, B
For i = 1 To 12
rpt.Line (0#, 5.097 + (i - 1) * 0.584)-(18.497, 5.097 + i * 0.584), lngColor, B
Next i
End Sub作者: 阿菜 时间: 2003-12-18 15:31
!!