When writing VBA, there are a number of occasions when you will have to select a single or group of worksheets. In this blog, we will explore some of the ways we can do this.
Selecting a single Worksheet
Selecting all Worksheets
Selecting the last sheet
Here are a few questions and answers about some keyboard shortcuts available in Microsoft Word.
The grep command is perfect in these situations and we explore some of it’s capabilities here.
While many organisations have moved over to “The Cloud” many are nervous of making the move with security being the number one concern. I came across a couple of interesting articles last week, which I thought I would share with you as they highlight some common IT security concerns among IT Security Managers and present some possible solutions to protect your company from common threats.
Although we can create Linked Tables in Access that pull information from a SQL Server Database there are times when you want to check a value or lookup a value from an underlying SQL Server database directly from an Access Query.
We will look at an example that enables us to lookup a customer’s total revenue value from an Access Query.
Although we can create External Data Sets in Excel that pull information from a SQL Server Database there are times when you want to check a value or lookup a value from an underlying SQL Server database directly from an Excel formula.
We will look at an example that enables us to lookup a customer’s total revenue value from an Excel Formula.
It is easy enough to extract the first word from a string in a database query, but what if you need to separate all words in a given string into a list of separate words?
This is a job for Common Table Expressions (CTEs) as they enable us to repeatedly read a single record while changing it each time.
Here is a SQL Server example which takes a string variable and spearates it into inidividual words. We use a combination of CHARINDEX, LEFT and RIGHT functions to achieve it.
Linux Systems offer an X Windows interface which can make changing system settings and configuration pretty straight forward, but what if you remotely log in via a Secure Shell (SSH) session using a tool such as putty?
Here is how to change the system date and time and the hostname from the command line.
The date command can be used by root to change the system date and time.
