Print Page | Close Window

ALPHABETICAL INDEX TO SAMPLES

Printed From: Roger's Access Library
Category: Roger's Access Library
Forum Name: Roger's Download Samples
Forum Description: A compendium of Microsoft Access 97 and 2000+ routines, each separated into its own sample database.
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=218
Printed Date: 17 Dec 2017 at 4:26pm


Topic: ALPHABETICAL INDEX TO SAMPLES
Posted By: Roger Carlson
Subject: ALPHABETICAL INDEX TO SAMPLES
Date Posted: 14 Jul 2008 at 11:09pm
The follow is a compendium of Access routines, each separated into its own database. Each database illustrates one or more possible solutions to a single problem. They are not intended to be fully functioning utilities, but rather an illustration of how the problem might be solved and are therefore intended for educational use. These routines are entirely free. You may use them anywhere and in any way you choose, with or without citation. Therefore, you agree to use them at your own risk.  There is no warranty implied and I am not responsible for any damages that might result from their use.

 Note: Files designated "Access 2000 DAO" use the DAO data model and require a reference to DAO set in Access versions 2000 and 2002 (XP). Files designated "Access 2000 ADO" do not require this reference, but may need a reference to ADOX set. Files designated "Access 2000" do not use a data model.

 If you don't understand the above, or are having problems with User Defined Variables, http://rogersaccesslibrary.com/References.htm" rel="nofollow - Click Here

 A

  • forum_posts.asp?TID=529" rel="nofollow - ActionQueries.mdb (beginner)
    Sample with Documentation.
    Illustrates simple Action (DML) queries.
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=402" rel="nofollow - ActionQueriesInCode.mdb ( beginner )
    Sample with Documentation. Illustrates how to suppress confirmation messages when running an Action query in VBA code.
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=401" rel="nofollow - AmbiguousOuterJoins.doc ( beginner )
    Document with sample database. Examines the Ambiguous Outer Join error.
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=400" rel="nofollow - Animation.mdb ( intermediate )
    This sample shows how to implement a variety of simple animations in an Access Form.
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=522" rel="nofollow - AppendValuesToExcel.mdb
    This sample demonstrates how to append data from a database to an Excel spreadsheet using Office Automation to find the next empty row in the spreadsheet.
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=399" rel="nofollow - AuditTrail.mdb ( intermediate )
    This sample illustrates one way to produce a simple audit trail table containing: machine name, login name, user name (access security), record number, field name, original value, new value, and a date/time stamp.  For a more complete audit trail application, see my sample  http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=398" rel="nofollow - AuditTrail2.mdb .
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=398" rel="nofollow - AuditTrail2.mdb ( advanced )
    This sample is a more advanced version of http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=399" rel="nofollow - AuditTrail.mdb
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=397" rel="nofollow - AutomatingPowerpoint.mdb ( intermediate ) uploads/5/AutomatingPowerpoint2k.zip" rel="nofollow -
    A simple example of automating the creation of a Powerpoint Presentation from Access.
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=396" rel="nofollow - AutomatingWordFromAccess.mdb ( advanced)
    This sample demonstrates how to create a Microsoft Word document from information stored in a database and charts stored in an Excel spreadsheet.
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=395" rel="nofollow - AutonumberProblem.mdb ( beginner )
    This sample illustrates a number of ways to simulate your own Autonumber primary key.
B
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=394" rel="nofollow - BackUpWithCompact.mdb ( intermediate )
    This sample illustrates how to back up a database using the Compact Method. It creates a backup file called "BackUpWithCompact2kXX_XX_XXXX.mdb" with the X's representing the data. It puts this file in the same directory as the database.
  • http://www.rogersaccesslibrary.com/forum/topic555_post570.html" rel="nofollow - BeginDateEndDateQuery.mdb (beginner)
    This sample illustrates how to create a  query which displays the BeginDate and EndDate of a range based on a single EffectiveDate stored in the table.  It is assumed that the Effective Date range of a record spans the time from the Effective date of the current record and the Effective Date of the NEXT record (minus 1).  There are three methods shown here: Using a 1) correlated subquery, 2) DMax domain aggregate function, and 3) LEFT OUTER JOIN.
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=393" rel="nofollow - BoilerPlate.mdb ( intermediate )
    This sample is a useful template for an application.
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=392" rel="nofollow - BoilerPlate2.mdb ( intermediate )
    This sample is a useful template for an application. It is mostly the same as Boilerplate.mdb but with a different MainDataEntry Form.
    http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=391" rel="nofollow - Books.mdb ( intermediate )
    "Books.mdb" and it's companion database "Books_be.mdb", make up a simple personal book inventory database. It uses the "BoilerPlate.mdb" sample to create a complete application.
