2021-12-10

Fix blank screen for users on Windows 10

Open Services with elevated privileges and disable the App Readiness service

Restart required

2021-12-02

Color line if condition meet in Excel

To color a line if a cell has a specified value go to:

  • Conditional Formatting
  • New Rule
  • Use a formula to determinate witch cells to format
    • Format values where this formula is true
      • select the cell with the desired value and enter the condition
      • select the formatting you want (background color)
      • select the whole table

Example:
We have a table with column A to Z and we want to color each row if the cell from column S has the value "Shipped"
Formula should be: =$S1="Shipped" and Applies to =$A:$Z

2021-11-15

Fix Sentinel HASP error "hardlock.sys" file (null) processing error ... Status Code 12 4 2217 31

 Fix Sentinel HASP error:

"hardlock.sys" file (null) processing error. this is an internal error. For assistance contact your administrator or the software manufacturer.

Status Code 12 4 2217 31

Open registry editor

go to HKLM\SYSTEM\CurrentControlSet\Services\Hardlock

set Start=4

2021-07-27

How to search for special characters in files or folders from Windows Explorer

If you want to find a special character in a filename or folder go to the searchbox and type:

~="@"

This will find any file or folder containing the @ character

2021-04-12

Change wireless network priority from command line

Open a command prompt and enter:

netsh wlan set profileorder name="NetworkName" interface="Wi-Fi" priority=1

Delete network profile / wifi connection from command prompt

Open a command prompt and run the following command:

netsh wlan delete profile name=SSID

If you get the following error:

You do not have sufficient privileges or the profile "YourProfile" on interface "wifi" is a group policy profile.
then try this:
  • stop the WlanSvc service (WLAN AutoConfig)
  • delete all files in the \Windows\wlansvc\Policies folder
  • try again to delete the profile
    • netsh wlan delete profile name=SSID
  • restart the WlanSvc service

2021-02-15

Inkscape save default document properties

  • create a new document
  • go to Document Properties and adjust your settings
  • save as default.svg in %userprofile%\AppData\Roaming\inkscape\templates

2021-01-19

Add a network printer & Set a default printer in VBScript

Set WshNetwork = WScript.CreateObject("WScript.Network")
WSHNetwork.AddWindowsPrinterConnection "\\ServerName\PrinterName"
WSHNetwork.SetDefaultPrinter "\\ServerName\PrinterName"

Open Devices & Printers in VBScript

CreateObject("WScript.Shell").Run "control.exe /name Microsoft.DevicesAndPrinters"

2021-01-04

Disable ask for password after sleep

Windows 10:

Go to Settings > Accounts > Sign-in Options > Require sign-in and select Never

2021-01-02

Fix Windows time synchronization

Open command prompt and run:
w32tm /debug /disable
w32tm /unregister
w32tm /register
net start w32time

Windows Error Reporting folder location

The Windows Error Reporting folder location can be found here:

%LOCALAPPDATA%\Microsoft\Windows\WER

All files inside this folder can be deleted

fix GRUB missing in Windows/Linux dual-boot

Open a command prompt with elevated rights (run as admin) and run:

bcdedit /set {bootmgr} path \EFI\ubuntu\grubx64.efi

To restore to previous settings run:

bcdedit /deletevalue {bootmgr} path \EFI\ubuntu\grubx64.efi delete grub boot

bcdedit /set {bootmgr} path \EFI\Microsoft\Boot\bootmgfw.efi set windows boot

List installed printers from command line / PowerShell

Open a command prompt and run:

wmic printer list brief

Open PowerShell and run:

Get-Printer | Format-List list printers with details

Get-Printer | Format-List Name list printers names

Change IP / DNS / Gateway from command prompt

To change the IP:

netsh int ip set address "local area connection" static 192.168.0.1

To change the DNS:

netsh int ip set dns "local area connection" static 192.168.0.255 primary