01 Introduction to coding with VBA and Macros
Excel is a powerful tool. Even the basic functions and formulas can be utilised to produce some truly incredible works. However there are limitations to what you can accomplish when you solely rely on formulas...
Excel Quality Control Model for Door Manufacturer
Jeld-Wen produce a wide range of high quality timber doors and in order to ensure the quality of their doors they asked Xlteqs Excel experts to produce a way of recording defects on their doors as part...
Are you having trouble opening your Access Database?
Microsoft have released an update which caused this problem. The issue is triggered by running VBA code that references Access objects.
Issues include:
No Access window open, but Access process runningMicrosoft Access Developer Tips from Xlteq
Let’s first look at how a crosstab query works. For those that are more familiar with Excel Spreadsheets, this would be the equivalent of a pivot table.
A crosstab query enables you to display and summarise the...
Tips from Xlteq the Access Database and Excel Spreadsheet Experts
This blog is aimed at helping VBA programmers to navigate around their projects with ease. It contains helpful shortcut keys that will reduce the need to use ribbon menus.
Using SHIFT+F2...
Using Weekday and WeekdayName Function Access Database Tips from Xlteq
Syntax
Weekday(date, FirstDayOfWeek)
The Weekday function returns an integer representing a day of the week.
It has one optional setting, FirstDayOfWeek. This allows you to alter which...
Xlteq announce the release of International Travel Tracker in Android and iOS.
"Travel Tracker helps me keep a simple and accurate record of where I am in the world"
Ritchie Faulkner - Lead Guitarist - Judas Priest
Keep accurate records of your international...
Access Tips from Xlteq
Using the Select Case Statement
Often in VBA code you need to take a value and “do something” conditionally.
The traditional approach is to use an If Then Else or If Then Elseif ElseIf … type of construct, however these quickly...
ABS Function
A lesser know function in Excel is ABS, which is short for absolute. This function simply converts any negative number into a positive one.
To use it we simply type in the function and refernce a cell which contains a number. If the number...
Excel Expert Tips - Summing Filtered Rows
In Excel you can sum a range of rows using the SUM command, however this will sum up all the rows even if they are filtered....
Access Database Date Formatting
If you write even simple VBA code, or use forms to set dates to run reports or queries, at some point you will probably have been tripped up by international date formats in Access or Excel, particularly if you are in the...
Excel Spreadsheets Quick Sum of Column...