C

  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=390" rel="nofollow - CalculateSpec.mdb ( intermediate )
    This sample automatically calculates the Start Bit of an ImportSpec by adding the Start Bit and Length of the previous record.
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=389" rel="nofollow - CascadingComboBoxes.mdb ( beginner )
    This sample illustrates how to restrict the value of one combo box based on the value of another.
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=388" rel="nofollow - CascadingComboInSubform.mdb ( intermediate )
    Illustrates how to use Cascading Comboboxes in a continuous subform.
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=387" rel="nofollow - ChangingColorFields.mdb ( Access 97 Only)
    This sample illustrates how to change the color of a control on a form based on information in the form. In this case, if Check 14 checkbox is checked then the values of Desc will be red, otherwise it will be blue. Access 97 ONLY.  For higher versions (Access 2000+) see my sample  http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=375" rel="nofollow - ConditionalFormatting.mdb .
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=386" rel="nofollow - CharacterScramble.mdb ( intermediate )
    This application illustrates to scramble character data WITHIN A FIELD. To Randomize FIELDS WITHING A TABLE, see my sample http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=357&PN=1" rel="nofollow - Datascramble.mdb .
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=528" rel="nofollow - ChooseQueryFromList.zip
    This sample shows how to display all the queries in your database in a listbox and run them with a button.
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=385" rel="nofollow - ChooseReportFields.mdb ( intermediate )
    This sample very roughly illustrates how to create a query programmatically which chooses the FIELDS to be reported on a report based on the selected values of a multi-select list box.
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=384" rel="nofollow - ChooseReportFieldsRows.mdb ( advanced )
    This sample very roughly illustrates how to create a query programmatically which chooses the FIELDS to be reported on a report based on the selected values of a multi-select list box and then allows the user to specify the ROWS to be reported.
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=383" rel="nofollow - ChooseReportFromList.mdb ( beginner )
    These forms illustrate how to create a clean form for launching reports.
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=382" rel="nofollow - ChooseReportFromList2.mdb ( intermediate )
    These forms illustrate some advanced features in a "Report Switchboard". For less complex examples, see "ChooseReportFromList.mdb"
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=381" rel="nofollow - ChooseReportFromList3.mdb ( intermediate )
    This sample shows an alternate way to open reports with a parameter form. It allows the user to select either a report directly or a form in which they can choose a parameter for the report.
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=380" rel="nofollow - CleanFileHTML.mdb ( intermediate )
    This sample removes the HTML tags from an html document and writes it into a separate text file. See Module 1 for the code.
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=379" rel="nofollow - ComboChoosesRecord.mdb ( beginner )
    This illustrates how to have a combo box in which you can choose a value and have that record appear in the form.
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=378" rel="nofollow - CompactBackEndDB.mdb ( advanced )
    Illustrates how to compact a Back-End database from the Front-End.
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=377" rel="nofollow - CompactDatabase.mdb ( advanced )
    This sample illustrates how to compact the current database programmatically. It assumes that the tables reside locally. (To compact a Back-end database, see my sample "CompactBackEndDB.mdb".)
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=376" rel="nofollow - CompareTwoTables.mdb ( intermediate )
    This sample shows how you can programmatically compare two tables and write out the differences to a third table.
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=375" rel="nofollow - ConditionalFormatting.mdb ( beginner )
    This sample illustrates how to change the color of a control on a form based on information in the form. In this case, if Check 14 checkbox is checked then the values of Desc will be red, otherwise it will be blue. This does not work with Access 97 and earlier.  For those, see my sample http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=387" rel="nofollow - ChangingColorFields.mdb .
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=374" rel="nofollow - ContinuousFormWithNewRecordOnTop.mdb ( intermediate )
    This sample illustrates two ways to have a continous form with the new record on top. The first method uses unbound controls in the header of the form and the second uses a bound subform set to Data Entry.
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=373" rel="nofollow - ConvertDateTimeToFormattedString.mdb ( intermediate )
    This sample shows how to calculate the difference between two times and display the result in 'xx days, xx hours, xx minutes' format.
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=372" rel="nofollow - ConvertStringStuff.mdb ( intermediate )
    Demonstrates how to convert a variety of strings into their numeric equivalents and back.
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=371" rel="nofollow - CopyObjectsFromBE.mdb ( intermediate )
    This sample demonstrates how to copy objects from the Back-End database into the Front-End. In this specific case the objects are queries.
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=370" rel="nofollow - CreateDescriptionProperty.mdb ( intermediate )
    This sample demonstrates how to create and modify the "Description" property of the following Database objects: Tables, Table Fields, Queries, Query Fields, Forms, Reports, Macros, and Modules.
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=369" rel="nofollow - CreateMultiSelectQuery.mdb ( intermediate )
    This database illustrates how to create a query programmatically based on the selected values of a multi-select list box.
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=368" rel="nofollow - CreateQueries2.mdb ( intermediate )
    This database illustrates several examples of programmatically creating queries.
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=367" rel="nofollow - CreateQueries3.mdb ( intermediate )
    This form shows how to create a query programmatically from a form with option boxes.
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=366" rel="nofollow - CreateQueries4.mdb ( advanced )
    This form illustrates how to create a relatively flexible inter-active query facility for an end-user. It allows you to choose the table, then shows the fields available for that table and then values available for the fields.
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=365" rel="nofollow - CreateQueries5.mdb ( advanced )
    This set of samples illustrate how to create a flexible query generator for your users. It is similar to CreateQueries4.mdb, but no longer limits the query to 3 criteria.
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=364" rel="nofollow - CreateQueryFields.mdb ( intermediate )
    This sample illustrates how to programmatically create a query based on a table or another query and select only those fields that you want to see. It also has a form, which shows how to restrict the rows based on a criteria.
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=363" rel="nofollow - CreateTableFromLinked.mdb ( intermediate )
    This sample illustrates how to create a native Access 2000 table from a linked Excel table. This process can be easily modified to do the same thing for linked Text or ODBC tables.
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=362" rel="nofollow - CrossTabReport.mdb ( intermediate )
    The problem with crosstab queries has always been that if you try to make a report based on one, you inevitably have problems with field names when the crosstab changes. This sample demonstrates how you can get around this problem.
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=361" rel="nofollow - CSVtoFixed.mdb ( intermediate )
    This sample reads a CSV file and exports it as a fixed width file. Module 1 (CSVtoFixed) does the entire process in code. For very large records, Module 2 (CSVtoFixed2) uses a table to allow you to create your own Export Spec.
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=360" rel="nofollow - CurrentTab.mdb ( beginner )
    This form illustrates how to programmatically scroll between tabs of a tab control on a form. See the code behind the buttons for details.
