Trims Mas MBA itu bisa diterapkan, lalu bagaimana lagi jika page lebih dari 1 setiap kita hendak mau printout yg hal. lebih dari satu, apa kita harus buka design dulu dan set lagi...
Salam MA ----- Original Message ----- From: MBA To: [email protected] Sent: Wednesday, March 24, 2010 10:39 PM Subject: RE: [belajar-access] Re: Page Report Bapak, Ini ada contoh menggunakan basis northwind sample. Pada contoh ada 3 box dan 4 line, yang hanya akan muncul di halaman pertama saja. silahkan lihat di report product by category, di sebelah bawah, dibagian page footer. code vbanya sbb: Private Sub PageFooter_Print(Cancel As Integer, PrintCount As Integer) Box20.Visible = Page = 1 Box21.Visible = Page = 1 Box22.Visible = Page = 1 Line23.Visible = Page = 1 Line24.Visible = Page = 1 Line25.Visible = Page = 1 Line26.Visible = Page = 1 End Sub salam hangat dan jabat erat, MBA Salam Hangat dan Jabat Erat, MBA ------------------------------------------------------------------------------ From: [email protected] [mailto:[email protected]] On Behalf Of Maulana Sent: Tuesday, 23 March, 2010 07:57 To: [email protected] Subject: Re: [belajar-access] Re: Page Report Mas End... sudah saya aplikasikan scripnya...tapi tetap masih ada y baik page 1& 2 kotak line kosongnya... mohon di koreksi donk...apa scripnya salah atau say yg ngg mudeng... Private Sub PageFooterSection_Print(Cancel As Integer, PrintCount As Integer) If IsNumeric(GRANDTOTAL_AMT) Then Line153.Visible = True Line124.Visible = True Line120.Visible = True Line149.Visible = True Line238.Visible = True Line125.Visible = True Else Line153.Visible = False Line124.Visible = False Line120.Visible = False Line149.Visible = False Line238.Visible = False Line125.Visible = False End If End Sub Salam ----- Original Message ----- From: Maulana To: [email protected] Sent: Monday, March 22, 2010 5:12 PM Subject: Re: [belajar-access] Re: Page Report Trims Mas End akan saya terapkan ... Salam ----- Original Message ----- From: End To: [email protected] Sent: Monday, March 22, 2010 4:43 PM Subject: [belajar-access] Re: Page Report Bapak Mungkin bisa di dalam on print page footer tersebut bapak tulis kode ini If isnumeric(total) then Nama line.visible=true Else Nama line.visible=false End If Ket : jika total dalam bentuk angka maka garis yg berupa kotak itu akan ditampilkan dan jika total bukan dalam bentuk angka maka akan disembunyikan Semoga bisa membantu bapak.. No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.791 / Virus Database: 271.1.1/2766 - Release Date: 03/24/10 14:33:00
