Recent content by Akai90

when i double click the listbox nothing happen... i want.. when i double click selected data in list box.. some value will change to this.. .Edit !KodInstitusi = " " !JenisInstitusi = " " !Alamat = " " !Institusi = " " !status = "BERHENTI" .Update

hai, i got some issue with listbox double click my code here Private Sub listgurufilterips_DblClick(Cancel As Integer) Dim MyDB As Database, MyTable As Recordset Dim JWBCONFIRM As String Set MyDB = DBEngine.Workspaces(0).Databases(0) Set MyTable = MyDB.OpenRecordset("TGuruIPS"...

its wroking tq...

it show like this

i have 2 value to show on single textbox if null 1. PsPortGuru 2. NoKP i using query to combine 2 value if one of that null my query is compass: Nz([PsPortGuru];[NoKP]) on report i use "compass" now my problem is for NoKP i want to show input mask 999999\-99\-9999;;_ by using this...

hi again Private Sub NoPermit_GotFocus() NoPermit = "XXXX/xxx/xxx/xxx." & tahundaftar & "/" & noidtext & "" End Sub above my code noidtext = this item i use format "0000" on noidtext on left i want using 0003 how can i get 0003 thaks

Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As Integer) Me.PageFooterSection.Visible = (Me.[Page] = 1) End Sub problem solved remove above code use only Private Sub PageFooterSection_Print(Cancel As Integer, PrintCount As Integer) Me.PageFooterSection.Visible =...

for print preview it work... when i hit print button no value on "PageFooterSection" print

hi, i have some text in footer section but i want to show only page 1 and hide on page 2 on print preview it got like what i want but when print the report on footer text not show anything.. the code i use Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As Integer)...

hi in report, how to hide table gridlines if no value check the picture thanks

hai this is my current code for report access ="RM " & Format([YURANPROG1];"Standard") & " " & [yrnsujek1] &"" output : RM 50.00 / subjek yuranprog1 = 50.00 subjek = / subjek how can i hide "RM" if yuranprog1 and yrnsujek1 is empty or null on report thanks

PROBLEM SOLVED BY USING SQL comkp: Nz([NOKP];[PSPORT])

="Ini adalah memperakui bahawa <b>" & [namapp] & " ( " & Nz([NOKP], [PSPORT]) & " )</b> telah disertakan." GOT SYNTAX ERROR

="Ini adalah memperakui bahawa <b>" & [namapp] & " ( " & [NOKP] & " )</b> telah " above is my current code. is there another where if i want replace "NOKP" with another fields "PSPORT" if "NOKP" is null hope you understand

already try this code but.. it will direct print the report. i want open the print preview first to check all data is correct.