473,327 Members | 2,094 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Replace Function

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
5 9222
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

"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

"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
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
Thanks, Mike! you are great!!!

Nov 13 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

10
by: pembed2003 | last post by:
Hi all, I asked this question in the C group but no one seems to be interested in answering it. :-( Basically, I wrote a search and replace function so I can do: char source = "abcd?1234?x";...
2
by: Sharon | last post by:
I've had an Access 2000 app running successfully for many months on both Windows XP and Windows 2000. Recently when my Windows 2000 users call a particular report, they get first a dialog...
3
by: Dave | last post by:
I have an Access 2K application that is distributed to about a dozen users (all with identical NT environments and identical Access versions, object libraries and service packs). I am using the VBA...
3
by: Andy Sutorius | last post by:
Hi, I read the thread (2/16/05) regarding a replace function in C# however it didn't answer my question. I have a string which is building an insert sql statement and I would like to replace...
4
by: Cor | last post by:
Hi Newsgroup, I have given an answer in this newsgroup about a "Replace". There came an answer on that I did not understand, so I have done some tests. I got the idea that someone said,...
4
by: Lauren Wilson | last post by:
Hi folks, We have a need to replace sub strings in certain message text. We use the Office Assistant to display help and often use the imbedded formatting commands. Those of you who have used...
5
by: enno | last post by:
Dear Community, We have a problem with null-Bytes in varchar-Columns, which are not handled correctly in our application. Therefor we try to filter them out using the Transact-SQL REPLACE...
8
by: Warren Moxley | last post by:
Hi there, i've been searching for a C String search and replace function. I need to find all occurrences of " " in a char* array, and replace them with another char, I know how to do this in...
1
by: seanmatthewwalsh | last post by:
Hi I have a website that uses an Access 2003 database. I have controls on my pages that are bound to SqlDataSources that pull data from this database. In a couple of them, I need to use the...
2
by: ArunDhaJ | last post by:
Hi, I'm having a DataTable with a column named "Phones" having value like (901) 789 1234<BR>(901) 789 1235<BR>(901) 789 1221 I need to perform filtering based on the phone number of the form...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.