Category: Windows
Populate Sage table opheadm with credit note information for Cindercone Magma to send to Tungsten/OB10
The below stored proc is used to populate two Sage fields shipper_code2 and shipper_code3 in the Order Header Table. Obiously […]
Check the audit on Business Objects XIR3 SP7 for logons
This is useful to see who is using their licenses which are very expensive. I tend to check every few […]
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 […]
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 […]
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 […]
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 […]
Disable Powerpoint 2016 extended display mode
Credit: http://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 […]
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 […]
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 […]
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 […]