Login
||
Register
||
Wednesday, March 10, 2010
Home
My Free Access Tools
Free Access Tools by Others
Access Samples
Quick Tutorials
A2K7 - Change recordsource from table to query
A2K7 - How to Add a Combo Box to Find a Record
A2K7 - How to Add a Split Form
A2K7 - How to Add a Table Level Validation Rule
A2K7 - How to change from tabbed forms
A2K7 - How to Compact and Repair
A2K7 - How to convert embedded macros to VBA
A2K7 - How to Create a Grouped/Totals Query
A2K7 - How to create a multi-field index
A2K7 - How to Create a Table Using Table Templates
A2K7 - How to Create an Import Specification
A2K7 - How to Customize the Quick Access Toolbar
A2K7 - How to Disable Name AutoCorrect
A2K7 - How to enable code and macros
A2K7 - How to find your version
A2K7 - How to hide database window
A2K7 - How to Set a Startup Form
A2K7 - How to set the ANSI-92 SQL Option
A2K7 - How to Set Your Application Title and Icon
A2K7 - How to stop all controls moving together
A2K7 - Where did all of the macro actions go?
Are Data Stored in Any Particular Order in Tables?
Easy way to remember how to reference subforms
Refer to subforms in control sources
How to add custom shortcut menu (Access 2000-2003)
How to add a Group Sort on an existing report
How to add controls to the tab control
How to Add a Table Level Validation Rule
How to change a text box to a combo box
How to check for missing references
How to create a combo box to search for a record
How to create an Export Specification
How to create an Import Specification
How to have date in text but sorted by number
How to get to a form's code w/out opening the form
How to get to the code window
How to import everything into a new mdb file
How to link to your backend via UNC
How to maximize a form (or report)
How to Remove Lookups at Table Level
How to select objects quickly on a form/report
How to set a breakpoint to step through code
How to set a subform control source by code
How to tell if you have linked tables
How to use a combo box as parameter in a query
How to use a form reference in a query's criteria
How to use a function in a query
How to use the report wizard
Where to put code for events
Why is My Control Wizard Not Working?
Windows Vista
Run as Administrator
Other Microsoft Office Products
MICROSOFT EXCEL
Autofill
Full Tutorials
How to use queries to get your lookup values
Code Snippets
Check for Nulls and Empty Strings
Clear Form Controls
Compact Database
Find Next/Previous Specified Day
Find Previous/Next Sunday
Get Month Number from Month Name
Get the Date of the First Day That is Selected
How to check if a form is open (loaded)
Last Date of the Month
Lock Select Controls
Open Another Database
Send Form's Recordset to Excel
Send Table/Query to Excel
Send Table/Query to Excel - Specific Sheet
Service Pack Information
MS Office Tips and Tricks
Excel
General MS Office/Windows
MVP Sites
Books I Recommend
Contact Me
Feedback
Glossary
Search
Extra Links
Product/Program Reviews
About Me
All Samples are in Access 2000 format
Simple junction table sample
This sample shows how to use a junction table for a one-to-many or many-to-many situation.
Save and load listbox selections
This sample shows how you can save multi-select listbox selections so that when the form opens it has those selections already made.
Open Form to Record Displayed on the First Form
This sample shows how you can open a form, for example an Orders Details form, to the record number (OrderID) on the first form.
Store Multiple Data
This sample shows you how you don't need to use "spreadsheet thinking" when you have data that is different for different people, places, etc. You can store, using RECORDS, and not FIELDS, the different data. This will make queries easier to get the data you desire.
Save User Preferences
Sample where you can save things like window size, form color, etc. Then the user can have their settings back when reopening the database.
Sample Ebay Fee database
Sample Ebay Fee database where you can define the rules for the fees (up to 3 levels) and the code will calculate based on the rules you have entered in the main and subtable.
Include Extra Fields in Combo Rowsource to Fill in Other Text Boxes
You can populate other controls by using the combo, or listbox's rowsource.
Add Total Text Box on Main Form for Totals on Subform
Many times you may want to have a total shown on a main form that is from a subform. This sample will show you how to do it.
Load Subforms at Runtime (save initial loading speed of main form)
With several subforms you can find your program running very slow. So, learn how to load the subforms right when you need them.
Simple, 1 Combo Box Sample
Here is a simple combo box sample. This shows how you use a combo box to save the values into the table.
Open Generic Report with Various Criteria (simple sample)
Instead of creating multiple reports, create a generic report and use criteria to open what you want. See here for several different ways to open the same report but get different reports.
Cascading Combo Sample
Here is a cascading combo sample. When you select one value from one of the combo boxes, your other combo is limited to what fits with the selected item in the first combo.
Mileage Sample with Effective Dates
Here is a way to keep mileage reimbursement data so that you don't have to store the reimbursement rate within the main data. You can calculate it based on "effective date."
Open Report with Multiple Criteria (combo boxes, dates, or both)
Here is a sample which will show you how to open a report with multiple criteria. This one uses a combo selection and a "to" and "from" date. You can enter one, two, or all three.
Report opened by form with date parameters
This shows you how to open a report based on date selection.
Simple Login Sample
This is a very simple login sample which lets you determine if someone has logged in correctly and then base what you do on what security level your user has.
Listbox with all reports in database (if named with rpt_ as prefix)
This shows you how you can automatically list all reports in the database (without having to add them to a table) just by naming them with a prefix. The sample uses a prefix of rpt_ and then when you add a new report to the database, it automatically will show up in the list. Double clicking the list will open the report.
Listbox with all queries in database (if named with qry_ as prefix)
Same as the report one listed above, but with queries instead of reports.
Expiration Date Sample (with multiple expiration types allowed - quarterly, monthly, etc.)
Sample to show you how you can bring up a report for expirations without having to store the expiration date.
Other Sample Databases
Access World Forums - Sample Databases
Utter Access Forums - Sample Databases/Code
Copyright 2007 by BTAB Development
||
BTAB Development
||
Terms Of Use