Progress Bar 2: Show Completion Progress of a Form with a Large Number of Fields, Percent Completed

Learn how to use a Progress Bar to show the completion progress of a form with a large number of fields on it.
LEVEL: Developer (Some VBA Programming)
David from Virginia Beach, VA (a Gold Member) asks: I really enjoyed your video on progress bars. I have a form with about 70 text boxes that require information to be entered over several weeks time, not all at once. Is there any way to create a progress meter indicating how much of the form has been completed to date? I would like it to appear at the top of the form and show how each record's profess stands as it is changed. Thanks, and live long and prosper!
BONUS FOR CHANNEL MEMBERS:
Silver Members and up get access to an EXTENDED CUT of this video which covers additional examples. That video will show you how to use a For Each command to loop through the controls on the form and count them automatically using the Tag property. We will also display the percent complete for each of the records in a continuous form and make them look pretty with some conditional formatting.
MEMBERS ONLY VIDEO:
• Progress Bar 2: Show C...
BECOME A MEMBER:
/ @599cd
LINKS:
Original Progress Bar Video: 599cd.com/ProgressBar
Intro to VBA Programming: 599cd.com/IntroVBA
AfterUpdate Event: 599cd.com/AfterUpdate
Code Builder: 599cd.com/CodeBuilder
OnCurrent Event: 599cd.com/oncurrent
ADDITIONAL RESOURCES:
Get on my Mailing List: 599cd.com/YTML
FREE Access Beginner Level 1: 599cd.com/Free1
FREE Blank Customer Template: 599cd.com/FRL2
$1 Access Level 2: 599cd.com/1Dollar
TechHelp: 599cd.com/TechHelp
Twitter: / learningaccess
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...
Email Me: [e-mail]
KEYWORDS:
microsoft access, ms access, #msaccess, #microsoftaccess, progress bar, large form, percent complete, progress meter, tag property, for each, loop through controls
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[@mehrasayat1643]

آموزش کاربردی بود خیلی استفاده کردم. سپاس از شما

[@599CD]

خواهش میکنم

[@all-starplastics4268]

Primary key is alpha numberic (customized ) auto number. How to use this field as a foreign key. Problem is data type conflict

[@599CD]

To join two fields, the data types must match. Text to text. Long to long. I would suggest adding Autonumbers to your main table in addition to your other PK. Use those for relationships. Otherwise, you could still use the current alphanumeric field as a FK, but you have to have the same field type in the other table.