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
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 |
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 | 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 |