MG's Notes

Iif you must do this, here’s how:

1. Press the Windows key + R on your keyboard to launch the “Run” dialog box.
2. Type in control userpasswords2
3. Press Enter. The User Accounts window will display.
4. Uncheck the option “Users must enter a user name and password to use this computer”
5. Click “OK”  or “Apply”
6. You will then be prompted to enter the current password and confirm it.
7. After doing so, you will no longer be prompted to enter your password upon login.

written by MG \\ tags: login, users, Windows

In Microsoft Excel, it is possible to combine, or concatenate, different cells of data into one cell. This article contains two examples.

Simple Concatenation

The following formula combines data from cells A1, B1 and C1. Write this formula into another column, such as column D1:

written by MG \\ tags: excel, Windows

To create a compiled list of unique records, follow these steps:

1. Select the column titles above rows or records that you want to sort.
2. On the Data menu, point to Filter, and then click Advanced Filter. If you are prompted as follows, click OK.
   No headers detected. Assume top row of selection is header row?
3. Under Action, click Copy to another location.
4. Click to select the Unique records only check box.
5. In the List range box, type or select the range of records (such as A3:H10).
6. In the Criteria range box, type or select the same range of records (that is, A3:H10)
7. In the Copy to box, type the address of or select the first cell where you want the information to be placed. Make sure there is enough room so you don’t overwrite pre-existing data.

   Note You can only do this in the active sheet.

8. Click OK.

written by MG \\ tags: excel, Windows

 OpenVPN+GUI (openvpn-2.0.9-gui-1.0.3) in client mode will connect to the remote OpenVPN server, but will not accept the routes. Error in the log is as follows:

ROUTE: route addition failed using CreateIpForwardEntry: One or more arguments are not correct. [if_index=18]
Route addition via IPAPI failed

Solution:

add the following to the end of the configuration (ovpn) file:

route-method exe
route-delay 2

written by MG \\ tags: openvpn, Windows

Delete key:  HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Curr entVersion\Explorer\VolumeCaches\Compress old files

like this http://marti.dimerge.net/blog/2008/08/20/remove-compress-old-files-feature

written by MG \\ tags: compress, Windows

Start->Run->CMD

CHKNTFS/T:3
where 3 is the amount of wait time in seconds

written by MG \\ tags: chkntfs, time, Windows

Click on the start button and select run. Then type in “osk” in the box and click OK.

written by MG \\ tags: Windows