ORng1.Value = SQLreader("Total_Sessions_Friday") ![]() ORng1.Value = SQLreader("Total_Sessions_Thursday") ORng1.Value = SQLreader("Total_Wednesday_Cost") ORng1.Value = SQLreader("Total_Sessions_Wednesday") ORng1.Value = SQLreader("Total_Tuesday_Cost") ORng1.Value = SQLreader("Total_Sessions_Tuesday") ORng1.Value = SQLreader("Total_Monday_Cost") ORng1.Value = SQLreader("Total_Sessions_Monday") ORng1.Value = SQLreader("Total_Term_Cost") ORng1.Value = (SQLreader("Bill_Date"),10) ORng1.Value = (SQLreader("Payment_Due_Date"),10) OWB = ("F:\Kids Club Database\Kids Club Database v2\Backup\ContactsDatabase\bin\Debug\Bill.xlsx") SQLcommand.CommandText = "SELECT * FROM Bill_Record WHERE Paid = 'F'" ![]() Sub PrintDocumentPrintPage(sender As Object, e As )ĭim oWB As Excel.Workbook = ()ĭim oWS As Excel.Worksheet = CType(oWB.Worksheets(1), Excel.Worksheet) ![]() 'print document (see Sub PrintDocumentPrintPage below. Got this algorithm in VB.net which manipulates and prints an excel document but every time i print i get an extra sheet of paper BEFORE the document i want to print! No extra pages on the excel sheet or anything like that! Can anyone spot the reason why in this code or does anyone know why? Thanks Sub Cmd_PrintClick(sender As Object, e As EventArgs)
0 Comments
Leave a Reply. |