Utter Angel's
MS Access Downloads

Visual Basic 6

MS Access 2000/2002

MS Access 97

MS Access 2

Development Documents
Visual Basic 6
VB to Access 24K This project and db demonstrates how to view, add, edit and deleterecords in an Access 2000/2002 mdb file from a Visual Basic 6 executable. Note: The mdb file should be in the same folder with the vbp file.
MS Access 2000/2002
"Autonumber" without autonumber 41K Demonstrates how to increment an index without using autonumber.
Audit Trail 33K This db demonstrates how to set up an audit trail of changes to the data including ID, Field Name, the field value before it was changed, the field valueafter it was changed, the user who did the change, and the date/time the changewas made.
Automatic Backup 102K Utility that allows the user to set a time and location to backup, repair and compact multiple databases.
Boiler Plate Database 285K This is a moderately advance database that encorporates a number of functions such as 1) user logon 2) table reattachment 3) user tracking 4) how to control access via the use of modal switchboards and more. FYI: Username = admin; Password = admin.
Browse and Open Files Database 30K Utility allows users to retrieve file names and status for selecteddirectory. Developed by Rob Richards of Archery Software Solutions.
Cascading Combo Boxes Database 30K Demonstrates how to make combo boxes whose values are filtered by the value of other combo boxes in a cascade.
Cascading Combo Boxes Using 2 Tables 17K Demonstrates how to make combo boxes whose values are filtered by the value of other combo boxes (whose record source are two tables) in a cascade.
Check User Open Mode/Number of Current Users 74K This database demonstrates how to check for open mode (shared or exclusive) and the number of current users. The Check Open Mode button tells your user what mode he/she has opened the database in. If their open mode is "exclusive", they get an error message and exit from the database. On exit, their open mode is globally changed to "shared". This is useful if you have a multiuser database but are not using security. The Check Number of Current Users button tells your user if they are the only current user of the database regardless of their open mode. Acknowledgement: The source for Msldbusr.dll and frmLDBUser is The Access 97 Developer's Handbook by Sybex.
Clipboard Functions 34K Utility database that demonstrates the use of the Windows clipboardfunctionality in an Access database.
Color Command Buttons 376K Tired of boring grey command buttons? How about multicolored,square, oval, stone textured, or wood textured ones? In addition, there is a demo showing how to use multiple instances of the same colored command button.
Color Listbox 63K This demonstrates how to use a subform as a "faux" list box to simulate colored rows.
Combobox - Populate a Form 65K This demo shows how to populate a form and/or text box controls based on the user's selection from a combo box. The demo shows five methods of populating text boxes based on a combobox including: DAO, ADO, Filter, DLookup, and Combobox column values.
Create a Shortcut 50K This demo shows how to create a desktop shortcut in code for your users.
Create Cascading Combo Box Sets 1071K Creates a set of combo boxes whose values are filtered by the value of previous combo boxes in a cascade, exported automatically to your database.
Create Color Command Button Sets 260K Tired of boring grey command buttons? This demo allows the user to create web-style command button sets with graphics of your choosing, exported automatically to your database. TRY IT, YOU'LL LIKE IT!
Detect and Logoff Idle Users 143K Detects and ejects idle users after set time period.
E-Mail to Multiple Recipients Using CDO Object 67K Sends e-mail to multiple recipients using the CDO object (cdonts.dll)and stores the addresses in the database.
E-Mail to Multiple Recipients Using Outlook Object 57K Sends e-mail to multiple recipients using the Outlook object and stores both the message and the addresses in the database.
Flexible Query 125K This demo shows how to store and use your queries in tables, instead of saving them as objects. It also shows how to dynamically construct queries and retrieve/display the resultset. This ability is useful for, amoung other things, allowing your user to search a recordset on entered criteria.
Listbox Reorder 29K This demo shows how to let your user reorder list box items, whether the list box rowsource is a table or a value list.
Open Detail Form to Related Information 188K This demo shows five methods of opening a detail/information form (columnar) from a list form (tabular). Methods include Link Criteria, Bookmark, Filter and others.
Parse Name and Populate Field 46K Two forms demonstrate how to parse an space delimited name and populate a field in a form by using a lookup table.
Password Protect a Command Button 28K Demonstrates simple password protection routine for a command button. The routine can be adapted to protect forms, reports, and other databaseobjects.
Picture in a Report 76K Demonstrates a method of displaying a picture/image file in a report without storing the image in a table.
Picture in Database 80K Demonstrates a method of displaying a picture/image file in a database/formwithout storing the image in a table.
Subform Reference 42K This wonderful demo was developed by Roger Carlson http://www.rogersaccesslibrary.com and demonstrates how to set focus on controls on subforms and subforms as well as retrieve valuesfrom subforms and subsubforms.
Windows Common Dialogs 49K Demonstrates how to invoke and control Windows Common Dialogs includingthe color, open file, and save as dialogs utilizing Windows API calls.
Wipe/Move/Resize Effects for Forms 32K This demo shows how to create nice "wipe" effects on a form event (such as form_close) using the Win APIs MoveWindow and GetWindowRect. Effects include: resizing, wipe up/down left/right, shrink/move, and shiver.
MS Access 97
"Autonumber" without autonumber 90K Demonstrates how to increment an index without using autonumber.
"Parameters" without parameters 33K Demonstrates how to use a "parameter popup" to obtain and use criteriawithout using MS Access native parameter popups.
Animated Gif's 24K Developed by Ricky HicksThis is an add-in library function that allows developers to add animated gif's to their databases.
Audit Trail 43K This db demonstrates how to set up an audit trail of changes to the data including ID, Field Name, the field value before it was changed, the field valueafter it was changed, the user who did the change, and the date/time the changewas made.
Autofill Fields 66K This db demonstrates how to set the default value of fields on a form to the values of the previous record. It also demonstrates an A to Z button thatcan either filter or find a record. Both are straight off the Microsoft site so I can't take credit. Enjoy.
Automatic Backup 178K Utility that allows the user to set a time and location to backup, repair and compact multiple databases.
Backup Database 131K Utility database that backs up, repairs and compacts selected databases.
Boiler Plate Database 212K This is a moderately advance database that encorporates a number of functions such as 1) user logon 2) table reattachment 3) user tracking 4) how to control access via the use of modal switchboards and more. FYI: Username = admin; Password = admin.
Calculator Database 25K Developed by Ricky HicksRicky Hicks has answered a crying need for a calculator that can be easily added to an Access database. This demo works with the standard controls in Access.
Calendar 280K Developed by Drew Wutka anddonated by Darren Dick. Drew has answered then need for a calculator that can be easily added to an Access database. This demo works with the standard controls in Access.
Cascading Combo Boxes Database 24K Demonstrates how to make combo boxes whose values are filtered by the value of other combo boxes in a cascade. Revised 8/25/2000
Change Control Properties (Color) 38K Demonstrates changing control properties by type of control and/or tag value selection.
Check User Open Mode/Number of Current Users 110K This database demonstrates how to check for open mode (shared or exclusive) and the number of current users. The Check Open Mode button tells your user what mode he/she has opened the database in. If their open mode is "exclusive", they get an error message and exit from the database. On exit, their open mode is globally changed to "shared". This is useful if you have a multiuser database but are not using security. The Check Number of Current Users button tells your user if they are the only current user of the database regardless of their open mode. Acknowledgement: The source for Msldbusr.dll and frmLDBUser is The Access 97 Developer's Handbook by Sybex.
Clipboard Functions 28K Utility database that demonstrates the use of the Windows clipboardfunctionality in an Access database.
Color Command Buttons 303K Tired of boring grey command buttons? How about multicolored,square, oval, stone textured, or wood textured ones? Try 'em out.
Color Translater 18K Developed by John Hazen of Hazen & AssociatesIf you're tired of trying to figure out what your backcolor and forecolor valuesshould be, in decimal or in hex, try this "toy" donated by John Hazen. A great tool for web development and a good way of learning how VBA is used.
Cross Tab Demo 96K Demostrates how to let a user select the criteria for a cross tab query, generate the cross tab query "on the fly", write the results to a table and base a report on this query without crashes/errors.
Date Fixer 114K Utility database that allows user to select an Access 97 database, select defined or customize date formats and input masks and then setthe formats and input masks for ALL date fields in ALL tables associated with the selected database, native and/or attached.
Detect and Logoff Idle Users 12K Detects and ejects idle users after set time period.
E-Mail to Multiple Recipients 59K Sends e-mail to multiple recipients and stores both the message and the addresses in the database.
Enumerate Processes 27K Lists the processes that are currently running on your computer.
Form on the Fly 34K Demonstrates how to create a new table, append fields and create a formbased on that table "on the fly" (in code).
Increment Date Demo 14K Demonstrates how to build a date incrementing "control" without usingthird party ActiveX/VB controls.
Multiple Criteria 113K Demonstrates how to give your user the ability to filter the recordset ofa form based on mlutiple fields with multiple criteria. Also demonstrates the use ofarrays and the construction of WHERE clauses.
NotInList Demo 66K Demonstrates how to use a NotInList event of combo boxes to updatethe data row source tables of a combo boxes without extra popup forms orother means. This property is new to Access 97 and looks slick to users.
Password Protect a Command Button 32K Demonstrates simple password protection routine for a command button. The routine can be adapted to protect forms, reports, and other databaseobjects.
Picture in Database 88K Demonstrates a method of displaying a picture/image file in a database/formwithout storing the image in a table thereby bloating the db, but by storing thepath to the database in a text field.
Popups 95K This brilliant demo was written by William Hindman and contains a calculator, calendar, and zoombox, all written in with native Access controls so you don't have to distribute add-ons with your application. this is a brilliant application. If you use this download, please let William know that you got it here and how much you appreciate his sharing it with us.
Report by Date 74K Demonstrates how to allow a user to produce a report based on a query created"on the fly" utilizing user selected date criteria. This technique is flexible and canbe adapted to any type of criteria.
Retrieve File Names 88K Utility allows users to retrieve file names and status for selecteddirectory.
Shakesperean Insulter Database 96K Self explanatory. Try it clicking "Insult Me Again" after a long hard workday.
Soft Command Buttons 40K Developed by Ryan Neil ShawTired of boring grey command buttons? How about "soft buttons" that change appearance when a mouse moves over them? Try these out.
SoundEx 18K Allows "fuzzy matching" of words using the SoundEx algorhythm.
Swap Mouse Buttons 11K Utility allows "lefty" users to swap mouse button functions. Also useful for confounding users who have really been getting on the DBA's nerves lately.
Toggle Edit/Read Only Form Properties 27K Demonstrates how to easily toggle edit and read only properties of a form.Can be adapted to toggle other properties, backcolor, forecolor, visibility,etc. and to exclude/include selected users from modifying records.
User Tracking -- Read/Write to a Private INI File 122K Demonstrates user logging and tracking utilizing reading/writing to a private ini file.
User Tracking -- Read/Write to the Windows Registry 106K Demonstrates user logging and tracking utilizing reading/writing to the Windows registry.
Windows Common Dialogs 67K Demonstrates how to invoke and control Windows Common Dialogs includingthe color, open file, and save as dialogs utilizing Windows API calls.
Wipe/Move/Resize Effects for Forms 24K This demo shows how to create nice "wipe" effects on a form event (such as form_close) using the Win APIs MoveWindow and GetWindowRect. Effects include: resizing, wipe up/down left/right, shrink/move, and shiver.
Workday Calculation 41K Developed by Thom RoseThis function calculates the number of workdays between two dates. The number of workdays is inclusive of the beginning and ending dates.
MS Access 2
Backup Database 131K Utility database that backs up, repairs and compacts selected databases.
Development Documents
Application Profile Form 7K Form for obtaining specifications and requirements from prospective clients. (RTF format)