Excel and Access Database Insight

03 Writing and Running Code 

Small set up

Although we could go ahead and write some VBA code straight away, there is one little setup item we should do beforehand. This only need to be done once unless you want to change it again and is found...

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:

Microsoft 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...