20Mar
Excel Template T Accounts with Manual and Automatic Balance for debit and credit
Excel template for T-accounts with and without automatic balance creation on two sheets. The template
20Mar
Creating SQL Statements with Excel (Quick and Dirty)
Sometimes, you have to import predefined data supplied as a list, such as personnel numbers, into a database and at the same time provide it with additional (default) values. Creating each statement manually would be very time-consuming, especially for large amounts of data. The function "concatenate" in Excel helps a lot.
20Mar
Import contents of a CSV file into an existing table via SQL (Bulk Operation)
Script to import data from a CSV file into an existing MS-SQL table via bulk operation. Creation of a temporary table, import, transfer to productive table. The assignment of the data to the correct keys takes place via an inner join.
20Mar
Remote support via TeamViewer without active Windows login ends in “this screen cannot be captured at the moment This is due to to fast user switching or a disconnected/minimized remote desktop session”
If you want to access your server with installed TeamViewer Host via TeamViewer with full access rights, you might know the following problem: The user only expects a black screen and the message "this screen cannot be captured at the moment. This is due to to fast user switching or a disconnected/minimized remote desktop session". You might think the solution to this problem is in the TeamViewer settings. Most of the time far from it. The solution is to distinguish between the server ID and the user ID of the running TeamViewer.
20Mar
The Best Home Remedy Against Bursitis
"Now he is completely gone crazy" you will think, because now he starts to write about diseases. Don't worry this will be the only blog post on health topics. But maybe one or the other will stumble over this post while googling and save his vacation. That's why I don't want to keep my tip to myself.
20Mar
Colour codes of the German flag – RGB, CMYK, HSV, RAL, Pantone
For my work as a graphic designer I often need exact colour specifications for printing or online publication.
Yesterday a task led me to find out the exact colour codes for the German flag. I found surprisingly little about it on the Internet.
20Mar
Activate HRFORMS after Patch (if no authorization exists, activate by report)
If you want to start HRFORMS in payroll accounting after a patch or release upgrade, you may experience the following error as soon as you call up the print output of the remuneration statement.
Runtime error OBJECTS_OBJREF_NOT_ASSIGNED
Exception CX_SY_REF_IS_INITIAL
20Mar
Java: Sort lottery numbers in array
This class generates lottery numbers and reads them into an array.
The values contained in the array are then sorted in ascending order.
20Mar
Java: Lottery number generator with array usage
This Java class generates 6 lottery numbers and stores them in an array.
The class ensures that no numbers are drawn twice.
17Mar
Use camera support system and tripod plate at the same time without changing the adapter plate
For a long time I wanted to buy a carrying system for my camera, but one thing I didn't like at all: I didn't want to have to screw another adapter plate to the camera every time I changed from tripod to carrying system or vice versa. Now I found a suitable solution without having to screw it on and off. With this solution, you use an adapter plate permanently screwed to the camera for both the mounting in the tripod head and for the carrying system. Time-consuming and annoying retooling is no longer necessary.
