databasedev.co.uk - database solutions and downloads for microsoft access

Form Design Articles and Tutorials from Database Solutions for Microsoft Access

Here you will find articles, tips and tutorials relating to Microsoft Access Graphical User Interface Form designs; from adding customised database error messages, including images in your database forms, creating Microsoft Access database start-up screens and adding customised login forms.

Hopefully you will find something of interest, whether you need to add to what you already have in your database application design to including cutomisation to build a user friendly application. Please also download any of the example files that show working examples of some of the articles listed. All example files are Microsoft Access 2000 databases unless otherwise stated.

UI Builder for Microsoft Access
Create attractive databases with the essential features any Access application needs in minutes, without becoming an expert in Visual Basic. Configurable menu layouts, color schemes, and advanced features make UI Builder a must-have for every Access user. Free trial available

Microsoft Access Forms

Topic Date Submitted Downloadable File
Adding a working clock to your forms

Tested on Access 2000 and XP

16/05/2002 N/A
Add a Welcome User message to your database

Tested on Access 2000 and XP

18/05/2002 N/A
Adding a security password to a command button on your form

Tested on Access 2000 and XP

03/09/2002 N/A
How to include a Bound Picture on your forms

Tested on Access 2000 and XP

24/09/2002 N/A
Hiding Microsoft Access Forms

Tested on Access 2000

20/10/2002 N/A
Making a Flashing Label or Text Box

Tested on Access 2000

26/10/2002 N/A
Printing a single record from your form into your report

Tested on Access 2000

03/11/2002 N/A
Adding a Macromedia™ Flash Movie to a start-up form

Tested on Access 2000

14/11/2002 N/A
How to open Microsoft Word documents from an Access form

Tested on Access 2000 and XP

19/11/2002 [41 KB]
How to create a Login Form

Tested on Access 97, 2000 and XP

07/01/2003 [33 KB]
How to create a simple text search facility

Tested on Access 2000 and XP

28/01/2003 [37 KB]
How to create a Start-Up Form

Tested on Access 2000 and XP

02/03/2003 [23 KB]
Create a Splash Screen to replace the default Access Splash Screen

Tested on Access 2000 and XP

13/08/2003 N/A
Sending E-Mails From Microsoft Access

Tested On Access 2000 and XP

01/09/2003 [44 KB]
Generating a List from Microsoft Access System Table

Tested on Access 2000 and XP

24/10/2003 [62 KB]
Filter one combobox based on another combobox selection

Tested on Access 2000 and XP

31/10/2003 [28 KB]
Automatically Increment a Fields Value

Tested on Access 2000 and XP (File available for download)

06/01/2004 [52 KB]
Controlling when Scroll Bars are displayed on a SubForm

Tested on Access 2000 and XP

15/01/2004 N/A
Searching Records using a Microsoft Access List Box

Tested on Access 2000 and XP

26/02/2004 [44 KB]
Sorting Columns in a Microsoft Access Listbox

Tested on Access 2000 and XP

27/02/2004 [44 KB]
Filter to only view Current User's Records in a form or query

Tested on Access 2000 and XP

03/03/2004 [35 KB]
Viewing a Live Web Site on a Microsoft Access Form

Tested on Microsoft Access 2000 and XP

06/03/2004 [32 KB]
Using an Option Group to Filter Records Displayed in a Form

Tested On Microsoft Access 2000 and XP

24/03/2004 [32 KB]
Undo changes made to current record

Tested on Microsoft Access 2000 and XP

20/04/2004 N/A
Checkboxes and using the Triple State Property

Tested on Microsoft Access 2000 and XP

10/05/2004 [28 KB]
Counting Used Characters in a Text Field

Tested on Microsoft Access 2000 and XP

25/05/2004 N/A
Spell Checking in an Access Form

Tested on Microsoft Access 2000 and XP

26/05/2004 N/A
Conditional Formatting and Continuous Forms

Tested on Microsoft Access 2000, XP and 2003

04/06/2004 N/A
How to use the Not In List event of a combo box

Tested on Access 2000, XP and 2003

23/06/2004 [30 KB]
Automatically display an Access combobox list

Tested on Microsoft Access 97, 2000, XP and 2003

24/06/2004 N/A
Creating Custom Command Buttons

Tested on Microsoft Access 2000, XP and 2003

25/06/2004 N/A
How to Clear a Multi-Select Listbox

Tested on Microsoft Access 2000, XP and 2003

13/07/2004 N/A
Preventing Duplicate Records from being entered via a form

Tested on Microsoft Access 2000, XP and 2003

28/07/2004 [86 KB]
Popping Up Reminders in Microsoft Access

Tested on Microsoft Access 2000, XP and 2003

12/08/2004 [17 KB]
Display Welcome Message at database Start-Up

Tested on Microsoft Access 2000, XP and 2003

02/09/2004 N/A
Automating Archiving Records in Microsoft Access, using Append and Delete Queries

Tested in Access 2000 and XP

30/03/2005 [40 KB]
Showing or Hiding Microsoft Access Subforms

Tested in Access 2000 and XP

04/04/2005 [31 KB]
Record Counter, Record X of Y, using custom form navigation in Microsoft Access

Tested in Access 2000 and XP

20/05/2005 N/A
Sending E-Mails from a Microsoft Access Form

Tested in Access 2000 and XP

25/05/2005 [38 KB]
Switchboard Forms in Microsoft Access

Tested in Access 2000 and XP

10/06/2005 N/A
Confirm Changes using the Before Update Event

Tested in Access 2000, XP and 2003

20/07/2005 N/A
Validate A Forms Textbox To Ensure Only Text Is Entered

Tested in Access 2000, XP and 2003

21/10/2005 N/A
Replacing a Standard Microsoft Access Error Message with a Custom Error Message

Tested in Access 2000, XP and 2003

02/11/2005 N/A
Using a Microsoft Access Combo Box to Search for a Record

Tested in Access 2000, XP and 2003

09/12/2005 N/A
Validating Missing Data by Responding to Data Entry Events

Tested in Access 2000, XP and 2003

19/01/2006 N/A
Conditionally Formatting Microsoft Access Form Data

Tested in Access 2000, XP and 2003

26/07/2006 N/A
Displaying an Image in a Microsoft Access Form

Tested in Access 2000, XP and 2003

19/09/2006 [238 KB]
Displaying Subform Totals in a Main Form in Microsoft Access

Tested in Access 2000, XP and 2003

06/10/2006 N/A
Protect Form Data from Being Accidentally Changed

Tested in Access 2000, XP and 2003

26/10/2006 N/A
Using the Combo Box's NotInList event with multiple fields

Tested in Access 2000, XP and 2003

21/11/2006 [69 KB]
Creating a Microsoft Access Splash Screen

Tested in Access 2000, XP and 2003

08/12/2006 [101 KB]
Moving the Cursor To The End Of A Microsoft Access Textbox

Tested in Access 2000, XP and 2003

24/02/2007 N/A
Passing Multiple Parameters to a Microsoft Access Form

Using the OpenArgs parameter of the DoCmd.OpenForm object
Tested in Access 2000, XP and 2003

13/03/2007 [90 KB]
Password Protecting A Microsoft Access Tab Control

Tested in Access 2000, XP and 2003

17/07/2007 [40 KB]
Unbound Forms in Microsoft Access

Adding Data with Unbound Forms in Microsoft Access

16/03/2008 [25 KB]
Editing Data with Unbound Forms in Microsoft Access 20/04/2008 [25 KB]

A Standard Set of Form Navigation Buttons In Microsoft Access 2010

Tested in Access 2000

08/05/2012 N/A