Save Notes from Customer Form to Contact History

In this Microsoft Access tutorial I'm going to show you how to take notes from your customer form and archive them by saving them in your contact history which you can view in the contact history form and we'll do this with one click and a little tiny bit of VBA.

Grace from Albany, New York (a Platinum Member) asks: I like to keep notes visible on the customer form for the latest info on a client. However, when that's no longer valid, and I need to change it with something else, I don't want to lose what was there. Is there any way to archive that information when something new is typed in?

Prerequisites

• Contacts: https://599cd.com/Contacts
• Intro to VBA: https://599cd.com/IntroVBA
• SQL with Access: https://599cd.com/SQLwithAccess

Links

• Double Double Quotes: https://599cd.com/DoubleDouble
• DDQ Not SQ: https://599cd.com/DDQnotSQ
• Append Only: https://599cd.com/AppendOnly

Recommended Courses

• Access Developer Courses: https://599cd.com/Developer
• Access SQL Seminars: https://599cd.com/SQL

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

access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Archive notes, move notes to contacts, archive data, save old info, docmd.runsql, currentdb.execute, insert into, append query