D
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=359" rel="nofollow - DAO.mdb ( beginner )
    This database contains various examples of Data Definition Language (DDL) and Data Manipulation Language (DML) of both DAO and SQL.
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=570&title=data-definition-language-sql-vs-dao" rel="nofollow - Data Definition Language: SQL vs DAO
    This sample (with full documentation) illustrates how to do a variety of DDL (Data Definition Language) operations using both SQL and DAO.  DDL operations are those that modify the database structure, ie. tables, fields, indexes, and relationships.
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=358" rel="nofollow - DataEntryMask.mdb ( beginner )
    This sample illustrates a way to restrict what kind of characters are input into a textbox without using an input mask. This method checks the characters as they are typed and only allows legal characters.
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=357" rel="nofollow - DataScramble.mdb ( intermediate )
    This application illustrates how to scramble data in a table for confidentiality reasons. To scramble Text data WITHIN A FIELD, see my sample http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=386" rel="nofollow - CharacterScramble.mdb . 
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=356" rel="nofollow - DateStuff.mdb ( intermediate )
    This example illustrates how to do a variety of date calculations like: First day of Month, Last Day of Month, First Day of Next Month, First Day of Current Week, Last Day of Current Week, First Day of Current Work Week, Last Day of Current Work Week.
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=445" rel="nofollow - DaysBetweenQuery.mdb ( beginner )
    This sample illustrates how to create a "Days Between" query, that is, display the difference between dates in subsquent records of a table.
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=355" rel="nofollow - DeleteTablesAtStart.mdb ( beginner )
    This sample illustrates how to delete ImportError tables at start up. For illustration purposes, the RunMacro button executes the code, but if you rename the macro to AutoExec, it will run each time the database opens.
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=354" rel="nofollow - Denormalize.mdb ( intermediate )
    This example takes data in a normalized table and writes it to another table in denormalized form.
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=353" rel="nofollow - DirectoryList.mdb ( intermediate )
    This sample shows how to "role your own" directory/file list.
