Save Notes from the Customer Form by Archiving them in the Contact History in Microsoft Access
2.8 هزار بار بازدید -
پارسال
-
In this Microsoft Access tutorial
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?
BECOME A MEMBER:
YouTube: @599cd
or My Site: https://599cd.com/THMember
LEARN MORE:
https://599cd.com/SaveNotes
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
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
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
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: Twitter: LearningAccess
https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft...
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
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
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?
BECOME A MEMBER:
YouTube: @599cd
or My Site: https://599cd.com/THMember
LEARN MORE:
https://599cd.com/SaveNotes
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
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
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
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: Twitter: LearningAccess
https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft...
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
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
پارسال
در تاریخ 1402/03/24 منتشر شده
است.
2,891
بـار بازدید شده