Рет қаралды 9,726
In this Microsoft Access tutorial, I will teach you how to use a FOR NEXT statement in Microsoft Access VBA to count the number of time a specific character occurs in a string. We can use this to also count how many lines are in a long text field (textbox).
Paul from Houston TX (Silver Member) asks, "I get emailed a (text) list of products every day. Next to each product is a + if that product is new. I need to know both of these counts to put in my daily report. Is there a way I can just copy and paste this text into Access and have it count the number of lines and the number of + it finds?"
LEARN MORE:
599cd.com/ForNext
LINKS:
Concatenation: 599cd.com/conc...
Enter Key Behavior: 599cd.com/ente...
New Line in Field: 599cd.com/new+...
For Loops: 599cd.com/acd3
Intro to VBA: 599cd.com/acd1
LEN Function: 599cd.com/acd8
MID Function: 599cd.com/acx25
While Loops: 599cd.com/acd12
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 how create your own function. We will make CountChar into a function that returns a value. We will learn about Rich Text Fields and how to add color and HTML codes to your long text fields. We will learn how to count the number of open ( and close ) in a box and change the colors accordingly to allow you to see where they may not match up.
MEMBERS ONLY VIDEO:
• For Next Loops in Micr...
BECOME A MEMBER:
/ @599cd
MEMBERS TOPICS:
Make a CountChar Function
Create Functions: 599cd.com/acd2
Create Public Module: 599cd.com/acd11
Exit Function: 599cd.com/exit...
DoEvents: 599cd.com/acd12
Rich Text Boxes: 599cd.com/acx5
Arrays: 599cd.com/arrays
Combo Box .Column: 599cd.com/acd15
RESOURCES:
FREE Customer Template Database: 599cd.com/XCDT
FREE Access Level 1: 599cd.com/Free101
$1 Access Level 2: 599cd.com/1Dollar
Your Questions Answered: 599cd.com/Tech...
Learning Connection 50% OFF: 599cd.com/Conn...
Survey: 599cd.com/survey
Richard's Blog: 599cd.com/blog
Access Forum: 599cd.com/Acce...
Twitter: / learningaccess
Email Me: amicron@gmail.com
en.wikipedia.o...
products.offic...
microsoft.com/...
KEYWORDS:
For Next Statement
For Next Loops in Microsoft Access VBA
Count Occurrences of a Character in a String
Count specific character in a string
count the occurrences of a character
Match Parentheses
Match Brackets
Rich Text in Long Text Fields
Add HTML Codes and Color to Text Boxes
Change Font Color in Text Box