Search results

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

the most importand data is this namasek = [Institusi] kodsek = [KodInstitusi] jensek = [JenisInstitusi] i am copy because it use same school if open 1 school in form i want to add more teacher, i add new button it will bring same namaschool, schoolkod, schooltype

my issue is add button when i click the add button.. it will ask all required fields. usually when add button it will not ask required right.. it will ask when click the saved data.

for my understand. it will force the empty textbox be fill right ? without enable table fields required ?

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

solved by using if else Private Sub TempohMohon_AfterUpdate() If TempohMohon = "1" Then TarikhTamat = "31 Disember " & Year(TarikhMohon) + IIf(TempohMohon > 1, TempohMohon, IIf(Month(TarikhMohon) < 7, 0, 1)) Else If TempohMohon = "2" Then TarikhTamat = "31 Disember " & Year(TarikhMohon) +...

HI, can u explain this --> IIf(TempohMohon > 1, TempohMohon, IIf(Month(TarikhMohan) < 7, 0, 1)) 0 stand for and 1 stand for what if tempohmohon 2 year --> 5 year for 2 year if TarikhMohon 1 january 2021 - 30 june 2021, with tempohmohon 2 year tarikh tamat will be 31 december 2022 if...

thanks sir it working

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...

ok already did convert part thanks for the support

my date store in table field. so what code for that.. Me.Text0 = FormatDateForLocale(Date, "ms", , "dd MMMM yyyy") this for vba right ? what the code for convert from table field ? and show on report for more important because on report it will print out. thanks

sonic's function ? in access ? never heard about sonic function can you show me example.

tq for reply i new in access, can u please show me simple code for convert data month to malay language thanks

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...

is there any code to convert the hijri calender format ? from 1/3/1433 to Rajab 9, 1443h

yes.. :)

problem solved i use if like this Private Sub JENIS_PERMIT_AfterUpdate() EnableButtons End Sub Private Sub JenisInstitusi_AfterUpdate() EnableButtons End Sub Private Sub Form_Current() EnableButtons End Sub Private Sub EnableButtons() If Me.JenisInstitusi.Value = "TADIKA SWASTA" Then...

code work fine only some value are not working this my code on live access Private Sub JENIS_PERMIT_AfterUpdate() EnableButtons End Sub Private Sub JenisInstitusi_AfterUpdate() EnableButtons End Sub Private Sub Form_Current() EnableButtons End Sub Private Sub EnableButtons()...