By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,145 Members | 1,669 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,145 IT Pros & Developers. It's quick & easy.

Replace Function

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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

Nov 13 '05 #2

P: n/a

"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
Nov 13 '05 #3

P: n/a

"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
Nov 13 '05 #4

P: n/a
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
Nov 13 '05 #5

P: n/a
Thanks, Mike! you are great!!!

Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.