New Pages on the Site
Week ending 23 March 2003Cosmetic make-over of the site.
Creating a tabbed form to filter records alphabetically How to create a Form with a Tab Control from A-Z that when each page is selected, only records starting with that letter are displayed.
Week ending 26 January 2003
Programmatically Adding Controls to a Form Why you shouldn't try to use code to add controls to a Form, and what to do instead.
Counting the number of lines of code in a database A more accurate way than using .CountOfLines to count the number of lines of code in a database.
Why Access changes words as you type them What causes Access to automatically change words as you type them in, and how to avoid this.
Creating a Query that show unmatched records based on two or more criteria Amending the query produced by the Query Wizard to find unmatched records based on two or more criteria.
Deleting Duplicate Records from a Table How to get a unique set of records from one or more tables.
Programmatically splitting a Database Added code to show how to move tables to a back-end when they have relationships, including how to recreate these relationships.
Week ending 19 January 2003
Clearing the Clipboard using API calls How to clear any data that has been copied to the Windows Clipboard.
The Maximum Number of Rows allowed in a Combo/List Box, and how to work around this A way to get around the maximum number of rows allowed in a Combo/List Box.
Trapping Input Mask Errors How to trap errors caused by data entered incorrectly into a control with an Input Mask.
Keeping track of who is logged into a Database One way of tracking who is logged into a Database.
Using the AutoKeys Macro Group as a Developer A suggestion to make running code easier when developing an application using the AutoKeys macro group.
Generating a random Password A method of creating a random alphanumeric password.
Returning Records around a specified ranked Record How to return records ranked 5 records above and 5 records below a given record.
Programmatically splitting a Database How to create a back end database from code, and populate it with the tables from the current database.
Copyright & Disclaimer
Last modified at 06/06/2006 14:51:41