Avoid Lookup Fields, Dlookup & DB Maintenance

Quick Queries videos are for me to answer your questions that may not need a whole video themselves. In today's video...

Topics

• Lookup Wizard Issues
• Avoiding Lookup Fields in Tables
• Problems with Dlookup in Queries
• Using Joins Instead of Dlookup
• Database Corruption Causes
• Access Database Backup Practices
• Releasing Temp Vars
• Changing Access Theme to Office 2013-2022
• Importing Multiple CSV/Text Files
• Moving Controls with Keyboard Shortcuts
• Fixing Date Field Format Issues
• Explanation of Command Button Naming
• Restoring Form Property Box and Rulers
• Converting Forms to Reports with Code
• Verifying Required Fields in Forms
• Table Level Validation for Multiple Fields
• Setting Rich Text for Long Text Fields
• A-Z Jump Buttons Functionality
• Using Filter Property for Jump Buttons

Prerequisites

• Quick Queries Listing

Links

• TempVars
• Default Theme
• Load Multiple Images
• ISO Date Format
• Grid Lines v Dots
• Required
• Table-Level Validation
• A-Z Jump Buttons
• Adam's Copy Form to Report Code

Recommended Courses

• Access Developer Courses

Up Next

• Quick Queries #21

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, lookup wizard, lookup fields tables, Access normalization, database development lookup, dlookup query slowdown, join tables Access, tempvars Access usage, tempvars.remove syntax, Access themes 2013-2022, reverting Access theme, Access importing CSV files, Access importing multiple files, form design view tips