R
Rashid Khan
Hello All,
I have used the Order Entry template in Access 2002. I have following
problems in the Invoice Report.
1) I want to have vertical lines only in the Detail Section. I have copied
the following code and it works fine but it does not draw the line at the
left and the right edge of the report. How can I draw lines at the left and
right edge of the report with the following code?
Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
Dim CtlDetail As Control
Dim intLineMargin As Integer
intLineMargin = 0
Me.Line ((SR.Left + SR.Width + intLineMargin), 0)-(SR.Left + SR.Width +
intLineMargin, Me.Height)
Me.Line ((Pcs.Left + Pcs.Width + intLineMargin), 0)-(Pcs.Left + Pcs.Width +
intLineMargin, Me.Height)
Me.Line ((ProductName.Left + ProductName.Width + intLineMargin),
0)-(ProductName.Left + ProductName.Width + intLineMargin, Me.Height)
Me.Line ((Quantity.Left + Quantity.Width + intLineMargin), 0)-(Quantity.Left
+ Quantity.Width + intLineMargin, Me.Height)
Me.Line ((UnitPrice.Left + UnitPrice.Width + intLineMargin),
0)-(UnitPrice.Left + UnitPrice.Width + intLineMargin, Me.Height)
Me.Line ((Per.Left + Per.Width + intLineMargin), 0)-(Per.Left + Per.Width +
intLineMargin, Me.Height)
'Me.Line ((LineTotal.Left + LineTotal.Width + intLineMargin),
0)-(LineTotal.Left + _
'LineTotal.Width + intLineMargin, Me.Height)
Set CtlDetail = Nothing
End Sub
2) The Lines Drawn by the above code in the Detail Section is shorter in
other words it does not extends upto the Page Footer. How can I achieve
this? How can I have a fix size Detail Section... I tried to make the size
big but then it gives big spacing between each Item on the invoice :-(
3) I want to move the Subtotal, Sales Tax and Total Due (all these 3 are in
Order_ Id_Footer to just above the Page Footer but it always shows a big gap
between the detail section and the Page Footer.. How can this be rectified?
I moved the Subtotal, Sales Tax and Total Due to the Page Footer section,
then it does not calculate :-(.
Any help with regards to the above problem would be greatly appreciated
TIA
Rashid Khan
I have used the Order Entry template in Access 2002. I have following
problems in the Invoice Report.
1) I want to have vertical lines only in the Detail Section. I have copied
the following code and it works fine but it does not draw the line at the
left and the right edge of the report. How can I draw lines at the left and
right edge of the report with the following code?
Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
Dim CtlDetail As Control
Dim intLineMargin As Integer
intLineMargin = 0
Me.Line ((SR.Left + SR.Width + intLineMargin), 0)-(SR.Left + SR.Width +
intLineMargin, Me.Height)
Me.Line ((Pcs.Left + Pcs.Width + intLineMargin), 0)-(Pcs.Left + Pcs.Width +
intLineMargin, Me.Height)
Me.Line ((ProductName.Left + ProductName.Width + intLineMargin),
0)-(ProductName.Left + ProductName.Width + intLineMargin, Me.Height)
Me.Line ((Quantity.Left + Quantity.Width + intLineMargin), 0)-(Quantity.Left
+ Quantity.Width + intLineMargin, Me.Height)
Me.Line ((UnitPrice.Left + UnitPrice.Width + intLineMargin),
0)-(UnitPrice.Left + UnitPrice.Width + intLineMargin, Me.Height)
Me.Line ((Per.Left + Per.Width + intLineMargin), 0)-(Per.Left + Per.Width +
intLineMargin, Me.Height)
'Me.Line ((LineTotal.Left + LineTotal.Width + intLineMargin),
0)-(LineTotal.Left + _
'LineTotal.Width + intLineMargin, Me.Height)
Set CtlDetail = Nothing
End Sub
2) The Lines Drawn by the above code in the Detail Section is shorter in
other words it does not extends upto the Page Footer. How can I achieve
this? How can I have a fix size Detail Section... I tried to make the size
big but then it gives big spacing between each Item on the invoice :-(
3) I want to move the Subtotal, Sales Tax and Total Due (all these 3 are in
Order_ Id_Footer to just above the Page Footer but it always shows a big gap
between the detail section and the Page Footer.. How can this be rectified?
I moved the Subtotal, Sales Tax and Total Due to the Page Footer section,
then it does not calculate :-(.
Any help with regards to the above problem would be greatly appreciated
TIA
Rashid Khan