Wednesday, August 17, 2016

Repair Netbook 1 Malaysia

Wednesday, January 6, 2016

PID.txt Auto Key-in CD Key

Open up notepad and type in the following:
Where key is your retail key in the form xxxxx-xxxxx-xxxxx-xxxxx-xxxxx or the generic keys above.
Save Notepad to PID.txt in Folder Sources

Saturday, September 5, 2015

Tuesday, June 9, 2015

UPPER Case MS Access

Private Sub DHM_AfterUpdate()
' Semua Huruf Jadi Besar
Me!DHM = StrConv(Me!DHM, vbUpperCase)
End Sub

Monday, May 11, 2015

Mengira Umur Mengguna No IC menggunakan MS Access

=DateDiff("yyyy", [TarikhLahir], Date())

expr1: Mid$([textdate],2,6)

expr2: DateSerial(Left([expr1],2),Mid([expr1],3,2),Right([expr1],2))

expr3: Format([expr2],"yyyy\.mm\.dd")

Wednesday, April 23, 2014

Melayu to Jawi

Saturday, April 19, 2014

Excel - MID Function - Mengeluarkan Huruf Terpilih Dalam Cell Excel


The Microsoft Excel MID function extracts a substring from a string (starting at any position).


The syntax for the Microsoft Excel MID function is:
MID( text, start_position, number_of_characters )


text is the string that you wish to extract from.
start_position indicates the position in the string that you will begin extracting from. The first position in the string is 1.
number_of_characters indicates the number of characters that you wish to extract.
Extract a Substring in Excel