E
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=352" rel="nofollow - EmailingSpecificReports.mdb ( advanced )
    This illustrates how to email the same report with different data to a variety of users.
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=442" rel="nofollow - ERMaster.ppt  
    Not an Access sample, but a useful Powerpoint template for creating ER Diagrams.
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=351" rel="nofollow - ExportFormattedFixed.MDB ( intermediate )
    This shows how to export to a fixed width text file programmatically.
  • http://www.rogersaccesslibrary.com/forum/exporttoexcel-automation-advanced_topic624.html" rel="nofollow -
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=350" rel="nofollow - ExportToExcel.mdb ( intermediate )
    This sample demonstrates how to export data from a database using the TransferSpreadsheet method, but have the data populate a formatted spreadsheet. The trick here is to export the data to a NEW tab in the Excel workbook and link the fields from the new tab into the formatted spreadsheet.
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=349" rel="nofollow - ExportToExcelCharts.mdb ( intermediate )
    Sample with Documentation. This sample demonstrates how to export data from a database using the TransferSpreadsheet method, but have the data populate a Chart. The trick here is to export the data to a NEW tab in the Excel workbook and link the fields from the new tab into the chart.
  • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=348" rel="nofollow - ExpressionEvaluation.mdb ( intermediate )
    This form illustrates how to make a pop-up dialog to calculate values to put into a field on a form.
  • F
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=347" rel="nofollow - FlatFileDemo.mdb ( beginner )
      This example illustrates some of the difficulties inherent in bad (non-normalized) database design and how they can be corrected. It is not a formal tutorial on Normalization, rather it is a series of examples which allow you to demonstrate the kind of trouble that a non-normalized can produce. I use this example in my classes as an introduction to why you would want to normalize a database design.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=346" rel="nofollow - FormSubform.mdb ( beginner )
      This form illustrates how to use Domain functions to do a variety of tasks in a Form/Subform situation.
    G
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=345" rel="nofollow - GetPathFileName.mdb ( intermediate )
      This form shows how to extract just the Path or just the File name from the db.Name property.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=344" rel="nofollow - Greenbar.mdb ( beginner )
      This sample illustrates how to make your report a "greenbar" report, that is one that has alternating lines of color. Check behind the individual reports for the relevant code.
    H
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=343" rel="nofollow - HasContinued.mdb ( intermediate )
      This example illustrates two methods of how to work around the 'HasContinued' bug, so that you can get a 'Continued' status for group headers within a report.
    I
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=342" rel="nofollow - ImplementingM2MRelationship.mdb ( beginner )
      This example illustrates two different methods of implementing in a form a Many-to-Many relationship that has been resolved by a linking table.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=341" rel="nofollow - ImportHTML.mdb ( intermediate )
      This sample illustrates how to use the LineInput statement to import text from a text file in an extremely unconventional format. The file is an HTML file, and the code searchs for the HTML tags to find specific information and puts that in a field.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=340" rel="nofollow - ImportLineInput.mdb ( intermediate )
      This sample illustrates how to use the LineInput statement to import text from a text file with a mixed format. Each line of the file is a separate record, but is delimited in a variety of ways.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=339" rel="nofollow - ImportSpreadsheet.mdb ( intermediate )
      This sample illustrates 3 things: 1) How to back up a database using the Compact Method, 2) Create a native Access 2000 table from a linked Excel table 3) Import data to an existing table.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=338" rel="nofollow - ImportToTempDatabase.mdb ( intermediate )
      This illustrates how to programmatically create a database to hold a temp table for updating.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=337" rel="nofollow - ImproveFormPerformance.mdb ( intermediate )
      One way to improve the performance of a form that is bound to a LARGE dataset is to split the data into smaller chunks. This form uses the "Phonebook" method to do that. Click one of the 27 buttons at the top and the form will show you only those records in the table that start with the corresponding letter.
    K
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=336" rel="nofollow - KeepingDatabasesInSync.mdb ( Access 97 Only )
      Illustrates a method for keeping Access Front-Ends in sync with a Master Network Copy. Uses a DOS batch file.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=335" rel="nofollow - KeepingDatabasesInSync2.mdb ( intermediate )
      Illustrates a method for keeping Access Front-Ends in sync with a Master Network Copy. This is an "All Access" solution, so does not require a batch file.
    L
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=334" rel="nofollow - LinkTables.mdb ( intermediate )
      This example illustrates how to programmatically link tables from a users designated database.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=333" rel="nofollow - LinkTextFiles.mdb ( intermediate )
      This sample illustrates how to programmatically link TEXT files to your database.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=332" rel="nofollow - ListBoxExcludeOnClick.mdb ( intermediate )
      This sample illustrates two ways to remove a value from a bound list box after it has been selected (double-clicked).
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=331" rel="nofollow - ListBoxSetTableValue.mdb ( intermediate )
      This sample illustrates how to use a list box to update a "Selected" field in a table and also read which items are selected in the table and set those list box items to True.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=330" rel="nofollow - ListBoxSorting.mdb ( intermediate )
      This sample database show various ways of sorting a listbox by clicking on the header of each column.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=329" rel="nofollow - ListboxSubform.mdb ( intermediate )
      This sample illustrates use a list box to simulate a simple subform. The user can either double-click the listbox or click the edit button. Then a popup form appears which allows him to select multiple values. These values are written to a separate tab.
    • http://www.rogersaccesslibrary.com/forum/topic328.html" rel="nofollow - LogUsersOff.mdb ( intermediate )
      This sample illustrates how to automatically log all of your users out of an application for maintenance purposes.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=327" rel="nofollow - LogUsersOffNonUse.mdb ( intermediate )
      This sample illustrates how to automatically log your user out of an application after a period of inaction.
    M
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=326" rel="nofollow - MaxQueryProblem.mdb ( beginner )
      The Problem: You want to create a query which will return a MAX Date and the corresponding Amount, grouping them on the Customer Name.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=325" rel="nofollow - Median.mdb ( intermediate )
      Surprisingly, Access has no Median function, so you have to write one of your own. This sample database shows how to do that.
    • http://www.rogersaccesslibrary.com/forum/topic557_post572.html" rel="nofollow - Mode.mdb (intermediate)
      Access has no Mode function, so you have to write one of your own.  This sample database shows how to do that. 
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=324" rel="nofollow - MoveList1.mdb ( intermediate )
      This example illustrates how to move values between list boxes much like many of the Access wizards.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=323" rel="nofollow - Movelist2.mdb ( intermediate )
      Illustrates how to move values between multi-select list boxes much like many of the Access wizards.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=322" rel="nofollow - MoveUpDownList.mdb ( intermediate )
      This sample illustrates how to make items in an unbound listbox move up and down in the list.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=321" rel="nofollow - MoveUpDownSubform.mdb ( intermediate )
      This form illustrates how to make items in a bound subform move up and down in the form.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=320" rel="nofollow - MultiColumnListBox.mdb ( beginner )
      Access Listboxes do not allow multiple columns that 'snake'. In order to build the funtionality, you must use multiple listboxes. This sample shows how.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=319" rel="nofollow - MultipleLabels.mdb ( intermediate )
      This form illustrates how to print multiples of specific labels.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=318" rel="nofollow - MultipleLabelsOffset.mdb ( intermediate )
      This sample is a more complete version of http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=319" rel="nofollow - MultipleLabels.mdb . It is meant to be a simple minded stand-alone address label program.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=317" rel="nofollow - MultipleLabelsOffsetBatch.mdb ( intermediate )
      This sample is a similar to http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=318" rel="nofollow - MultipleLabelsOffset.mdb , but prints multiple labels for multiple people in a batch.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=519" rel="nofollow - MultipleLabelsOffsetBatch2.mdb (intermediate)
      This sample is a similar to http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=317" rel="nofollow - MultipleLabelsOffsetBatch.mdb , but adds the ability to have different numbers of labels for each address.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=316" rel="nofollow - MultiSelect.mdb ( intermediate )
      Form illustrates two methods how to write values selected in a multi-select list box into a table.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=315" rel="nofollow - MultiSelectListboxes.mdb ( intermediate )
      Illustrates how to perform a number of operations involving multi-select listboxes. Including: 1) Select/Unselect all values, 2) Illustrate two methods to read values, 3) Create a query based on selected values, 4) Simulate a "bound" multi-select listbox.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=314" rel="nofollow - MultiSelectProblem.mdb ( Access 97 Only )
      There are two methods of moving data from a multi-list select box. This form illustrates why the ItemsSelected collection is not reliable in Access 97.
    N
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=313" rel="nofollow - NoDataInReports.mdb ( beginner )
      This sample illustrates how to cancel a report that has no data in it, using the OnNoData event of the report.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=312" rel="nofollow - NormalizeDenormalize.mdb ( intermediate )
      It illustrates how to take a table which has fields like Value1, Value2, Value3,... and writes them into a table which has one field (Value) with each of the values in a new record rather than having them all in one record.
    • forum_posts.asp?TID=562&title=normalizingrepeatingcolumns1" rel="nofollow - NormalizingRepeatingColumns1  (beginner)
      Document Included
      This sample demonstrates how to normalize a simple PC_Inventory table.  Its purpose is to demonstrate the general principles of normalizing denormalized data from a spreadsheet.
    • http://www.rogersaccesslibrary.com/forum/normalizingrepeatingcolumns2-beginner_topic563.html" rel="nofollow - NormalizingRepeatedColumns2 (beginner)
      Document IncludedThis sample demonstrates how to normalize a PC_Inventory table that has two sets of repeated columns.  It's purpose is to demonstrate the general principles of normalizing denormalized data from a spreadsheet.
    • http://www.rogersaccesslibrary.com/forum/normalizingrepeatingcolumns3mdb_topic564.html" rel="nofollow - NormalizingRepeatedColumns3 (beginner)
      Document IncludedThis sample demonstrates how to normalize a table that has repeated Yes/N0 columns.  It's purpose is to demonstrate the general principles of normalizing denormalized data from a spreadsheet.
    • http://www.rogersaccesslibrary.com/forum/normalizingrepeatingcolumnsvbamdb_topic567.html" rel="nofollow - NormalizingRepeatingColumnsVBA.mdb
      Document Included
      This sample demonstrates how to normalize a table that has repeated columns with VBA.  It's purpose is to demonstrate the general principles of normalizing denormalized data from a spreadsheet with code rather than SQL statements. 
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=311" rel="nofollow - NotInList.mdb ( intermediate )
      This sample illustrates a variety of ways to use the NotInList event of a combo box.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=310" rel="nofollow - NotInListAlternatives.mdb ( intermediate )
      This sample illustrates several methods other than Not In List to add new records to a combo box that is Limited to the List.
    • http://www.rogersaccesslibrary.com/forum/topic309.html" rel="nofollow - NumberedQuery.mdb ( beginner )
      Sample with Documentation. This sample illustrates two different ways to create a query with a sequenced number column.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=308" rel="nofollow - NumberPad.mdb ( beginner )
      This sample shows how to create a number pad for inputting a Social Security Number.
    O
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=307" rel="nofollow - OpenArgs.mdb ( intermediate )
      This application illustrates how to use OpenArgs to solve a variety of problems.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=306" rel="nofollow - OrderListBox.mdb ( intermediate )
      This sample shows how to make a listbox reorder by clicking on the column header. It also shows how to use the same button to sort ASC or DESC
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=305" rel="nofollow - Ordinals.mdb ( intermediate )
      Ordinals are ordered numbers: 1st, 2nd, 3rd, 4th,...etc. This function shows how to add the correct suffix to any positive integer.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=304" rel="nofollow - "Other"Problem.mdb ( advanced )
      This example shows one method of handling the situation where the user wants a combo box to pick from, but also wants to have an "Other" category where they can add free-text qualifying the "Other".
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=303" rel="nofollow - OutputText.mdb ( intermediate )
      This illustrates a simple way to precisely format data for text output.
    P
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=302" rel="nofollow - ParaQueryDelete.mdb ( beginner )
      Illustrates a couple of different ways to use Delete parameter queries from forms.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=301" rel="nofollow - ParaQuerySelect.mdb ( beginner )
      This form illustrates how to send parameters to a parameter query via a form.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=300" rel="nofollow - ParseStuff.mdb ( beginner )
      The included modules demonstrate a variety of parsing problems, where information in one field needs to be put into several fields.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=449" rel="nofollow - ParseMultivalueFieldTonormalizedStructure.mdb
      This sample illustrates how to write values from a multiple valued field (not the Access 2007 multi-value field) into a normalized Many-to-Many structure. 
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=299" rel="nofollow - PasswordGenerator.mdb ( intermediate )
      This sample creates a random password of a given length. Passwords are composed of numbers, lower case letters, and upper case letters.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=298" rel="nofollow - Pictures.mdb ( beginner )
      It is usually preferable NOT to store OLE objects like pictures in the table itself. It causes massive database bloat. The usual solution is to store the pictures as files on the hard drive and store the file name in the table.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=297" rel="nofollow - PicturesLoad.mdb ( intermediate )
      This sample demonstrates how to use the OpenSaveFile API to find the picture file you want loaded into the database.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=516" rel="nofollow - PreviousDateQuery.mdb (beginner)
      This sample illustrates how to create a Previous Date query.  It shows how to: 1) Display the previous date in subsquent records of a table or 2) Display the previous date in subsquent records of a table  over a group.  
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=296" rel="nofollow - PrintingSpecificReports.mdb ( advanced )
      This illustrates how to print the same report multiple times with different data.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=295" rel="nofollow - PrintMultipleLabel.mdb ( intermediate )
      This form illustrates how to print multiple labels which matches the value of the record in the form.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=294" rel="nofollow - PrintOneLabel.mdb ( intermediate )
      This form illustrates how to print one label which matches 'the value of the record in the form.
    R
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=293" rel="nofollow - RandomRecords.mdb ( beginner )
      This application shows how to return a specific number of random records from a table.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=292" rel="nofollow - ReadTableFields.mdb ( advanced )
      This sample demonstrates a couple of uses for Reading the table structure programmatically.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=291" rel="nofollow - ReallyBadDesignDecisions.doc ( beginner )
      Document with Sample Databases. Case study of a really bad database design based on the assumption that the paper form should determine the database design. This ZIP file contains two databases: "ReallyBadDatabase.mdb" and "ReallyBadDatabaseReborn.mdb".
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=290" rel="nofollow - RecordNavigation.mdb ( intermediate )
      This form illustrates how to exactly duplicate the actions of the default record navigation buttons including the RecordNumber Of TotalRecords feature.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=289" rel="nofollow - RecreateTableInSQL.mdb ( expert )
      This sample will read the table structure of the table selected in the listbox and programmatically build a series SQL statements to recreate the table and all indexes. The SQL Statements are saved in a script file with a .sql extension.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=288" rel="nofollow - Reduce97.mdb ( advanced )
      This was originally designed as a way to delete large amounts of data from very large databases.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=286" rel="nofollow - RelinkOnOpen.mdb ( intermediate )
      This sample illustrates how to automatically relink the tables if the database has been moved.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=285" rel="nofollow - RemoveDuplicates.mdb ( beginner )
      Illustrates a method for removing duplicate records from a table.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=284" rel="nofollow - RemoveSpaces.mdb ( beginner )
      This sample removes the spaces and carriage returns from text typed into the text box.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=283" rel="nofollow - ReportInBackEndDatabase.mdb ( intermediate )
      This sample illustrates how to run a report that exists in the Back-End database.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=282" rel="nofollow - ResettingReportPageNumbers.mdb ( beginner )
      This sample illustrates how to reset page numbers back to 1 for each group when grouping a report.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=281" rel="nofollow - ReturnSQLfromQuery.mdb ( beginner )
      This sample demonstrates how to read the SQL statement from a saved query using the .SQL property of the querydef object.
    • http://www.rogersaccesslibrary.com/forum/rollingaveragesmdb_topic544.html" rel="nofollow - RollingAverages.MDB T
      his sample illustrates two different ways to create a "Rolling Average" query.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=280" rel="nofollow - RoundingStuff.mdb ( beginner )
      This sample shows a variety of rounding techniques, the most common being rounding to the nearest x decimal places. The function RoundIt is similar to the Round function in VB. All the code is stored in the basRounding module.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=611" rel="nofollow - RunProcessesAndExport.mdb ( intermediate)
      This sample illustrates a flexible way to automate the batch processing of queries.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=279" rel="nofollow - RunningSumInQuery.mdb ( beginner )
      Sample with Documentation. - This sample illustrates how to create a Running Sum in a query.
    • RunRemoteMacro.mdb ( intermediate )
      This sample illustrates how to run a macro in a remote database to automate a process.
    S
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=277" rel="nofollow - SaveFileToSpecificDirectory.mdb ( intermediate )
      This sample shows how to use the Windows API to bring up the OpenSaveFile dialog box and save a file to a directory of your choosing.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=276" rel="nofollow - SeekWithLinkedTable.mdb ( intermediate )
      It is usually said that the Seek method cannot be used with a linked table. This is true, it cannot. However, it WILL work if you open the table in the remote database explicitly with the OpenDatabase method. This sample illustrates how to do this.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=275" rel="nofollow - SelfJoin.mdb ( intermediate )
      Demonstrates a number of ways to use a Self-Join in Access 97.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=274" rel="nofollow - SetHyperlink.mdb ( intermediate )
      This sample allows the user to double-click on a control, browse to a file, and save the filename in a field in a table.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=270" rel="nofollow - SetReferenceToDAO.mdb ( intermediate )
      This sample programmatically sets a reference to DAO (Microsoft DAO 3.6 Object Library) if it does not exist.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=269" rel="nofollow - SettingLabels.mdb ( intermediate )
      This form gets the values of the labels from the Description of the Field in the table.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=268" rel="nofollow - SigFigs.mdb ( beginner )  
      This example illustrates how to round a number to a specified number of significant figures.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=267" rel="nofollow - Snapshot.mdb (beginner)
      It is usually preferable NOT to store OLE objects like snapshots in the table itself. It causes massive database bloat. The usual solution is to store the snapshots as files on the hard drive and store the file name in the table. This sample demonstrates how to to this.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=266" rel="nofollow - SQLDAOLoader.mdb ( advanced )
      This sample shows how to modify the structure of a Back-End database using SQL DDL (data definition language) statements and DAO code. This sample does much the same as "SQLLoader.mdb", but does not require text files to hold the SQL.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=265" rel="nofollow - SQLLoader.mdb ( advanced )
      This sample shows how to modify the structure of a Back-End database using SQL DDL (data definition language) statements. The actual code is found in the Back-end database (SQLLoaderBE.mdb).
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=264" rel="nofollow - StringStuff.mdb ( intermediate )
      This sample illustrates a number of useful string functions. See the individual functions for details.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=263" rel="nofollow - SubForm3Levels.mdb ( advanced )
      Access does not allow more than two levels of subforms. At times, however, your data model indicates the need for more levels. This is one way to implement a third level through the use of a list box.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=262" rel="nofollow - SubformInContinuousForm.mdb ( beginner )
      The problem is that Access doesn't allow a subform to be embedded on a Continuous Form. The following is one solution.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=261" rel="nofollow - SubformReference.mdb ( Beginner )
      This sample illustrates how to reference controls on subforms and subsubForms. It also illustrates how to set the focus to these controls.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=260" rel="nofollow - SubQuery.mdb ( beginner )
      This sample illustrates how to use a Sub Query to return the Maximum value of a group and the values of the other fields associated with it.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=259" rel="nofollow - SubQueryInFROM.mdb ( beginner )
      Demonstrates how to use a subquery in the FROM clause of a query.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=258" rel="nofollow - SynchronizedSubforms.mdb (beginner)
      This sample illustrates how to keep two subforms synchronized with each other on a main form. The code that accomplishes this is behind the two subforms.
    T
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=234" rel="nofollow - TooFewParameters.mdb ( beginner )
      This sample illustrates two ways to open a DAO recordset based on a saved query with parameter values stored in a form. Sample with Documentation.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=233" rel="nofollow - TopQuery.doc ( beginner )
      Document with sample database. Illustrates issues involving the TOP predicate
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=232" rel="nofollow - TrainingRegistration.mdb ( intermediate )
      This sample is a general purpose training registration database. It is a complete application which demonstrates many of the features of the other sample databases.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=231" rel="nofollow - TwelveBalls.mdb ( beginner )
      A fun problem in Nasty Nested IF statements
    U
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=230" rel="nofollow - UIDesign.mdb ( intermediate )
      Shows a variety of samples of good and bad User Interface design techniques.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=229" rel="nofollow - Unbound.mdb ( intermediate )
      This form illustrates how to use UNBOUND controls to add, delete, and edit records in a table using the DAO add/edit/update methods.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=228" rel="nofollow - UnboundSQL.mdb ( intermediate )
      This form illustrates how to use UNBOUND controls to add, delete, and edit records in a table using SQL statements, rather than the DAO add/edit/update methods.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=227" rel="nofollow - UpdateDirect.mdb ( intermediate )
      This sample illustrates how to programmatically update a table directly from a text file.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=226" rel="nofollow - UpdateDirectFixed.mdb ( advanced )
      This sample illustrates how to programmatically update a table directly from a FIXED WIDTH text file.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=225" rel="nofollow - UpdateImportSeekFind.mdb ( intermediate )
      This sample illustrates how to programmatically update a table from a temp table.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=224" rel="nofollow - UpdateRemote.mdb ( advanced )
      This sample illustrates how to run an update to a Back End (BE) database remotely for performance reasons.
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=223" rel="nofollow - UpdateWStatus.mdb ( intermediate )
      This database illustrates two things: 1) How to update a table programmatically with values from another table and 2) how to implement a pop-up status meter.
    • UpsizeTable2SQLServer.doc ( intermediate )
      Document with sample database. This sample reads the table definition of an Access table and makes a CREATE TABLE statement in T-SQL that will recreate the table in SQL Server.
    • http://www.rogersaccesslibrary.com/forum/topic221.html" rel="nofollow - UpsizeTable2SQLServer2.mdb ( advanced )
      Similar to UpsizeTable2SQLServer, but more robust.
    • http://www.rogersaccesslibrary.com/forum/topic220.html" rel="nofollow - UserSeesOnlyHisRecords.mdb ( beginner ) This sample shows how you can restrict data being displayed to just those records that match the user's network Login ID.
    V
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=219" rel="nofollow - VacationUsed.mdb (beginner)
      This sample illustrates one way to dynamically calculate Vacation Days Available.
    Y
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=215" rel="nofollow - YearsMonthsDays.mdb ( intermediate )
      A variety of functions created by different developer's to calculate the difference between two dates, which can also be used for Age Calculations. Some work in some situations and not in others. You'll have to decide which is best.
    Z
    • http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=214%20" rel="nofollow - Zip97.mdb ( intermediate ) This sample was created before the advent of WinZip in an attempt to automate the compression process. It uses a DOS version of PKZIP an Zip2Exe. It will also create an self-extracting zip file.


    -------------
    Consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm" rel="nofollow - find out why here .<



    Print Page | Close Window