Custom Software

The Access Wizard

 

Home
Contact Jim
Access Wizard
About Jim
Clients
Presentations

Welcome to the Access Wizard Newsletter Page. The  Access Wizard is a monthly newsletter that contains tips, tricks and traps for Access users, from beginners to developers.

Sign up below to join the mailing list   

Join The Access Wizard mailing list
Email:
To see Past issues click on the link(s) below
2008  
Aug Option Groups 102 - Binding to a Field
July Option Groups 101 - The Basics
June Recovering From Corruption - JetComp
May Re-linking Tables in a Split Database
March Split a Database into Front and Back Ends
February Recovering From Corruption - Rebuild From New File
January Recovering From Corruption - Repair and Compact & Decompile
2007  
December Sorting with the Switch Function
October The Switch Function
September How Many Working Days Between Two Dates - Part 5 - Putting it all Together
August How Many Working Days Between Two Dates - Part 4 - Generating a SQL Statement
July How Many Working Days Between Two Dates - Part 3 - Counting Weekdays
June How Many Working Days Between Two Dates - Part 2 - Eliminating Weekends
May How Many Working Days Between Two Dates - Part 1 - Holidays
April Date Math 104 - DateSerial
March Date Math 103 - DateAdd on Steroids
February Date Math 102 - The DateAdd Function
January Date Math 101 - Storage & Retrieval
2006  
December Macros -- Training Wheels for VBA coding
November Error Handling 102  -- Murphy was an Optimist
October Error Handling 101  -- Murphy's Law
September Conversion Functions 102  -- More Flexibility
August Conversion Functions 101  -- How Long is a Cubit
July Combo Boxes  -- How to Process an "Add New" Selection
June Sorting 103 -- Sorting on Steroids 
May Sorting 102 -- Intermediate Sorting
April Sorting 101 -- The Basics
March Combo Boxes 105 -- Adding New as a Choice
February Queries – How to Transform a Non-Updating Query to an Updating Query
January Queries – Sometimes you Can Update and Sometimes you Can't
2005  
December Combo Boxes 104 -- The Code Behind the Magic
November Combo Boxes 103 -- Finding Records the Easy Way
October Combo Boxes 102 -- Building From Scratch
September Combo Boxes 101 -- A Powerful Tool in a Small Package
August Parameter Queries -- Why Make One Cookie When You Can Make a Batch
July Union Queries -- The Urge to Merge
June What's Really Happening with Queries -- Pay No Attention to the Man Behind the Curtain
May Shortcuts – How to get from Point A to Point B with the Least Amount of Effort
April Normalization 104 – Dependency: Calculate When Possible
March Switchboards – Make Life Easier by Choosing rather than Searching
February

Normalization 103 – The Importance of Eliminating Redundancy or the Case of the Clever Camper
January
2004  
December Parsing, or the Art of Pulling Things Apart
November Normalization 102 - Atomicity
October What is a Relation Anyway?
September Normalization 101
August Self Updating Combo Boxes
July Naming Conventions
June Keys Are Critical
May Begin at the Beginning



Let's talk: 978-392-3462 email: jim@custom-software.biz
Last modified: August 26, 2004