Enable Wifi dan Disable Wifi Pada Windows 7

Hari ini ada telepon dari Client, dia bilang koneksi internet hilang, saya perjelas lagi maksudnya katanya informasi internet yang dekat jam hilang, karena klien pakai laptop dan wifi, saya asumsikan wifinya telah mati atau disable, entah kenapa mungkin faktor tidak disengaja. ternyata benar saja setelah saya kasih solusi dibawah ini, akhirnya hidup kembali.
Berikut ini langkah yang klien lakukan.

Langkah untuk Menghidupkan (enabled) Wifi dan Mematikan (Disabled) Wifi Pada Laptop atau PC Windows 7:

1. Pilih Sart Menu, kemudian Pilih Control Panel

2. Setelah itu Pilih Network and Internet, kemudian pilih Networking and Sharing Centre

 

3. Lihat pada sisi sebelah kiri, ada menu pilih Change adapter settings.

 

4. Kemudian Pilih icon Wireless Network Connection, Klik Kanan dan pilih Enable

 

Register and Unregister File OCX

How to register OCX's File :
Go to command prompt, make sure your access as administrator :

Type this script Register:
Format  regsvr32 path file
regsvr32 File.ocx (make sure file already exist)


Type this script unRegister:
Format  regsvr32 u/ path file
regsvr32 /u File.ocx

ERROR: function dblink_connect(unknown) does not exist

PostgreSQL Link from another database

Activate function DBlink :

CREATE EXTENSION dblink;

---

Connection Link Query :

 select dblink_connect('host=servername user=username password=password dbname=databasename')  ;

Result :
OK

---

Select from another database Query :

SELECT *
    FROM dblink('host=servername user=username password=password dbname=databasename', 'select column1, column2 from TableProductMaster ')
      AS t1(Column1 text, Column2 text) -- as field and field type
    WHERE column1 LIKE '%556%'  -- as Condition
    Order by Column1 Asc;


Result :
Column 1    | Column2
A|1
B|2
C|3


Thank You

Registry REGEDIT Run Command URL Link

Registry For File Explorer when you run in command run :

HKEY_CURRENT_USER>>Software>>Microsoft>>Windows>>CurrentVersion\Explorer\TypedPaths

Then

Choose your URL, you can be modified and update even delete it as you want !

Crystal Report : Format Numbering Decimal

Crystal Report: Formatting the Decimal Field

Even though I am currently working in SharePoint I still have a fond of working in crystal reports. Recently in the MSDN forums I saw a requirement in Crystal Report forums section. The requirement is that there is a decimal type column in the SQL Server Database as Shown below.

When we connect the DB in the crystal report, we got the output like this.

But the output should show something like; if the Decimal Field value has no decimal value then it should show as integer without decimal places. If the Decimal Field value contains some decimal value data then it should be left as it is.

 

Solution:
In the Crystal Report, Right Click the Decimal Field we have placed in the Detail section and select Format Object.

In the Format Editor window select Custom Style under Style and click Customize button.

 In the opening popup window select Number tab and click the Formula Editor Button next to Decimals:

 Enter the formula as shown.

 Click Save and Close in the Formula editor and click Ok in Custom Style window

 

Now the Output in the Crystal Report is come as Expected.

 

Good Lucks!!!

Multi Chat ID YM (Multi login Yahoo Messenger )

How to chat multi ID Yahoo Messenger (Yahoo Messenger Multi login). Today we will try to use a free software (freeware yahoo messenger tweaking). This software can perform some configuration on IM applications so that we can open more than one Yahoo Messenger application simultaneously in a same computer, so can chat on ym with multi login using the Yahoo ID from a different email.

There are several configuration options that are available on the software Yahoo Messenger Tweaker:
1. Enable multiple instances, to enable multiple applications can be opened simultaneously YM (yahoo messenger, multi-tasking), check this option if you want to use Multi ID Yahoo messenger
2. Remove Ads, can eliminate the ads or ads on Yahoo Messenger
3. Enable tabs, can activate Tab YM
4. Fix (can not see what I type), can be used to improve the writing on the chat bar user to be able to appear, sometimes because of the conflict or software compatibility problems when the text chat does not appear, you can use this feature to display the article in the chat window
5. Save password for ID, useful store passwords and Yahoo Messenger
6. Rename titlebar, change the title titlebar
7. Change login animation, animated images change login YM
8. Clear status messages, clear the status messages

To be able to login with multiple ID in Yahoo Messenger, check the Enable multiple instances then the Apply button. If successful then you can open more than apilkasi Yahoo Messenger simultaneously. So can chat multi ID YM software can work on Yahoo messenger version 8, 9, 10.

Remote Computer to Shut Down

Open Run >> CMD
in the Command Prompt you can write this code :

shutdown -s -m \\ip -t 0 -f

If you see this message :
The result is "Access is denied".
there maybe exist some problems in the computer. cek another computer to testing remote to shut down.

Change Regional EN-US Setting in VB.NET

Here Simple Code to implementation to change our regional setting

Dim TmpDateFormat As System.Globalization.CultureInfo
TmpDateFormat = New System.Globalization.CultureInfo("en-US")
TmpDateFormat.DateTimeFormat.ShortDatePattern = "M/d/yyyy"
TmpDateFormat.DateTimeFormat.ShortTimePattern = "h:mm tt"
TmpDateFormat.DateTimeFormat.FullDateTimePattern = "dddd, MMMM dd, yyyy h:mm:ss tt"
TmpDateFormat.NumberFormat.CurrencySymbol = "$"
TmpDateFormat.NumberFormat.CurrencyDecimalSeparator() = "."
TmpDateFormat.NumberFormat.CurrencyGroupSeparator() = ","