UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> How To Count Occurences Of A String Within VBA Modules, Any Version    
 
   
Jaiket
post Feb 23 2019, 11:28 AM
Post#1



Posts: 385
Joined: 3-May 17
From: France


Hi,
I just stumbled upon a hack to do this, albeit a somewhat risky one, which should only be done on a copy of the database.

Search for the string, and replace it with the same string. The number of replacements is your count.

I guess it would work with any version of Access that has search and replace.

--------------------
Life is too short to drink bad wine.
Go to the top of the page
 

Posts in this topic



Custom Search


RSSSearch   Top   Lo-Fi    15th November 2019 - 05:38 AM