Microsoft Access Tutorial – How to use Input Masks

Microsoft Access Tutorial: How to use Input Masks

Microsoft Access databases provide a wealth of tools and utilities to help control design layouts and data integrity. Working with the latter, you can reduce and even dismiss any programming at all to control data entry to a field in a table or via a form using the Access Input Mask feature.

Take a quick look at this useful Microsoft Access tutorial (using version 2010) on how to set up an input mask.

Very easy to create indeed and the video covers the pre-set options which to be honest is based on the US style conventions for Continue reading “Microsoft Access Tutorial – How to use Input Masks”

Microsoft Access Database – Working With Two Digit Hour Time Formats

Microsoft Access Tutorial – Working With Two Digit Hour Time Formats

Here’s a quick Microsoft Access tutorial video I found about applying formatting to the date/time data type control concentrating on the two digit hour time format that doesn’t always show up in two digit form.

Even if you create a custom date/time format within Microsoft Access, the two-digit hour which is supported using the convention of “hh” via the format property doesn’t always work. It will show a single digit hour even though you’ve specified the right code. Take a look at the video below.

Microsoft Access Tutorial – Working With Two Digit Hour Time Formats

In the video tutorial, it mentioned one of three ways to Continue reading “Microsoft Access Database – Working With Two Digit Hour Time Formats”

Microsoft Access Tutorial: How To Resize Form Fields Dynamically Using MS Access VBA

Microsoft Access Tutorial: How To Resize Form Fields Dynamically Using MS Access VBA

I often see many poorly designed Access forms that just make it hard and clumsy to navigate and use. One particular element (and there are many) is the lack of area space for a text box control like comments or notes that require some intervention in order to edit the content properly.

Check out this Microsoft Access tutorial provided by ‘599CD Computer Training’ who provide some good and free video tutorials about Microsoft Access databases. On this occasion, it’s the best part of ten minutes but worth watching all the way to the end.

There are some good pointers here and to avoid using the SHIFT + F2 function key to zoom in on an active text box control, the author has Continue reading “Microsoft Access Tutorial: How To Resize Form Fields Dynamically Using MS Access VBA”

Microsoft Access Tutorial: How To Create A Leading Dot List

Microsoft Access Tutorial: How To Create A Leading Dot List

If you wanted to generate a table of contents or a set of index pages, the format for this type of document tends to have leading dots connecting narratives with page numbers.

Using Microsoft Word or other word processors and DTP applications; generating these pages is a breeze. With Microsoft Access however, it simply doesn’t exist and to mimic such a document we need to be a little creative here. 

In this Microsoft Access tutorial, I’m going to create a report showing the company name, a contact name and the telephone number sitting (as right aligned) at the end of a dot leader line (see image below).

microsoft access tutorial string function

In fact, the telephone number may appear as right aligned but is in fact Continue reading “Microsoft Access Tutorial: How To Create A Leading Dot List”

Microsoft Access 2013 Runtime Now Available

Microsoft Access 2013 Runtime Now Available

Over the years (generations from version 95), developers were able to distribute their own custom built Access database applications to users who did not have an Access licence by using the freely available run-time version and now this also includes Microsoft Access 2013.

You can now go and download the Access 2013 Runtime direct from  Microsoft or if you prefer, can also find it here with other Access database free stuff too.

microsoft access 2013 runtime

Just in case English is not your native tongue, it’s now available Continue reading “Microsoft Access 2013 Runtime Now Available”

Microsoft Access Tutorial: How To Build Alternative Access Form Controls – The Command Button

Microsoft Access Tutorial: How To Build Alternative Access Form Controls – The Command Button

Building Access forms is a time consuming aspect to front-end database designs and in this Microsoft Access tutorial, I want to add some extra aesthetics and alternative control enhancements for you.

There are many Access form controls, formats and properties that can be applied to a form over and above the basics ranging from the more advanced conditional formatting options to the custom built controls including my recent post on coloured tab controls.

So here’s some alternatives for your traditional command button…

Microsoft Access Tutorial How To Build Alternative Access Form Controls

Using the standard command button, you can still apply different format effects using the correct event with some Access VBA code or Continue reading “Microsoft Access Tutorial: How To Build Alternative Access Form Controls – The Command Button”

Microsoft Access Tutorial: Hiding Access Tables As ‘USYS’ System Tables

Microsoft Access Tutorial: Hiding Access Tables As ‘USYS’ System Tables

Hiding tables (or any object) in your Access database is a simple enough process. You only need to set the objects hidden property (to True) and reveal the ‘Hidden Objects’ setting from the navigation pane options screen.

But in this quick Microsoft Access tutorial here, there is another method of stopping your tables appearing in Navigation pane (or Database window) by renaming the table(s) with the prefix USYS. This will convert your table into a system object, which cannot be viewed in the normal environment.

microsoft access tutorial usys tables

In the Navigation pane’s options screen (Access 2007 & 2010), you have two display options the called Continue reading “Microsoft Access Tutorial: Hiding Access Tables As ‘USYS’ System Tables”