Search results

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

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

="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

hai, i have set my auto number format as "00000" so my auto number will be 00001,00002 but on form textbox auto number still use 1, 2, 3 example for wat i want to do TGuruIPS.noid = IS AUTO NUMBER tahundaftar = year output ZXCV/XXX/CC/AAA.2022/00001 ZXCV/XXX/CC/AAA.2022/00002...

hi, forms record will show data when select on listbox When i select data on listbox record will show on forms.

hai i have problem sometime my print preview report will print form not a report. print preview show report but it will print forms not report (sometime will print report but sometime will print forms).. can i know what the problem ? any wrong setting ? report call via button from forms button...

hi. i want to edit and update some field via vba . i write some code but it as some error Private Sub listsemuaguru_DblClick(Cancel As Integer) Me![listgurufilterips].Requery Dim tguru As Integer, RESPON As String Dim MyDB As DAO.Database, MyTable As DAO.Recordset Dim JWBCONFIRM As String...

hi. is there any where to get AGE value from idenfication no my gov id format like this. 980530-04-1233 98 = yy 05 = mm 30 = dd i like to get age no to show on form and report. thanks

hai i have this code.. trktmtsementara = DateAdd("M", tempohsementara, tarikhsementara) how can i set the date format to dd mmmm yyyy i try to set via property sheet but not working my full code

hi, i have button click code get some data when add new record but have some bug when i set all importand fields to Required here the code Private Sub Command41_Click() Dim namasek As String, kodsek As String, jensek As String, nokpp As String, thndaftar As String Dim tablesaya As Recordset...

I am trying to make a textbox get data from selected listbox from query. listbox bound with 4 column & 4 textbox when selected listbox data it will update the textbox data hope you understand

hi there, on my form have fixed exp date "31 december" for year it will +1 year . below is my current code Private Sub TarikhTamat_GotFocus() TarikhTamat = "31 Disember " & Year(TarikhMohon) + TempohMohon End Sub TempohMohon = textbox with number 1 --> 5. 1 equal to 1 year TarikhMohon...

hai, is there any code or format to change my date (dd mmmm yyyy) to malay language without change the region setting on pc ? my pc is control by domain admin, so everytime i change the region setting to malay it will change back to default value. so my option is to control the date...

hi, based on title, i can disable command button if i have only use 1 combobox value. the is like Private Sub Form_Current() If Combo10.Value = "SEMENTARA" Then Me.Command6.Enabled = True Me.Command8.Enabled = True Me.Command9.Enabled = False Me.Command7.Enabled = False Else...

hi, i have report need to calculate how many room have. total room have 18 field, below is the code i use...

hi there, come here to increase my knowledge in ms access coding. thanks for accept me in this community