Custom Software

The Access Wizard


Contact Jim
Access Wizard
About Jim

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.


Join The Access Wizard mailing list
If you find the Access Wizard helpful, donations are welcome  Click here to donate  


To see Past issues click on the link(s) below
January What to Do When Things Slow Down: Turn Off Sub Data Sheets:
December What to Do When Things Slow Down
November Making One Report Act Like Two - Part 2
October Making One Report Act Like Two - Part 1
September Versions - 102
July Versions - 101
June Flashcards 105 - The Menu
May Sorting - Converting Dates to Strings with All on Top
April Calculating Ages
March Flashcards 104
February Flashcards 103
January Flashcards 102
December Building an Application from the Ground  Up - Flashcards 101
October Option Groups 103 - Reacting to User Input
September The Select Case Method
August 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
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
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
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

Normalization 103 The Importance of Eliminating Redundancy or the Case of the Clever Camper

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:
Last modified: July 09, 2009