Apr 07

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: ,

Mar 15

 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: ,

Jan 16

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: ,

Dec 03

Start->Run->CMD

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

written by MG \\ tags: , ,

Jul 01

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

 

written by MG \\ tags:

Jul 01

Go to Start –> Run and type Regedit
Navigate to:

HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Control

Click on the “Control” Folder.
In the right window you will see this key WaitToKillServiceTimeout
Double click that key and set it a value
lower than 2000, we set it to 100. Reboot.

 

 

written by MG \\ tags: , ,

Jul 01

Right click on desktop and select new -> shortcut. Then copy and paste this in the program location box  

“rundll32.exe user32.dll,LockWorkStation”

Click next and enter a name for you shortcut and then click finish.

Now you can copy and paste that shortcut anywhere you want on your computer.

written by MG \\ tags: , ,