Access TechHelp

This is a listing of all available Microsoft Access TechHelp videos. Looking for something specific? Search for it. If you've got a question, post it below, or visit the Ask a Question page. Also, don't forget to check out my special Quick Queries videos. Enjoy!

New: Enhanced Directory showing all regular or Extended Cut videos

Date		Title	Summary
2020-08-10		Subform in a Continuous Form	How To Display a Subform Inside a Continuous Form and Sync Record Lists in Microsoft Access
2020-08-09		Odd or Even	How To Determine If a Number Is Odd or Even Using the Mod Operator and IIF Function in Microsoft Access
2020-08-09		AutoNumbers Good or Bad?	How To Choose Between AutoNumbers and Natural Keys for Primary Keys in Microsoft Access Tables
2020-08-06		Sync Remote Database	How To Sync Two Separate Databases Without Internet Access and Avoid Key Collisions in Microsoft Access
2020-08-06		Customer Codes	Create Customer Codes that Don't Reveal Your Microsoft Access Database Size
2020-08-05		Sequential Numbers	How To Create Custom Sequential Order Numbers Without Gaps for Reporting Purposes in Microsoft Access
2020-08-04		Restore Deleted AutoNumber	How To Restore Deleted AutoNumber IDs and Recover Lost Records Safely in Microsoft Access Databases
2020-08-01		Custom Sort Order	How To Use a Custom Sort Order for Forms and Reports to Display Records in Microsoft Access
2020-07-28		Disallow Editing Data	How To Allow Adding But Prevent Editing Or Deleting Existing Records In Microsoft Access Forms
2020-07-24		Select Primary Customer	How To Indicate the Primary Person for Accounts or Families Using a Yes No Field in Microsoft Access
2020-07-23		On Current	On Current Event in Microsoft Access
2020-07-19		Input Masks Varying Length	How To Create Input Masks for Variable Length Phone Numbers and Fields in Microsoft Access
2020-07-14		Move THE To End of Title	How To Move The To The End Of Book Titles With Update Queries And VBA After Update Events In Microsoft Access
2020-06-29		Create a Duplicate Record	How To Duplicate an Existing Record With a Single Click Using Command Button Wizard in Microsoft Access
2020-06-28		Time as a Duration	How To Store and Calculate Flight Hours and Duration Over 24 Hours in Microsoft Access Databases
2020-06-17		12 Hour Time with NO am/pm	How To Display Time in 12-Hour Format Without AM or PM for Reports in Microsoft Access
2020-05-18		Record Source	Learn About the Record Source Property in Forms
2020-05-03		Replace Function	How To Use the Replace Function to Clean and Standardize Phone Numbers in Microsoft Access Update Queries
2020-04-20		Backup Record Before Edited	How To Automatically Backup a Record Before Editing With History and Timestamps in Microsoft Access
2020-04-17		ZIP Code Lookup	ZIP Code Lookup

More...