This
page contains demonstrations and techniques that I have gleaned over the
time that I have been developing in MS Access. I plan on adding
at least 1 or 2 demos each week, so keep this page in your favourites.
I am particularly grateful to the community of developers out there who
have freely shared their expertise through the various newsgroups and
developer forums. I dedicate this page to them and trust that it repays
a little of the debt I owe.
|
# |
Description |
Download File |
|
1 |
Using the instr() function to switch 2 words around such as a first name and last name that are in the same field. (A97) | Switch.zip |
|
2 |
How to populate a combo box with filenames from a selected folder and selected extension and then open the selected file with its associated EXE (A97) | Populate box.zip |
|
3 |
A method for activating and deactivating the ByPassKeys which allows the developer to lock out other users from the design view of a database.(A97) | Bypass keys.zip |
|
4 |
A simple yet effective method for monitoring the firing order of events on a form or report (A97) | Firing order.zip |
|
5 |
How to create an sql statement on the fly and use it to query the recordsource of an open form (A97) | SQL on The Fly.zip |
|
6 |
Documentation on known installation problems using ODE Access runtime version (A97) | Installation Problems.zip |
|
7 |
How to pick records randomnly from a table. (A97) | Random Picker.zip |
|
8 |
How to hide and unhide the detail of a report. (A97) | Hide Unhide Detail.zip |
|
9 |
How to filter a report by using multi-selections from a list box (A97) | Filter By List.zip |
|
10 |
How to display a random picture each time a form or report is opened. (A97) | Random Pics.zip |
|
11 |
How to maintain an audit trail of changes on a form (A97) | Audit.zip |
|
12 |
An alternative progress meter (A97) | Progress Meter.zip |
|
13 |
2 simple demonstrations on how to create animation in Access. (A97) | |
|
14 |
An example of how to make a 'Splitter Control' to resize width of two controls. (A97) Contributed by Alex Dybenko | Splitter.zip |
|
15 |
Enable and disable buttons on a form according to a simple logon. (A97) Contributed by Saicom Systems | Reuse form.zip |
|
16 |
How to use the special autokeys macro. (A97) Contributed by Saicom Systems | Autokeys.zip |
| 17 | A database demonstrating how to interact with MS Outlook from MS Access. Lots of useful code and ideas. | Accoutdb.exe |
| 18 | A simple demonstration using the openargs argument to populate a list box | Openargs.zip |
| 19 | How to populate a combo box with a listing of tables, queries, forms, reports, macros and modules. Active code taken from Access Developers Handbook ISBN:9-780782-119411 | GetDatabaseObj.zip |
| 20 | A simple method for calculating the values on a report into a different currency. This example exchanges pounds to dollars. | PoundsToDollars.zip |
| 21 | How to generically set date boxes using the MS Calendar control. (A97) | MS Calendar .zip |
| 22 | How to filter fields generically on any form within an Access database (A97) | Filtering Fields .zip |
| 23 | How to generate a stored running total on a bound form. (A97) | Running Totals.zip |
| 24 | How to generate an unstored running total using a query bound to a form. (A97) | Running Totals 2.zip |
| 25 | How to requery a combo box based on a selection from another combo box. (A97) | Combo Filter.zip |
| 26 | How to run an update query from within a form. This example uses the orders form to update a unit price in the products table from Northwind.mdb. (A97) | Update Query.zip |
| 27 | How to use the input box function to prompt the user for filter criteria before running a report. This example asks for 2 dates and checks to see that they fall in the same quarter. (A97) | Inputbox Criteria .zip |
| 28 | How to map an image control with user defined coordinates. (A97) | Image Mapper .zip |