Replace Function

[galsaba]

I just found out that Replace Function exists in Access XP (as part of
MS Office), but does not exist in Access 2000 (as part of access 2000).
Any idea how I can resolve it? Does access 2000 has an alternative
soulution, is there an add on tool for Replace Function?

galsaba

[Rick Brandt]

galsaba wrote:

I just found out that Replace Function exists in Access XP (as part of
MS Office), but does not exist in Access 2000 (as part of access
2000). Any idea how I can resolve it? Does access 2000 has an
alternative soulution, is there an add on tool for Replace Function?

galsaba

Access 2000 does have Replace(), but for some reason the expression service
doesn't pick it up so you cannot use it in queries unless you create a
user-defined wrapper function. In ControlSources and in VBA code though it
should be there and work fine.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Gaspare]

"galsaba" <ga*****@aol.com> ha scritto nel messaggio
news:11*********************@l41g2000cwc.googlegro ups.com...

I just found out that Replace Function exists in Access XP (as part of
MS Office), but does not exist in Access 2000 (as part of access 2000).
Any idea how I can resolve it? Does access 2000 has an alternative
soulution, is there an add on tool for Replace Function?

galsaba

Hi,
create and use a function how Replace...use vba modules..

help you?

Gaspare

[Gaspare]

"galsaba" <ga*****@aol.com> ha scritto nel messaggio
news:11*********************@l41g2000cwc.googlegro ups.com...

I just found out that Replace Function exists in Access XP (as part of
MS Office), but does not exist in Access 2000 (as part of access 2000).
Any idea how I can resolve it? Does access 2000 has an alternative
soulution, is there an add on tool for Replace Function?

galsaba

Use the function for string manipulation...Instr(), Mid() etc...for create
your function

if you want it help you..."gratis" :-)

Gaspare

[Mike Preston]

On 20 Apr 2005 06:08:29 -0700, "galsaba" <ga*****@aol.com> wrote:

I just found out that Replace Function exists in Access XP (as part of
MS Office), but does not exist in Access 2000 (as part of access 2000).
Any idea how I can resolve it? Does access 2000 has an alternative
soulution, is there an add on tool for Replace Function?

http://www.mvps.org/access/strings/str0004.htm might do it for you.

mike

[galsaba]

Thanks, Mike! you are great!!!