The Access Wizard

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

This newsletter has been in publication since 2004. Our philosophy is that knowledge should be distributed as widely as possible. Although subscriptions are not required to receive the Access Wizard donations help to keep the Access Wizard alive.

Year Month Title
2010 June Controlling the Start Up Process
  May Decisions on the Fly - The Immediate If
  April Backing Up a Database: The Good, The Bad, and The Ugly
  March Hidden Info - The Easy Way to the Access Path: SYSCMD
  February What to Do When Things Really Go Wrong: Decompile
  January What to Do When Things Slow Down: Turn Off Sub Data Sheets
2009 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
2008 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
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 Error Handling 102 -- Murphy was an Optimist
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 The Plague of Redundant Mail or How to Avoid Killing Trees and Wasting Money by Eliminating Near Duplicates
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