Excel and Access Database Insight

Blog

Tips and information from the Excel and Access Database Experts

How to code with VBA and Macros in Excel

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

Read more

Quality Control Process Model

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

Read more

Access Database issue "Cannot open any more databases"

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 running
Read more

Display Crosstab Data in an Access Database

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

Read more

Using the VBA Editor Navigation

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

Read more

Using Weekday and WeekdayName Function

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

Read more

International Travel Tracker App Launched in Android

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

Read more

Using the Select Case Statement

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

Read more

How to use the ABS Function in Excel

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

Read more

Excel Developer Tips Summing Filtered Rows

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

Read more

Date Formatting in Access Databases

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

Read more

Excel Quick Sum of Column

Excel Spreadsheets Quick Sum of Column...

Read more