Category: Windows
In VBA strip out characters which cause TSQL to fail
A simple way to strip out characters which can cause TSQL Code to break. Assumes the SQL commannd is in sqlstatement and you are passing a variable in me.comment, before executing the code. ‘Allows Characters such as , and ‘ which may break TSQL Code and Cause Injection sqlstatement = RTrim(sqlstatement) + “,’Me.comment & “‘”…
Sage EDI IN Intermediary Email
I have found users don’t always read the logs from the Adaptus EDI Module anymore in Sage Line 500. There are a few reasons why orders get stuck, the most common is a customer has sent a duplicate EDI file although one was caused by incorrect product supersession setup causing an endless loop. USE <Affected…
Maintain regtrans-ms and blf files generated by Georgia UTS sessions
A little script I schedule for servers using Georgia UTS. Below I use Robocopy to move files older than 3 days, to avoid anyone currently logged in. For me I expect users to be logged on for no more than a day, active user files should therefore be untouched. echo This Batch Files removes .regtrans-ms…
Force launch IE with a Shortcut
I needed to force Windows 10 to open a web browser in IE for some internal applications as they still use ActiveX add-ins. Rather simply instead of using a URL shortcut, use a standard shortcut calling IE and passing the URL as a parameter. Here I call the 32bit version of IE (As I don’t…
Disable Powerpoint 2016 extended display mode
Credit: https://web.archive.org/web/20240809174312/https://tips.timscomputer.com/disable-powerpoint-2013-extended-display-mode-via-registry/ Disable the extended display mode upon login, same as the link just modified the version from 15 to 16 Run the following as a batch file upon login @echo off reg add HKCU\Software\Microsoft\Office\16.0\PowerPoint\Options /v UseMonMgr /t REG_DWORD /d 0 /f
Windows 2008: Task Scheduler causes account lockout when policy locks account after one attempt
I encountered a very odd issue where I was attempting to amend a scheduled task on a Windows 2008 R2 server. When attempting to amend to a “service” account it locked out immediately. This account has a policy where it is locked out if the password is incorrect once. After several attempts and having to…
DBForms: Check and format email addresses from Sage Line 500/1000
As the email field can sometimes not be used for the correct purpose I use a bit of code to look for an @ symbol and then a dot. If more than one email address is in I replace the comma with -t which is required by dbmailsend. If using Sage Line 500/1000 the CustomerTable…
Remotely remove a broken user profile from another computers registry when the user folder is deleted
I recently had an issue where someone had deleted my admin user profile from a remote server by deleting its folder. The logon then failed as Windows still expected the folder to be there, as obviously the registry entries were not removed. Rather than manually checking HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\ProfileList for the SID and then removing it…
Amend an SCCM NTFS USB flash drive for the Microsoft Surface 3 (Non Pro)
Microsoft Surface 3’s for some reason don’t support mounting USB Flash drives mounted as NTFS from its UEFI/BIOS and have to be FAT32. Either reformat the USB flash drive as Fat32 and copy back the image (Windows Command Line currently only supports FAT32 to NTFS conversion, not the other way around), third party software needs…
With a faulty drive stop Windows from mounting
Credit: A Video from Linus Tech Tips reminded me of a way to stop Windows 7/10 from automounting drives If you have an issue with a hard drive (That is spinning up, doesn’t sound like its head is craching/clicking and a SMART tool like CrystalDiskInfo Standard edition shows its healthy) that simply appears to hang…