Microsoft Access Fitness Database Part 30: Escape Double Quotes in Strings, Adding Records With VBA

In this Microsoft Access tutorial, I will show you how to deal with double quotes in string values for your fitness database combo box, explain the process of escaping characters to prevent SQL issues, and walk through building a subroutine to automatically add selected food items to your food log. You'll also see how to use recordsets to read from one table and write to another, format text fields using custom functions, and update your forms for improved usability. This is part 30.

BECOME A MEMBER:
YouTube:    / @599cd  
or My Site: https://599cd.com/THMember

LEARN MORE:
Fitness 30: https://599cd.com/Fitness30

PREREQUISITES:
Fitness, Part 29: https://599cd.com/Fitness29

LINKS:
Recordset Mouse Pad: https://tinyurl.com/28cpg9yx

UP NEXT:
Fitness, Part 31: https://599cd.com/Fitness31

RECOMMENDED COURSES:
Access Developer Courses: https://599cd.com/Developer

FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: https://599cd.com/THFree
Blank Template: https://599cd.com/Blank
Contact Management: https://599cd.com/Contacts
Order Entry & Invoicing: https://599cd.com/Invoicing
More Access Templates: https://599cd.com/AccessTemplates

DIAMOND SPONSORS:
More info on our Sponsors: https://599cd.com/DiamondSponsors

ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: https://599cd.com/Free1
How to Use Access in 30 Minutes: https://599cd.com/30Minutes
$1 Access Level 2: https://599cd.com/1Dollar
Donate to my Tip Jar: https://599cd.com/TipJar
Merch Store! Get your swag here: https://599cd.com/Merch
Get on my Mailing List: https://599cd.com/YTML
Contact Me: https://599cd.com/Contact
TechHelp: https://599cd.com/TechHelp
Consulting Help: https://599cd.com/DevNet
Twitter:   / learningaccess  
https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft...

KEYWORDS:
TechHelp, Access 2016, Access 2019, Access 2021, Access 2024, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, fitness database, combo box, double quote escaping, SQL injection, food log, OnChange event, Replace function, recordset, AddNew, Update, currentdb, AddFoodItemToLog, FormatFoodLogTime, FoodID, FoodDateTime, FoodTimeText, public subroutine, button caption, meal collection

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.