Wednesday, August 23, 2017
Wednesday, August 17, 2016
Wednesday, January 6, 2016
PID.txt Auto Key-in CD Key
Value=Key
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
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
Saturday, April 19, 2014
Excel - MID Function - Mengeluarkan Huruf Terpilih Dalam Cell Excel
DESCRIPTION
The Microsoft Excel MID function extracts a substring from a string (starting at any position).SYNTAX
The syntax for the Microsoft Excel MID function is:MID( text, start_position, number_of_characters )
PARAMETERS OR ARGUMENTS
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.
Sunday, April 6, 2014
Membina Kuiz menggunakan Proprofs dan PDF Flipsnack
http://www.flipsnack.com/
Sunday, March 16, 2014
DLookup MsAccess
Getting a value from a table: DLookup()
Look up the _____ field, from the _____ table, where the record is _____
- you have a CompanyID such as 874, and want to print the company name on a report;
- you have Category such as "C", and need to show what this category means.
- you have StudentID such as "JoneFr", and need the student?s full name on a form.
Example 1:
=DLookup("CompanyName", "Company", "CompanyID = 874")
=DLookup("CompanyName", "Company", "CompanyID = " & [CompanyID])
=DLookup("CompanyName", "Company", "CompanyID = " & Nz([CompanyID],0))
Example 2:
=DLookup("CategoryName", "Cat", "Category = 'C'")
=DLookup("CategoryName", "Cat", "Category = '" & [Category] & "'")
Example 3:
=DLookup("[FirstName] & ' ' & [Surname]", "Student", "StudentID = '" & [StudentID] & "'")
Quotes inside quotes
ELookup()
Wednesday, December 18, 2013
Merging Many .VCF Files In One File & Convert To CSV
These are the days of faster upgrade of mobile devices and we are changing mobile handsets more frequently. now when you want to transfer your contact numbers from old mobile to new one, there are many problems we come across, like different mobile manufacturing companies use different file formats, different type of backups and various computer sync software.
3. Run this command
copy /B *.vcf all_in_one.vcf
CSC is the most commonly used data management format. Its Comma Separated Value file. You can use simple office excel to edit the file.
Tuesday, November 5, 2013
All the folder in my Drive become shortcut
Click on "Start" -->Run-->type cmd and click on OK.
Here I assume your pendrive as G:
Enter this command.
attrib -h -r -s /s /d g:\*.*
Note : Replace the letter g with your flash drive letter.
Now check for your files in Pen Drive.
After that, download the Malwarebytes' Anti-Malware from the below link
http://en.kioskea.net/download/download-105-malwarebytes-anti-malware
Update it --> Perform "Full Scan"
Note : Default selected option is "Quick Scan".
Good Luck.
Wednesday, September 25, 2013
Monday, September 2, 2013
Membuang File Yang Tidak Digunakan Serta Melajukan Komputer Anda
Thursday, August 1, 2013
Masalah URL New Tab dalam Firefox
Chosen solution
I have a solution after finding zero help online, i decided to do it myself and found it was profoundly easy.type in "about:config" in the url
accept "ill be careful i promise"
type in "new tab browser"
find the delta search bogus garbage and double click the url link.
replace it with what ever you like, google, yahoo, about:blank, after that everything should be the way it was.
Thursday, May 9, 2013
Thursday, September 6, 2012
Updating CCcam Server
Network Local Setting > ok
CCcam Client Setup > ok
Manage Config Files > ok
CCcam.cfg > ok
Add > (blue button)
Protocol : CCcam
Host : tv3.kongsi.asia
Port : 8073
User : (Call your introducer)
Pwd : (Call your introducer)
Active > (green button)
Exit > sampai habis
Restart Device anda....
Tuesday, July 10, 2012
Make a bootable disk
Open An Elevated Command Prompt
Click Start -> All Programs -> Accessories and right-click on Command Prompt. Select Run As Administrator. Of course, you need to be able to authenticate as the administrator on the PC you’re using.Partitioning The Disk
Type:DISKPART
This will open up the partitioning application. Next, type:
LIST DISKFigure out which of the drives listed is your USB drive, and note the number. It’s crucial you get this right, or you’re going to end up losing data on other drives.
Next, type the following series of commands, but replace the DISK number in the first line with the appropriate number from the above list. Here, my disk is number 1. Don’t confuse this with PARTITION 1. That number should not change, even if your disk is 3.
SELECT DISK 1 CLEAN CREATE PARTITION PRIMARY SELECT PARTITION 1 ACTIVE FORMAT FS=NTFS ASSIGN EXIT
Make It Bootable!
The format step may take a little while (it actually took about 30 minutes on my machine). When you’re done, put in your installation DVD if you haven’t already. Note down which drive letter your USB disk and Windows installation DVD are located at.Go back to your command prompt and type – assuming D: is your DVD drive with the install DVD, and U: is your USB drive:
D:/BOOT/BOOTSECT.EXE /NT60 U:This will basically make your USB drive bootable.
Copy Everything
The final step can be done from My Computer. Just open up the installation DVD, highlight everything, and drag it over to your USB drive.This will also take a while.
Now you should be all set – just insert the USB disk into your new PC, and enter the BIOS to adjust the boot order, or choose the option during start up which says Choose Boot Device.
Thursday, January 26, 2012
How To Block Internet Download Manager Automatic Updates
1 | HKEY_CURRENT_USER\Software\DownloadManager |
and then change the “LastCheck” and/or “LastTry” value to something like e.g.:
1 | [10/22/15] |
Then restart your computer and you will no longer be nagged!
I have always hated how Internet Download Managers developers have forced the “automatic update” us all of its users.
As well as sending sensitive (serial / license checking) data back to their servers, it also nags you to update!
If you want to put an end to this invasion of privacy, all you need to do it is simply add the following to your host file:
174.133.70.198 localhost
174.133.70.98 localhost
star.tonec.com localhost
You can edit your host file you a utility such as BarevTM Host File Editor
Or you can setup your firewall to block this IP on ALL ports: 174.133.70.198 AND 174.133.70.98 AND this Host: star.tonec.com


.jpg)
