| HOME MS Access Professionals File Archive |
Goodies to make programming in Access a little easier. Freeware mostly created by members of our group.
| Name | Type | Uploaded By | Size | Created | Updated |
|---|---|---|---|---|---|
|
AccessCustomizations_QAT.zip Attached are QAT customization files that were exported to be easily imported back into Access to define the Quick Access Toolbar. Make your QAT more useful (display QAT below ribbon so icons don't bump into the titlebar text). For 2007, use the 2010 file. An extra gap, |, means names changed and you didn't get something ... but you will still probably have more than you had before :) ~ Hover over each icon to see its tooltip. If you already have customizations, export your customizations file. Im |
zip | crystal (strive4peace) | 1.8 kB | 6/27/2015 | 6/27/2015 |
|
AnalyzeTables2K.zip Import objects into current database and use the form to select tables to retrieve table/field information for analysis. Function will trap table name, field name, data type and field size. Table tblTestTypes is included for demonstration purposes only and can be deleted. A report is included for viewing results. This is in Access 2000 database using DAO, but can be upsized easily to XP. The code could also be copy & pasted into an Access 97 database. |
zip | Bill Mosca | 27 kB | 1/29/2006 | 1/29/2006 |
|
AutoKeys.zip AutoKeys Macro (For Access 97 & 2000 but works best in Access 97) |
zip | Bill Mosca | 30 kB | 5/4/2002 | 5/4/2002 |
|
BackMeUp.ZIP Linda Burnside's database backup utility |
ZIP | Bill Mosca | 20 kB | 1/27/2006 | 1/27/2006 |
|
Calendar_Subform_strive4peace.zip this Calendar subform can be used multiple times on the same mainform |
zip | crystal (strive4peace) | 70 kB | 6/26/2018 | 6/26/2018 |
|
CodeTracker1_0.zip Record the use, or lack thereof, of all code procedures and modules. Access 2002, 2003 and 2007. Read Instructions.txt for how to setup. |
zip | 327 kB | 7/20/2010 | 7/20/2010 | |
|
ColorPicker_by_Crystal_AD_MD_130430.zip Access tool to pick colors. I originally wrote it then a couple others added on. The ACCDB was converted from the MDB that was originally posted. It is for getting RGB (Red-Green_Blue) values for colors, along with other color information. The Colors-at-a-Glance tab was added by AD Tejpal and is arranged in a logical order for the color spectrum. It might be easier to use this tab to get RGB values that you want to try. |
zip | crystal (strive4peace) | 253 kB | 3/8/2019 | 3/8/2019 |
|
CommDlgClassSample.zip acc2000 Sample - Includes Common Dialog class for a2kdh_Vol1 |
zip | Bill Mosca | 502 kB | 5/19/2009 | 5/19/2009 |
|
Contacts_070604_Crystal.zip Access Database for Contacts -- Names, Addresses, Phones, eMail, Websites, Notes. Slick Search features. Anywhere Notes. June 2007. Contains Contacts_070604.mdb in 2000 (XP) format, and a ReadMe file. |
zip | crystal (strive4peace) | 486 kB | 5/17/2010 | 5/17/2010 |
|
Crystal_Dates___2Kmdb_TXT.zip Access 2K has 1 table called Dates with records for dates from 1990 to 2050. IsWorkday Checkbox false if date is on a weekend. DayName & HolidayNote fields -- American holidays marked for 2007-2012; logic can be extrapolated to future. Row and column is calculated for generating calendars. Date/time fields for StartDay and EndDay when workday is not midnight to midnight. FY field useful if fiscal year starts on a day other than Jan 1. Has code to make more records. |
zip | crystal (strive4peace) | 208 kB | 5/25/2012 | 5/25/2012 |
|
Crystal_Doc_Objex_090702__MDB_TXT.zip Document Form/Report and Control Properties. Find [Event Procedure] and function assignments in the property sheet (filter for [Event Procedure] or =* ). List Names, ControlSources, etc -- what is on the property sheet for controls and the main object -- very powerful -- but you will have to write your own queries and reports on the data. Import the 4 tables +1 module into the db to document. Read module comments and Field Descriptions. |
zip | crystal (strive4peace) | 44 kB | 7/2/2009 | 7/2/2009 |
|
Crystal_ReLinker_97-2007.zip Re-links tables to one or more back-ends. VBA Module and Help file. Table Descriptions updated to include connect info, keeping whatever you wrote. Supported data types include Access, Excel, Lotus, Exchange, Text, Paradox, FoxPro, and dBASE. Works with Access 97 thru Access 2007. From a module window: File, Import ... navigate to BAS file, Import, read comments, reference DAO, Compile, Save, Run, and sit back! ... More info: mssg #63074 |
zip | crystal (strive4peace) | 12 kB | 7/12/2008 | 7/12/2008 |
|
DBBuilder.zip Add-in to create all the tables in a database with one click. |
zip | Bill Mosca | 467 kB | 3/6/2004 | 3/6/2004 |
|
DH_AdHocReports.zip The DH AdHoc report writer is a complete query by form "applet" that can be easily integrated into any existing Access application. Typically, the functionality provided by this applet can replace many "canned" reports. The developer imports several forms, tables, a query, and a report from the file, creates some master queries, and deploys. |
zip | Duane Hookom | 283 kB | 11/18/2011 | 11/18/2011 |
|
ExportAll_2010_opensource.zip Upgraded version 2.4. Be sure to follow the instructions in the ReadMe file. |
zip | Bill Mosca | 270 kB | 12/18/2013 | 12/14/2020 |
|
ExportAll_opensource.zip Add-in for exporting multiple objects at once. Acc2000 Open source. |
zip | Bill Mosca | 262 kB | 3/10/2008 | 3/10/2008 |
|
FixBroken.zip Utility to attempt to "fix" a database in an older version that was opened in a newer one. Will definitely repair a 2007 accdb that was opened and modified in 2010 or later. There's also a .mdb version that may fix 2003 opened in 2007 and later. |
zip | Bill Mosca | 103 kB | 11/6/2015 | 11/6/2015 |
|
ForceUserOut.zip Allows database admin to remotely close connections into a database. Also displays contents of ldb file. Gives the admin 3 levels of control over users. No new logins, please log out message, and unconditional forceout. Please let me know if anyone sees any improvements that are needed. |
zip | Bill Mosca | 56 kB | 1/28/2004 | 1/28/2004 |
|
Form_StopWatch_Crystal_110701__MDB_TXT.zip Simple Stopwatch. Opens to a form with command buttons to Start Time, Stop Time, and Reset. Elapsed time is displayed every half second as time passes. |
zip | crystal (strive4peace) | 24 kB | 7/1/2011 | 7/1/2011 |
|
GraphExample_Crystal_140812_9p__ACCDB_TXT.zip Numbers look so much better on charts! This is an (updated) example of how to set graph properties in Access using VBA based on specified criteria such as dates and key fields. The menu is called f_Graph_MENU. The form that shows the graph is f_Graph. f_PopupCalendar is a for collecting dates (tiggered by double-clicking a date control). The sample tables are called t_GraphData and t_GraphTopics. The code creates the qGraph query used by the graph. This was developed in 2010 using Microsoft Graph 14 |
zip | crystal (strive4peace) | 330 kB | 8/12/2014 | 8/12/2014 |
| GoTo Top | |||||
|
LinkToNewBackEnd.zip This db allows a user to specify a new Back End to a database for all of the linked tables. Enjoy. |
zip | Bill Mosca | 37 kB | 11/18/2003 | 11/18/2003 |
|
ListFiles_080323_Crystal.mdb Reads file name and file attribute information into a database -- can be done for one directory or a diretory tree. NEEDS references to Microsoft Scripting Runtime, Microsoft DAO Object Library. Browser code originally written by Stephan Lebans. Recursive File list modified from code witten by Allen Browne. GetComputerName written by Dev Ashish. Best to Compile before you run. Look at Relationship diagram and Field Descriptions in each Table Design. |
mdb | crystal (strive4peace) | 1.5 MB | 7/20/2009 | 7/20/2009 |
|
Module_with_API_for_resizing_Access.zip Import this module into Access and then you can create an AutoExec that resizes Access |
zip | Dan Koster | 2.5 kB | 3/15/2004 | 3/15/2004 |
|
MZTools3VBASetup.zip VBA add-in with many tools to make coding faster. You can store code snippets, set up error handling and other templates. |
zip | Bill Mosca | 1.2 MB | 3/16/2016 | 3/16/2016 |
|
PickDate_071114.zip Popup Date and Time Picker. Forms --> f_PickDate (popup calendar with Date and Time), f_PickDate_Test (form to demonstrate use of f_Pickdate). Module --> bas_f_PickDate_crystal (one procedure, Open_FormPop, look at remarks for information) |
zip | Bill Mosca | 39 kB | 11/14/2007 | 11/14/2007 |
|
PopupCalendar_Crystal_120701_ACCDB_TXT_notCompiled~APros.zip Popup Calendar that works with Access 2007 and above! Now with colors! f_PopupCalendar_Test loads automatically when this database is opened. COMPILE THE CODE FIRST!!! To use this feature in another database, import: f_PopupCalendar. I usually assign this Double-Click [Event Procedure] to each date control: DoCmd.OpenForm "f_PopupCalendar" ~~ Feedback is appreciated! Screenshots here: http://www.RogersAccessLibrary.com/forum/popup-calendar-for-access-2007-and-above_topic597.html |
zip | crystal (strive4peace) | 64 kB | 7/1/2012 | 7/1/2012 |
|
PropertiesSetter_2010.zip 20007-2010 version |
zip | Bill Mosca | 442 kB | 7/15/2012 | 7/15/2012 |
|
PropertiesSetter_Acc2007.zip Access 2007 version |
zip | Bill Mosca | 215 kB | 1/26/2012 | 1/26/2012 |
|
PropertiesSetter_Acc97.zip Older version of Properties Setter - Access 97 version |
zip | Bill Mosca | 574 kB | 12/25/2005 | 12/25/2005 |
|
PropertiesSetter_opensource_Acc2003.zip Database Properties setter (open source version). Can be used to change properties of an MDB or MDE without opening the target database. Set such properties as AllowByPass so shift key can be used to bypass startup. Works on secured files, too. |
zip | Bill Mosca | 209 kB | 1/17/2012 | 1/17/2012 |
|
PropertiesSetter_opensource_Acc2007__ACCDB.zip Bill Mosca's Property Setter as an open source Access 2007 database. This is a must for every toolkit! |
zip | crystal (strive4peace) | 212 kB | 1/27/2012 | 1/27/2012 |
|
ptreplicator-setup.zip Great file backup utility. Keep a history of your dev application in case you blow up the copy you are working on. Karen passed away a while back so I don't know how long her family will keep the website up. Best get all the rest of her tools before they go away. |
zip | Bill Mosca | 2.0 MB | 7/9/2012 | 7/9/2012 |
|
RecordSource2000.zip Record Source documenter fixed so it runs in 2000. |
zip | 65 kB | 1/30/2006 | 1/30/2006 | |
|
RecordSourceDoc.zip Ever inherit an MDB file and wonder which objects are *really* used? This utility documents the RecordSource information for each form and report in a database. |
zip | mr_ericdb | 159 kB | 5/28/2004 | 5/28/2004 |
|
Report_View_Filtering.Accdb Builds custom report shortcut menus and adds custom filtering for text and numeric fields for Report View for ALL the reports in your database. See instructions embedded in the modReportViewFiltering module. Code courtesy of Peter Weinwurm and John Viescas |
Accdb | Bill Mosca | 397 kB | 10/31/2014 | 10/31/2014 |
|
SaveLoadText.zip Add-in to save objects as text and load those objects from the saved text files. Requires Access 2000 or higher. |
zip | Bill Mosca | 30 kB | 1/5/2007 | 1/5/2007 |
|
SaveLoadText_2003.zip SaveLoadText: GIU that saves or loads from text |
zip | Bill Mosca | 31 kB | 7/2/2007 | 7/2/2007 |
|
SaveLoadText_97.zip Same as the one for 2003. |
zip | Bill Mosca | 45 kB | 7/2/2007 | 7/2/2007 |
|
SecurityMgr.zip Security Manager - This one is from Microsoft. It gives you a nice interface when working with user and user group permissions. |
zip | Bill Mosca | 223 kB | 10/27/2006 | 10/27/2006 |
|
ShowUserRoster3.4_opensource.zip This Add-in shows who is in a database and includes a option to lock the database from allowing more logins and an option to force current users out. Be sure to unzip it directly to your C drive so it installs correctly. Includes a ReadMe file with instructions and a sample database. Opensource Acc2000. |
zip | Bill Mosca | 229 kB | 3/10/2008 | 3/10/2008 |
| GoTo Top | |||||
|
showusers.zip This is a limited utility based on the Show Users Roster. It is an Access application that will show the users of any database. |
zip | Bill Mosca | 17 kB | 10/13/2005 | 10/13/2005 |
|
SizeAll_Toolbar.zip SizeAll Toolbar as presented in TOW |
zip | Bill Mosca | 12 kB | 8/24/2006 | 8/24/2006 |
|
SQLToString97_EXE.zip Access97 - Same as SQLToStringver2. Zipped up EXE file you run and is self-extracting. Extract to C:\ drive. |
exe | Bill Mosca | 103 kB | 5/23/2004 | 5/23/2004 |
|
SQLToVBAString_ver2_EXE.zip Access 2K - Add-in which converts SQL to a VBA string that can be pasted directly into a module. Zipped up EXE file you run and is self-extracting. Extract to C:\ drive. |
exe | Bill Mosca | 94 kB | 11/1/2003 | 11/1/2003 |
|
TableRestorer.zip Add-in for recovering the last deleted table. Unzip to C drive for proper installation. |
zip | Bill Mosca | 265 kB | 6/9/2003 | 6/9/2003 |
|
Vba2html.zip VBA to HTML Converter by Bykin |
zip | Bill Mosca | 169 kB | 7/22/2009 | 7/22/2009 |
|
VBATips_PerformanceTests.zip Tips and Performance Testing by Ken Getz |
zip | Bill Mosca | 159 kB | 3/3/2004 | 3/3/2004 |
|
VideoCaptions_140617_Crystal__accdb.zip Tool to create Caption files for videos. Reads text file with transcription (the fast way to get captions in) and lets you type captions into record. Set timer, watch video, click on each caption as it is said, generate caption file with unicode support (uses ADO stream) for you to upload. You can edit captions/time-codes and replace caption file ... anytime ... even 5 years later! Captions help a lot of people. |
zip | crystal (strive4peace) | 227 kB | 6/19/2014 | 6/19/2014 |
|
WriteToWord_MDB_DOT_TXT__Crystal.zip Example to create a Word document and populate it with information from Access. Contains a DOT file (Word Document Template, WriteToWord.DOT), an MDB file (Access Database, WriteToWord.mdb), and a TXT file with code and comments. |
zip | crystal (strive4peace) | 40 kB | 6/20/2011 | 6/20/2011 |