Membuat denah rumah dan miniatur ruangannya
http://www.sweethome3d.eu/index.jsp
Tuesday, December 8, 2009
Thursday, December 3, 2009
Create Icon midlet - screen size
how to create icon midlet?
http://devlinslab.blogspot.com/2007/10/adding-icon-to-your-midlet-or-game.html
http://devlinslab.blogspot.com/2007/10/adding-icon-to-your-midlet-or-game.html
Create Icon or thumbnail Java ME using Netbeans
How do I specify a MIDlet icon?
If you are creating a new MIDlet, you can specify the icon when using the New File wizard (File > New File). If you have already created a MIDlet, open project properties (File > YourProjectName Properties) and select 'Application Descriptor > MIDlets', then select the MIDlet in right pane and push the 'Edit ...' button.
If you are creating a new MIDlet, you can specify the icon when using the New File wizard (File > New File). If you have already created a MIDlet, open project properties (File > YourProjectName Properties) and select 'Application Descriptor > MIDlets', then select the MIDlet in right pane and push the 'Edit ...' button.
Wednesday, December 2, 2009
Thursday, November 19, 2009
VBA Macro for Excel 2003 Export of Text File with Comma and Quote Delimiters.
VBA Macro for Excel 2003 Export of Text File with Comma and Quote Delimiters.
This code is a sample from the MSDN script library at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_xl2003_ta/html/odc_XL_Samples.asp
1. Open a new workbook.
2. On the Tools menu, point to Macro, and then click Visual Basic Editor (or simply press ALT+F11). In the Visual Basic Editor, click the Insert menu and then Module.
3. Type or paste the below sample code into the module.
4. Before running the macro, select the data that you want to export, and then point to Macros on the Tools menu and click Macro.
5. Select the QuoteCommaExport macro, and click Run.
Sample code:
Sub QuoteCommaExport()
Dim DestFile As String
Dim FileNum As Integer
Dim ColumnCount As Integer
Dim RowCount As Integer
' Prompt user for destination file name.
DestFile = InputBox("Enter the destination filename" & _
Chr(10) & "(with complete path and extension):", _
"Quote-Comma Exporter")
' Obtain next free file handle number.
FileNum = FreeFile()
' Turn error checking off.
On Error Resume Next
' Attempt to open destination file for output.
Open DestFile For Output As #FileNum
' If an error occurs report it and end.
If Err <> 0 Then
MsgBox "Cannot open filename " & DestFile
End
End If
' Turn error checking on.
On Error GoTo 0
' Loop for each row in selection.
For RowCount = 1 To Selection.Rows.Count
' Loop for each column in selection.
For ColumnCount = 1 To Selection.Columns.Count
' Write current cell's text to file with quotation marks.
Print #FileNum, """" & Selection.Cells(RowCount, _
ColumnCount).Text & """";
' Check if cell is in last column.
If ColumnCount = Selection.Columns.Count Then
' If so, then write a blank line.
Print #FileNum,
Else
' Otherwise, write a comma.
Print #FileNum, ",";
End If
' Start next iteration of ColumnCount loop.
Next ColumnCount
' Start next iteration of RowCount loop.
Next RowCount
' Close destination file.
Close #FileNum
End Sub
This code is a sample from the MSDN script library at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_xl2003_ta/html/odc_XL_Samples.asp
1. Open a new workbook.
2. On the Tools menu, point to Macro, and then click Visual Basic Editor (or simply press ALT+F11). In the Visual Basic Editor, click the Insert menu and then Module.
3. Type or paste the below sample code into the module.
4. Before running the macro, select the data that you want to export, and then point to Macros on the Tools menu and click Macro.
5. Select the QuoteCommaExport macro, and click Run.
Sample code:
Sub QuoteCommaExport()
Dim DestFile As String
Dim FileNum As Integer
Dim ColumnCount As Integer
Dim RowCount As Integer
' Prompt user for destination file name.
DestFile = InputBox("Enter the destination filename" & _
Chr(10) & "(with complete path and extension):", _
"Quote-Comma Exporter")
' Obtain next free file handle number.
FileNum = FreeFile()
' Turn error checking off.
On Error Resume Next
' Attempt to open destination file for output.
Open DestFile For Output As #FileNum
' If an error occurs report it and end.
If Err <> 0 Then
MsgBox "Cannot open filename " & DestFile
End
End If
' Turn error checking on.
On Error GoTo 0
' Loop for each row in selection.
For RowCount = 1 To Selection.Rows.Count
' Loop for each column in selection.
For ColumnCount = 1 To Selection.Columns.Count
' Write current cell's text to file with quotation marks.
Print #FileNum, """" & Selection.Cells(RowCount, _
ColumnCount).Text & """";
' Check if cell is in last column.
If ColumnCount = Selection.Columns.Count Then
' If so, then write a blank line.
Print #FileNum,
Else
' Otherwise, write a comma.
Print #FileNum, ",";
End If
' Start next iteration of ColumnCount loop.
Next ColumnCount
' Start next iteration of RowCount loop.
Next RowCount
' Close destination file.
Close #FileNum
End Sub
Tuesday, November 17, 2009
Bagaimana uninstall the Apache 2.x Web server pada Windows platforms?
How to uninstall the Apache 2.x Web server on the Windows platforms?
Prosedure
- Untuk uninstall Apache sebagai service, buka Command Prompt window.
- Buka pada Apache installation directory, or wherever apache.exe is located. For Example, C:\Program Files\Apache Group\Apache2\bin.
- Dengan command prompt, ketik 'apache -k uninstall' - tanpa quotes
- Lihat Windows Services and check that Apache2 is no longer listed as a service.
- Klik Add/Remove Programs in the Control Panel, kemudian remove Apache HTTP Server
- Hapus the Apache installation directory in Windows Explorer. For example: C:\Apache.
Thursday, November 12, 2009
Setting FTP pada Windows 2003
Untuk setting FTP pada Windows 2003, klik pada link berikut ini:
http://support.microsoft.com/kb/323384/id-id
di sana terdapat tahapan
http://support.microsoft.com/kb/323384/id-id
di sana terdapat tahapan
- Menambah program FTP server
- Konfigurasi FTP sebelum digunakan
Wednesday, November 11, 2009
Rumus Dalam Visual Basic
Jika ingin memasukkan rumus dalam visual basic, gunakan sintak berikut ini:
ActiveCell.FormulaR1C1 = "=IF(ISNA(MATCH(R1C[-1],MASTERDATA!R[1]C[" & Read_urut_sheet_master & "]:R[200]C[" & Read_urut_sheet_master & "],0)),0,MATCH(R1C[-1],MASTERDATA!R[1]C[" & Read_urut_sheet_master & "]:R[200]C[" & Read_urut_sheet_master & "],0))"
ActiveCell.FormulaR1C1 = "=IF(ISNA(MATCH(R1C[-1],MASTERDATA!R[1]C[" & Read_urut_sheet_master & "]:R[200]C[" & Read_urut_sheet_master & "],0)),0,MATCH(R1C[-1],MASTERDATA!R[1]C[" & Read_urut_sheet_master & "]:R[200]C[" & Read_urut_sheet_master & "],0))"
Wednesday, November 4, 2009
Change Single Column Joomla 1.5 for first Instalation
How to change Two Column to Single Column Joomla 1.5 for first Instalation?
- Login to administrator
- Klik Menus
- Klik Main Menu and choose "Home" on the list of article
- On right side, on column field change "2" to "1"
- Click Save
Tuesday, October 27, 2009
Create Unique List from Data Entry
How to create unique list from data entry in excel?- In Excel, Go to Data > Filter > Advanced Filter
- Choose under Action : Copy to another location
- Select your data entry where you want to create unique in list range
- Choose Copy to in column B
- Check list Unique records only, then click OK
Wednesday, September 2, 2009
Using If ErrorLevel & net start on batch file
@echo off &setlocal
VER | find "NT" > nul
IF not errorlevel 1 GOTO :s_win_NT
VER | find "2000" > nul
IF not errorlevel 1 GOTO :s_win_2000
VER | find "98" > nul
IF not errorlevel 1 GOTO :s_win_98
VER | find "ME" > nul
IF not errorlevel 1 GOTO :s_win_ME
VER | find "95" > nul
IF not errorlevel 1 GOTO :s_win_95
GOTO :s_unknown_os
:s_win_NT
echo This computer uses Windows NT Operating System
net start "InterBase Server"
goto :bye
:s_win_2000
echo This computer uses Windows 2000 Operating System
net start "InterBase Server"
goto :bye
:s_win_98
echo This computer uses Windows 98 Operating System
echo Please restart the computer
echo off
rem "C:\Program Files\CDIS Offline\InterBase\bin\IBGuard.exe"
goto :bye
:s_win_95
echo This computer uses Windows 95 Operating System
echo Please restart the computer
echo off
rem "C:\Program Files\CDIS Offline\InterBase\bin\IBGuard.exe"
goto :bye
:s_win_ME
echo This computer uses Windows ME Operating System
goto :bye
:s_unknown_os
echo Unknown Operating System
goto :bye
:bye
VER | find "NT" > nul
IF not errorlevel 1 GOTO :s_win_NT
VER | find "2000" > nul
IF not errorlevel 1 GOTO :s_win_2000
VER | find "98" > nul
IF not errorlevel 1 GOTO :s_win_98
VER | find "ME" > nul
IF not errorlevel 1 GOTO :s_win_ME
VER | find "95" > nul
IF not errorlevel 1 GOTO :s_win_95
GOTO :s_unknown_os
:s_win_NT
echo This computer uses Windows NT Operating System
net start "InterBase Server"
goto :bye
:s_win_2000
echo This computer uses Windows 2000 Operating System
net start "InterBase Server"
goto :bye
:s_win_98
echo This computer uses Windows 98 Operating System
echo Please restart the computer
echo off
rem "C:\Program Files\CDIS Offline\InterBase\bin\IBGuard.exe"
goto :bye
:s_win_95
echo This computer uses Windows 95 Operating System
echo Please restart the computer
echo off
rem "C:\Program Files\CDIS Offline\InterBase\bin\IBGuard.exe"
goto :bye
:s_win_ME
echo This computer uses Windows ME Operating System
goto :bye
:s_unknown_os
echo Unknown Operating System
goto :bye
:bye
Tuesday, July 21, 2009
Excel Can't Right Click
You can reset the right-click menu.
Hit ALT + F11 to go to the VBEditor.
Then View>Immediate Window.
Copy/paste this line into the window and hit
Application.CommandBars("Cell").Enabled = True
OR copy/paste this sub to a module and run it.
Sub reset()
Application.CommandBars("Cell").Enabled = True
End Sub
The Insert and Format not being available could be because the worksheet or
workbook is protected.....I would vote for worksheet.
Tools>Protection>UnProtect Worksheet.
Source:
http://www.wiredbox.net/Forum/Thread327814_i_cannot_use_the_mouse_right_click_in_excel-_how_to_rectify.aspx
Hit ALT + F11 to go to the VBEditor.
Then View>Immediate Window.
Copy/paste this line into the window and hit
Application.CommandBars("Cell").Enabled = True
OR copy/paste this sub to a module and run it.
Sub reset()
Application.CommandBars("Cell").Enabled = True
End Sub
The Insert and Format not being available could be because the worksheet or
workbook is protected.....I would vote for worksheet.
Tools>Protection>UnProtect Worksheet.
Source:
http://www.wiredbox.net/Forum/Thread327814_i_cannot_use_the_mouse_right_click_in_excel-_how_to_rectify.aspx
Monday, June 29, 2009
Menampilkan Huruf pada urutan keterangan tertentu
misalnya pada teks suatu sel di Excel A2 tertulis: Jabatan(NAMA)
Bagaimana agar hanya NAMA-nya saja yang tampil?
Gunakan sintak =FIND("(", A2, 35)
Bagaimana agar hanya NAMA-nya saja yang tampil?
Gunakan sintak =FIND("(", A2, 35)
Wednesday, June 17, 2009
Tuesday, June 16, 2009
Menyisipkan Rumus Index dan Match di VB
Menyisipkan Rumus Index dan Match, gunakan sintaks berikut ini :
Cells(Line, 6).Value = "=INDEX(SOFTWARE.LIST!$A$2:$B$10000,MATCH(E" & Line & ",SOFTWARE.LIST!$A$2:$A$10000,0),2)"
Cells(Line, 6).Value = "=INDEX(SOFTWARE.LIST!$A$2:$B$10000,MATCH(E" & Line & ",SOFTWARE.LIST!$A$2:$A$10000,0),2)"
Monday, June 15, 2009
Melihat PID command DOS
Perintah yang hanya berfungsi pada Windows XP, gunakan perintah berikut
C:\tasklist
Untuk referensi yang lain, silakan kunjungi
http://www.infocellar.com/winxp/DOS-with-XP.htm
http://www.networkclue.com/os/Windows/commands/
C:\tasklist
Untuk referensi yang lain, silakan kunjungi
http://www.infocellar.com/winxp/DOS-with-XP.htm
http://www.networkclue.com/os/Windows/commands/
Subscribe to:
Posts (Atom)