headerphoto

MS Access:Resources

"Autonumber" without autonumber Demonstrates how to increment an index without using autonumber. MS Access 2007
Cascading Combo Boxes Database Demonstrates how to make combo boxes whose values are filtered by the value of other combo boxes in a cascade. Revised 8/25/2000 MS Access 2007
Combobox - Populate a Form 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. MS Access 2007
Type Down Demo Demonstrates how to filter a recordset by typing characters into a text box. MS Access 2007
Wipe/Move/Resize Effects for Forms 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 2007
"Autonumber" without autonumber Demonstrates how to increment an index without using autonumber. MS Access 2000/2002
Audit Trail 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. MS Access 2000/2002
Automatic Backup Utility that allows the user to set a time and location to backup, repair and compact multiple databases. MS Access 2000/2002
Boiler Plate Database 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. MS Access 2000/2002
Browse and Open Files Database Utility allows users to retrieve file names and status for selecteddirectory. Developed by Rob Richards of Archery Software Solutions. MS Access 2000/2002
Cascading Combo Boxes Database Demonstrates how to make combo boxes whose values are filtered by the value of other combo boxes in a cascade. MS Access 2000/2002
Cascading Combo Boxes Using 2 Tables 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. MS Access 2000/2002
Check User Open Mode/Number of Current Users 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. MS Access 2000/2002
Clipboard Functions Utility database that demonstrates the use of the Windows clipboardfunctionality in an Access database. MS Access 2000/2002
Color Command Buttons 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. MS Access 2000/2002
Color Listbox This demonstrates how to use a subform as a "faux" list box to simulate colored rows. MS Access 2000/2002
Combobox - Populate a Form 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. MS Access 2000/2002
Create a Shortcut This demo shows how to create a desktop shortcut in code for your users. MS Access 2000/2002
Create Cascading Combo Box Sets 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. MS Access 2000/2002
Create Color Command Button Sets 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! MS Access 2000/2002
Detect and Logoff Idle Users Detects and ejects idle users after set time period. MS Access 2000/2002
E-Mail to Multiple Recipients Using CDO Object Sends e-mail to multiple recipients using the CDO object (cdonts.dll)and stores the addresses in the database. MS Access 2000/2002
E-Mail to Multiple Recipients Using Outlook Object Sends e-mail to multiple recipients using the Outlook object and stores both the message and the addresses in the database. MS Access 2000/2002
Flexible Query 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. MS Access 2000/2002
Listbox Reorder This demo shows how to let your user reorder list box items, whether the list box rowsource is a table or a value list. MS Access 2000/2002
Open Detail Form to Related Information 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. MS Access 2000/2002
Parse Name and Populate Field Two forms demonstrate how to parse an space delimited name and populate a field in a form by using a lookup table. MS Access 2000/2002
Password Protect a Command Button Demonstrates simple password protection routine for a command button. The routine can be adapted to protect forms, reports, and other databaseobjects. MS Access 2000/2002
Picture in a Report Demonstrates a method of displaying a picture/image file in a report without storing the image in a table. MS Access 2000/2002
Picture in Database Demonstrates a method of displaying a picture/image file in a database/formwithout storing the image in a table. MS Access 2000/2002
Subform Reference 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. MS Access 2000/2002
Windows Common Dialogs Demonstrates how to invoke and control Windows Common Dialogs includingthe color, open file, and save as dialogs utilizing Windows API calls. MS Access 2000/2002
Wipe/Move/Resize Effects for Forms 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 2000/2002
"Autonumber" without autonumber Demonstrates how to increment an index without using autonumber. MS Access 97
"Parameters" without parameters Demonstrates how to use a "parameter popup" to obtain and use criteriawithout using MS Access native parameter popups. MS Access 97
Animated Gif's Developed by Ricky HicksThis is an add-in library function that allows developers to add animated gif's to their databases. MS Access 97
Audit Trail 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. MS Access 97
Autofill Fields 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. MS Access 97
Automatic Backup Utility that allows the user to set a time and location to backup, repair and compact multiple databases. MS Access 97
Backup Database Utility database that backs up, repairs and compacts selected databases. MS Access 97
Boiler Plate Database 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. MS Access 97
Calculator Database 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. MS Access 97
Calendar 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. MS Access 97
Cascading Combo Boxes Database Demonstrates how to make combo boxes whose values are filtered by the value of other combo boxes in a cascade. Revised 8/25/2000 MS Access 97
Change Control Properties (Color) Demonstrates changing control properties by type of control and/or tag value selection. MS Access 97
Check User Open Mode/Number of Current Users 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. MS Access 97
Clipboard Functions Utility database that demonstrates the use of the Windows clipboardfunctionality in an Access database. MS Access 97
Color Command Buttons Tired of boring grey command buttons? How about multicolored,square, oval, stone textured, or wood textured ones? Try 'em out. MS Access 97
Color Translater 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. MS Access 97
Cross Tab Demo 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. MS Access 97
Date Fixer 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. MS Access 97
Detect and Logoff Idle Users Detects and ejects idle users after set time period. MS Access 97
E-Mail to Multiple Recipients Sends e-mail to multiple recipients and stores both the message and the addresses in the database. MS Access 97
Enumerate Processes Lists the processes that are currently running on your computer. MS Access 97
Form on the Fly Demonstrates how to create a new table, append fields and create a formbased on that table "on the fly" (in code). MS Access 97
Increment Date Demo Demonstrates how to build a date incrementing "control" without usingthird party ActiveX/VB controls. MS Access 97
Multiple Criteria 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. MS Access 97
NotInList Demo 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. MS Access 97
Password Protect a Command Button Demonstrates simple password protection routine for a command button. The routine can be adapted to protect forms, reports, and other databaseobjects. MS Access 97
Picture in Database 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. MS Access 97
Popups 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. MS Access 97
Report by Date 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. MS Access 97
Retrieve File Names Utility allows users to retrieve file names and status for selecteddirectory. MS Access 97
Shakesperean Insulter Database Self explanatory. Try it clicking "Insult Me Again" after a long hard workday. MS Access 97
Soft Command Buttons 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. MS Access 97
SoundEx Allows "fuzzy matching" of words using the SoundEx algorhythm. MS Access 97
Swap Mouse Buttons 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. MS Access 97
Toggle Edit/Read Only Form Properties 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. MS Access 97
User Tracking -- Read/Write to a Private INI File Demonstrates user logging and tracking utilizing reading/writing to a private ini file. MS Access 97
User Tracking -- Read/Write to the Windows Registry Demonstrates user logging and tracking utilizing reading/writing to the Windows registry. MS Access 97
Windows Common Dialogs Demonstrates how to invoke and control Windows Common Dialogs includingthe color, open file, and save as dialogs utilizing Windows API calls. MS Access 97
Wipe/Move/Resize Effects for Forms 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
Workday Calculation 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 97
Backup Database Utility database that backs up, repairs and compacts selected databases. MS Access 2




































Demo of the Day

Type/Version:
MS Access 2000/2002
Demo:
Cascading Combo Boxes Database
Description:
Demonstrates how to make combo boxes whose values are filtered by the value of other combo boxes in a cascade.