2008-Aug-12 - How to ... (Windows applications)
1. How to migrate your codes to support Unicode:
1) Add: #include 〈tchar.h〉
2) char -> TCHAR
3) "text string" -> TEXT("text string")
4) Use CharNext & CharPrev instead of ++ & --
2. In MS Excel, how to freeze the row/column header, or split the views of a sheet:
1) Window -> Split
2) Window -> Freeze Panes
3. In MS Excel, how to add a filter button next to the row header:
1) Highlight the whole header row.
2) Data -> Filter -> AutoFilter
4. In Exchange server, how to forward mail to another mail server:
1) Open Exchange System Manager.
2) Administrator Groups -> First Administrator Group -> Routing Groups -> First Routing Group -> Connectors -> New -> Routing Group Connector
5. How to encrypt a folder in Windows system:
The folder Properties -> General -> Advanced -> Encrypt contents to ...
6. How to use FTP proxy while browsing in IE:
1) Internet Options -> Advanced: Disable folder view for FTP.
2) Set FTP proxy in Internet Options -> Connection.
7. In Outlook, how to insert a mark before every comment you make:
Tools -> Options -> E-mail Options -> Mark my comments with
8. In Outlook, how to add voting buttons to your mail:
New a message. Open Options. Find Use voting buttons.
9. How to create a new LAN with VM:
1) VM settings -> Hardware -> Ethernet: select Host-only or NAT for Network Connection.
2) Set VM Default Gateway to the host VM NAC IP.
10. How to install perl module in Windows:
> If the downloaded file is .tar.gz. For example, you can get these types of files from http://search.cpan.org/
1) Extract the archive.
2) Read the Readme file for how to install the module. Usually it includes the following steps:
perl MakeFile.pl
nmake
nmake test
nmake install
Note: Download and install nmake first.
> If the downloaded file is .ppd / .tgz. For example, you can get these types of files from http://ppm.activestate.com/PPMPackages/zips
1) Open command window, and run:
ppm install C:＼pathtomodule.ppd
11. In C/S environment, how does client renew server ip - hostname info:
Run command: nbtstat -R
Example, server has changed IP. After running this command, client can successfully ping server hostname again.
12. How to enable/disable UAC in VISTA:
1. Launch Local Security Policy. (Tips: type "sec" in Run editbox, it will automatically list the program names.)
2. Open Security Settings -> Local Policies -> Security Options -> UAC.
13. How to reboot system by command:
shutdown -r -t 0
14. How to install Active Directory on Windows Server:
Run command: dcpromo
15. How to configure SQL 2005 to accept SQL Authentication:
1) Right-click on the server node and select 'Properties'.
2) Select 'Security' from the left menu under 'Select a page'.
3) Under 'Server Authentication', select the 'SQL Server and Windows Authentication mode option'.
4) Click 'OK' to close the dialog.
5) Right click on the server node and choose 'Restart' for the changes to take affect.
Enable SQL Server login
1) In the server node expand 'Security' and 'Logins'.
2) Right click on the login name and select 'Properties'.
3) Enter a password and confirm the password for the login.
4) Select 'Status' from the left menu under 'Select a page'.
5) Set the 'Login' option to 'Enabled'.
6) Click 'OK' to close the dialog.
Cited from http://kbase.gfi.com/showarticle.asp?id=KBID002804
16. How to hide partition:
1) Run Regedit.
2) Under [HKEY_CURRENT_USER]-->[Software]-->[Microsoft]-->[Windows]-->[CurrentVersion]-->[Policies]-->[Explorer], add a DWORD value [NoDrives], and set the decimal value as follows: set [1] to hide partition A, set [2] (A double) to hide partition B, set [4] (B double) to hide partition C, etc. Set [67108863] to hide all.
3) Under [HKEY_LOCAL_MACHINE]-->[Software]-->[Microsoft]-->[Windows]-->[CurrentVersion]-->[Policies]-->[Explorer], add a DWORD value [NoDrives], and set the decimal value as follows: set [1] to hide partition A, set [2] (A double) to hide partition B, set [4] (B double) to hide partition C, etc. Set [67108863] to hide all.
| 