MS Access ERROR: "The expression On Dbl Click you entered as ... produced the following error ... communicating with OLE server or ActiveX Controls"

Microsoft Access ERROR: "The expression On Dbl Click you entered as the event property setting produced the following error: A problem occoured while ... was communicating with OLE server or ActiveX Controls"

• open Control Panel -> Region and language
• or open command line and run control intl.cpl
• go to Administrative -> Change system locale
• select the language the same as of your Access database

Disable Windows Defender

Method 1:

• open registry editor end edit the following keys
• HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows Defender
• "DisableAntiSpyware"=dword:00000001
• HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows Defender\Real-Time Protection
• "DisableBehaviorMonitoring"=dword:00000001
• "DisableOnAccessProtection"=dword:00000001
• "DisableScanOnRealtimeEnable"=dword:00000001

Note: restart needed

Enable/Disable tabbed conversations in Skype

Go to Tools > Options > IM and uncheck "Enable tabbed conversations"

Rebuild Font cache

1. open services and stop and disable the following services:
1. Windows Font Cache Service
2. Windows Presentation Foundation Font Cache #
2. go to C:\Windows\ServiceProfiles\LocalService\AppData\Local
1. delete the FontCache*.dat
2. open Font Cache folder and delete all files and folders in it
3. restart end enable the services

Stop Command line window to open new window when running a exe / command

Open a command line with elevated rights (run as admin) and run your command inside this window. It should not open an additional window

Synchronise computer clock with domain \ server clock

• sync clock with the domain
• NET TIME /DOMAIN /SET /Y
• sync clock with a specified domain
• NET TIME /DOMAIN:domainname /SET
• sync clock with a specified time server from another domain
• NET TIME /RTSDOMAIN:domainname /SET
• sync clock with a specified server \ computer
• NET TIME \\servername /SET /YES

Show user name on computer name (on desktop) instead of My Computer or This PC

• open registry editor
• go to HKEY_CLASSES_ROOT\CLSID\{20D04FE0-3AEA-1069-A2D8-08002B30309D}
• edit LocalizedString
• %COMPUTERNAME% display computer name
• %USERNAME% on %COMPUTERNAME% display user name on computer name

Get computer name from command line

Open command line and run the command below

• Method 1:
• hostname
• Method 2:
• set | findstr COMPUTERNAME

Get time and date of logon / domain server from the command line

• Get time/date from logonserver
• NET TIME %LOGONSERVER%
• Get time/date from domain
• NET TIME /DOMAIN
• Get time/date from the specified domain
• NET TIME /DOMAIN:domainname

Make Command Prompt transparent [Windows 10+]

• Open command prompt
• right-click on window menu and choose Properties
• in the Options tab select "Use legacy console"
• close and re-open the command prompt
• from the Colors tab choose Opacity level

Keyboard shortcuts:

• Increase Transparency: Ctrl + Shift + Plus (+)
• Decrease Transparency: Ctrl + Shift + Minus (-)

Enable/disable touchscreen in Windows

• Open Device Manager
• go to Human Interface Devices
• disable or enable HID-compliant touch screen

run multiple batch files inside one batch file (.bat)

To run multiple batch files inside one batch file put call in front of the *.bat file

eg:
ExecuteBatchFiles.bat should look like this:

call batch1.bat
call batch2.bat
call batch3.bat

add delay, wait until keypress in a bat / batch file / command line

Method 1: timeout

• timeout /t ##
• wait for ## seconds
• timeout /t ## /nobreak
• wait for ## seconds, but ignore any key pressed
• timeout /t -1
• wait until a key is pressed

recursively search files and copy them to another location using command prompt

for /r %%x in (*.jpg) do (
   copy %%x c:\temp\
)

This will copy all the jpg files from the current location (including subfolders) to a given path (c:\temp)