Archive for ‘MS Access Samples’

November 23rd, 2010

MS Access Sample – Clocks and Timers

This database demonstrates how to insert a clock in your forms to display the current time as well as a demonstration of how to create a timer used to determine the amount of time which a form has been open for.

Download the sample database: MS Access Clocks and Timers Sample Database

November 22nd, 2010

MS Access Sample – Working with Dates

This database demonstrates some of the most common ways to work with dates. It demonstrates how to extract only a part of a date (year, month or day), how to display a date in different formats (ISO, American,…), how to determine the number of days, weeks between 2 dates, etc.

Download the sample database: MS Access Working with Dates Sample Database

November 20th, 2010

MS Access Sample – Working with Images

This database example show the proper way to work with images within a database (which is not to embed them into the database).

Download the sample database: MS Access Images Sample Database

November 19th, 2010

MS Access Sample – Change Password

If you are using user-level security (ULS), the following is a simple demonstration of a form that can be added to any database to permit the user the ability to change their password. Useful when you create an mde or disable the standard toolbars for increased security but still want to give the user the ability to rotate their own password.

Download the sample database: User-Level Security Change of Password Form Demonstration

November 18th, 2010

MS Access Sample – Data Transfer

This database provides a single form which permits the user to either import or export data to/from the database from a selected source (spreadsheet).

Download the sample database: MS Access Data Transfer Sample Database

November 17th, 2010

MS Access Sample – Colors

This is a very simple database which provides the user a form which permits them to convert color values between OLE Color values, RGB values and HEX values.

Download the sample database: MS Database Color Converter Sample Database

November 16th, 2010

MS Access Sample – Common Issues

This database demonstrates common programming concepts, such as: basing one combo box’s list on anothers value, changing a control’s background color, changing a form’s background color. This sample database will be updated as I have time to add to it.

Download the sample database: Common MS Access Issues Sample Database