Microsoft Access Tips

In this tip we are going to filter the results of a Report to display records with order amounts above a given value.  In so doing we are g...

Dialog Forms are an integral part of most customized Access Database Applications.  As developers, we set them up to enable our application...

I was recently asked a question on my Access 2007 Tutorial Facebook Page which involved the manipulation of dates.  In my answer to this qu...

This is a quick tip on how to automatically display a form when the user opens your Access Application.  In addition to improving User Frien...

Imagine you have a contact database containing a list of suppliers.  One of those suppliers proved themselves unreliable once to often, so ...

In this post we shall use the power of an Access Crosstab Query  to summarize and restructure our data into a clear and concise format.  We ...

Let's imagine we have an Access table containing a list of academic exam results.  There is a field for Subject and a field for the per...

Suppose you want to calculate the difference between two dates.  An example of this might be a Library Management System: somebody returns a...

Today we are going to look at using the DSum Function within a Calculated Control  to produce a Total Amount. The DSum Function works in a ...

Imagine the following scenario: we have created a form to display information contained in an order details table.  Having selected tblOrder...

As well as being easy to use,  Calculated Controls can be a really useful tool for the Access Developer. They provide a flexible way to disp...

One thing that I find fascinating about Access Database Development is working with multiple database objects. Take an Access Form Object, f...

Following on from my last post on Customizing an Access Combo Box , this tip is about dealing with a Combo Box Entry that is Not In List .  ...