For those that have problems with the key that open the console command in game, and it's won't works at all, I will let here some tips...
First of all... If you have this kind of problem then it look's like your Windows have some IR device that's 'conflicting' with your Keyboard. such as any kind of infrared controller/receiver plugged in (For the Media center), Just try removing the device. You can also do this via the Device Manager. These devices sometimes conflict with few of the Keyboard keys / mouses.
Just disable or remove this device... DONE!
Also try this method which I'm giving. It should work on windows XP, VISTA, 7, 8 & 10
Open the Registry Editor (Go to Start and Type "regedit" in the search box.)
When the regedit is open do navigate to the path: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\i8042prt\Parameters
Find an entry named 'OverrideKeyboardSubtype' with REG_DWORD as the type. The value should be 2, change it to 0. Now try to open the console. You can also reboot your system.
Good Luck!