Update Query In MS Access – A Little Trick Using The Access VBA Immediate Window

Update Query In MS Access – A Little Trick Using The Access VBA Immediate Window

Here is one my free weekly tips (No. 86) for you that I wanted to share today because one particular client recently asked how you can disable warnings when using an Update query in MS Access?

Within the application, you can in fact switch off the warning prompts when running one of the four ACTION queries which are used for many different data processing tasks including how to archive data by combining two or more types of queries.

These options can be found in the Tools, Options section to versions 2003 (or earlier) or via the back-stage section under the Options, Client Settings section for later versions. There are three ‘Confirm‘ options that can be set including the ‘Action Queries‘.

update query in ms accessHowever, here’s a little trick; my free weekly tip for you which Continue reading “Update Query In MS Access – A Little Trick Using The Access VBA Immediate Window”

Excel vs Access – The Argument Continues

Excel vs Access – The Argument Continues

Once again this week, a client questioned the argument of Excel vs Access when building a data processing system for their organisation.

There are many pros and cons to using Microsoft Access over an Excel spreadsheet but this particular client was in love with (Excel) Pivot tables and was the main reason and perhaps the only reason why they wanted to use a high-end sophisticated spreadsheet instead.

Take a look at this 5 minute video tutorial of how you can bring data in from Excel to an Access table, then create and use a query as the alternative data source for a Pivot table in Access.

httpv://www.youtube.com/watch?v=gMH31ZcJsTQ

Excel vs Access – The Argument Continues

In this video, it covered some Continue reading “Excel vs Access – The Argument Continues”

Microsoft Access Business Benefits: The Perfect Match

Microsoft Access Business Benefits: The Perfect Match For SME’s

Check out my latest article recently published on how small medium sized companies using Microsoft Access business benefits them and provides the back-bone operations to any successful company.microsoft access business benefits

Here’s the article:

Microsoft Access Business Benefits: Here Are 5 Good Reasons Why It’s The Perfect Match For SME’s

Habits are hard to break, human nature simply doesn’t like change and we generally fear having to do more work which usually means one or two steps back to move several steps forward for the better.

With Microsoft Access, business benefits can be seen here to help manage and build SME sized businesses that is Continue reading “Microsoft Access Business Benefits: The Perfect Match”

Access Pivot Table Versus Access Crosstab Query

Access Pivot Table Versus Access Crosstab Query – The Differences

The first thing to note when creating an Access Pivot table or a crosstab query is that they both handle the grouping and summarising of ‘detailed’ records which means in most cases this type of output reports are driven by the typical ‘SELECT’ based query.

This article is not to show you how to create pivot tables or crosstab queries but how they differ; helping you to understand the key differences. If you want to know how, take a quick look at how to create Pivot tables with this simple video tutorial.

access pivot table

The main difference between Continue reading “Access Pivot Table Versus Access Crosstab Query”

Access Tab Control: How To Create Multi-Page Forms

Access Tab Control: How To Create Multi-Page Forms

If you have been developing with Access Forms for a while then you may have noticed the Access tab control which allows you to split logical sections of fields into smaller and more manageable chunks and reduce the need to scroll all over the place keeping screen views neat and tidy.

Just as a reminder (or even if this is something new to you), take a look at the video tutorial below on how to add a tab control in a form (though the narrator is using an earlier version of Access – looks like Access 2000!).

httpvh://www.youtube.com/watch?v=9Rv0RNwsLuw

From the demonstration, it is clear how Continue reading “Access Tab Control: How To Create Multi-Page Forms”

How To Import Access Database Objects

How To Import Access Database Objects

In the past, I’ve talked about importing data into Access but someone recently asked about how to import Access database objects since you cannot copy and paste tables, queries, forms or reports.

It’s really very easy to achieve providing you haven’t locked, password protected or hidden objects you intend to import (though there are workarounds for this too).

import access objects

 

 

 

 

 

 

 

 

Objects can also be extended Continue reading “How To Import Access Database Objects”