[AccessD] A2003:Replacing 'tokens' in a string

You just never posted back then, or at least I don't remember any posts
from you on the subject.

As for importing classes, that had to be Access 2, cause you've been
able to do it since 97 on.

As for not being able to do something you can do in 'regular code', LOL,
should I start listing the things you can do?  You can't raise an event
in a standard module.  There's one.  You know, I use macros for AutoExec
and AutoKeys.  I use modules for callback functions, global variables
(and functions) and any straightforward single function.  I use classes
for everything else.  I do this (and I would assume JC does this too)
because it is the most efficient and effective method of coding in VBA.
You can replicate a lot of class functionality in VERY round about and
less effective ways in a regular module, and before you effectively use
classes and collections, you are forced to do that.

As for all that the thread was about, again, it was more then just
parsing a string once.  It was simple enough to handle with a single
function, but also presented future needs that might require the
flexibility of a class....

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
Sent: Thursday, January 28, 2010 12:01 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] A2003:Replacing 'tokens' in a string

1. Actually I was.  I have been here for circa 10 years or so maybe
longer,
and can remember them well.
2. I actually use Classes.  Yes, ones I have written myself and they
work
fine.  The problem I have with them is that, FOR ME, do nothing that I
cannot do with normal everyday code  in a module BUT they do require a
lot
of overheads.
3. AND, if you recall, many years ago you could not copy classes between
mdbs. From memory, you had to go through a convoluted series  of steps
to
get  it into a new module (not nowadays, but back then).
4. I like classes when  I am leveraging methods and properties from, say
Outlook. But the aruguments  about Business Rules in one place just
sucks.
4. And besides all that, all they guy wanted  to do was  parse a
string..

Max


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka
Sent: 28 January 2010 17:38
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] A2003:Replacing 'tokens' in a string

Sigh, Max, you weren't on here during the bound/unbound debates.  Those
debates were monumental, and most of it was experience vs. experience.

The information contained in this transmission is intended only for the person or entity 
to which it is addressed and may contain II-VI Proprietary and/or II-VI Business 
Sensitive material. If you are not the intended recipient, please contact the sender 
immediately and destroy the material in its entirety, whether electronic or hard copy. 
You are notified that any review, retransmission, copying, disclosure, dissemination, 
or other use of, or taking of any action in reliance upon this information by persons 
or entities other than the intended recipient is prohibited.