Monday, December 20, 2010

Cannot shift objects off sheet

If you find problem when insert column appears: "Cannot shift objects off sheet"
please click button CTRL+End, then delete the column.

Thursday, December 16, 2010

Optimasi Windows XP

Optimasi Windows XP
- Defragmentasi
- Program Start-Up
- Paging File
- Virtual Memory 2000 - 4000 MB
- Desktop Icon
- Scan System
- Unistall Software yang tidak digunakan
- Setting ke Best Performance
- Cek msconfig.exe (Win XP) atau msconfig (XP)
- Service.msc
- Clean Windows Temporary / Browser Temporary
- Registry Recovery

Monday, November 22, 2010

Driver OPTION ICON 7.2 download

Berikut ini adalah kumpulan driver OPTION ICON 7.2 USB Windows dan Mac. driver Option_Icon_7.2_download

Wednesday, November 17, 2010

It is not safe to rely on the system's timezone

It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Asia/Krasnoyarsk' for '7.0/no DST' instead in C:\xampp\htdocs\bookstore\administrator\components\com_virtuemart\classes\ps_main.php on line 880

Answer :
Check php.ini then find
[Date]
; Defines the default timezone used by the date functions
; http://php.net/date.timezone
;date.timezone =
;php_value date.timezone Asia/Krasnoyarsk

date.timezone = "Asia/Krasnoyarsk"

Monday, November 15, 2010

Menghapus Spasi di Excel

Gunakan =TRIM(CELL) untuk menghapus spasi di Excel

Monday, October 11, 2010

Android for Netbeans

How to Install Android - http://kenai.com/projects/nbandroid/pages/Install
Dev. Android using NetBeans - http://en.androidwiki.com/wiki/Developing_Android_aplications_using_NetBeans
http://updates.netbeans.org/netbeans/updates/6.8/uc/final/thirdparty/catalog.xml.gz
http://kenai.com/downloads/nbandroid/updates.xml

How to Install Perl


How to Install Perl :
-------------------
- install perl
- create folder c:\ppmrep
- goto command prompt
- type "ppm" and enter
- type "rep add localrep c:\ppmrep\"
- type "rep"
- take a look at localrep, it should be on the first in list.
- type "rep up localrep" to get the localrep to the first one.
- extract all modules libnet, DBI, DBD-ODBC to c:\ppmrep
- type "search *", you should see three modules there
- type "install libnet"
- type "install DBI"
- type "install DBD-ODBC"
- type "quit"
- type "perl -e 'use DBI'", you should see no message instead of new prompt.
- done.

Wednesday, September 29, 2010

Can't locate ExtUtils/MakeMaker.pm in @INC (@INC contains:

When I install a module, appears syntax like :
Can't locate ExtUtils/MakeMaker.pm in @INC (@INC contains: ...

How to solve?
type in
C:\xampp\perl\bin>cpan -i ExtUtils::MakeMaker

Sunday, June 20, 2010

make_sock: could not bind to port 80

Apache logs error: make_sock: could not bind to port 80
solution : stop the service world wide web apps publishing

Wednesday, June 2, 2010

Maximum Line

maximum_lines = Range("A1").End(xlDown).Row

Tuesday, May 25, 2010

There is insufficient storage to install this suite

Q: Appear Error
There is insufficient storage to install this suite

Solution:
1. Look at file jwc_properties.ini
2. find the line system.jam_space = 1000000
change to 10000000 (7 to 8 digits)

Hope your problem about There is insufficient storage to install this suite
solved

Wednesday, April 14, 2010

Visual Basic Net Send to computer

Sub auto_open()
Shell "net send pc25797 " & Tmp, vbHide
End Sub

Sunday, March 28, 2010

mysqldump: Couldn't execute SHOW TRIGGERS LIKE

I cann't create mysqldump, and error in result
"mysqldump: Couldn't execute SHOW TRIGGERS LIKE"

Q: How to resolve mysqldump: Couldn't execute SHOW TRIGGERS LIKE error can't create/write to file 'C:\WINNT\TEMP'

A: Please access Mcafee VirusScan Console then Disable Access Protection and On-Scanner Access. Right click on properties On-Scanner Access >> All Processess >> Detection >> Exclusions >> write the folder, and check list 'Also exclude subfolders', so you can solving error mysqldump: Couldn't execute SHOW TRIGGERS LIKE error can't create/write to file 'C:\WINNT\TEMP'

Thursday, March 11, 2010

Excel to MySQL

Panduan:
http://www.automateexcel.com/2005/11/01/connect_excel_to_mysql_database/
http://apacheguide.org/myodbc.php

Tools:
download myODBC
http://dev.mysql.com/downloads/mirror.php?id=376347#mirrors

Monday, February 22, 2010

Outlook over 2GB

Outlook 2GB
http://support.microsoft.com/kb/296088

Monday, February 8, 2010

Run J2ME to iphone

http://iphoneroot.com/tutorial-install-java-on-the-iphone/
http://iphoneroot.com/java-for-iphone-iphone-3g-firmware-20-exist/
http://iphoneroot.com/tutorial-compile-and-run-java-application-on-the-iphone/
http://iphoneroot.com/tutorial-install-java-on-the-iphone/
http://blog.elektro.um.ac.id/didik/2010/01/22/iphone-emulator-for-windows/

Monday, February 1, 2010

SSL Checker

https://knowledge.verisign.com/support/ssl-certificates-support/index?page=content&id=AR1130

Setting SSL Apache

1. Copy Certificate, berikut ini menjadi file *.crt

-----BEGIN CERTIFICATE-----
MIIFxjCCBK6gAwIBAgIQL9k9yqnzZKCwLvjfOH0XezANBgkqhkiG9w0BAQUFADCB
+9jXmJstZGB1m5cE7uQg4sDdU8Z4+vjzBq7PWIXlNqDn5NFuGKlZ6pSL
-----END CERTIFICATE-----

2. Buka file httpd-ssl.conf
3. Cari file *.crt
4. Simpan File
5. Restart Apache

Thursday, January 28, 2010

Menampilkan Nama File dan Tab di VB

'Menampilkan Nama File Excel di VB
SheetName = Worksheets.Parent.Name

'Menampilkan Nama Tab Excel di VB
TabName = ActiveSheet.Name

Wednesday, January 27, 2010

How to diagnose Hardware of PC?

run "dxdiag" in command DOS

Tuesday, January 26, 2010

Error Install mtgMigrator Joomla

Q: Your Extension appears to be written for an older version of Joomla!. You must enable the System - Legacy Plugin in the Plugin Manager if you wish to complete this task.

A: Extention >> Plugin Manager
System Legacy --> enable

Monday, January 25, 2010

SMS deleted recovery

http://www.tiaftcolombia.com/tips-phone/recover-deleted-sms-for-nokia-s60.html