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

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> How to find/replace * (an asterisk)    
 
   
Nash
post Jul 19 2006, 03:45 PM
Post #1

UtterAccess Addict
Posts: 202
From: A Rock In Space
I have a table with a field that has data separated by an *. I can't do an find/replace because when I look search for * it highlights and replaces the entire field. How can I solve this quirk.

Thanks
Go to the top of the page
 
+
freakazeud
post Jul 19 2006, 03:47 PM
Post #2

UtterAccess VIP
Posts: 31,413
From: NC, USA
Hi,
what are you trying to do? Remove the "*", or just find the values which have one in it, or...?
To replace you can try this in an update query:

Replace([YourField],"*","")

To find it use the Instr() Function.
HTH
Good luck
Go to the top of the page
 
+
R. Hicks
post Jul 19 2006, 03:50 PM
Post #3

UA Forum Administrator
Posts: 38,073
From: Birmingham, Alabama USA
What as you using ???

Replace([FieldName],"*", "")

The above should remove the asterisk ...

RDH
Go to the top of the page
 
+
Nash
post Jul 19 2006, 03:51 PM
Post #4

UtterAccess Addict
Posts: 202
From: A Rock In Space
It didn't recognize Replace as a function.
Go to the top of the page
 
+
R. Hicks
post Jul 19 2006, 03:54 PM
Post #5

UA Forum Administrator
Posts: 38,073
From: Birmingham, Alabama USA
You must not be using it correctly ....

Post "exactly" what you say it does not recognize .. and where you are using it.

RDH
Go to the top of the page
 
+
freakazeud
post Jul 19 2006, 03:55 PM
Post #6

UtterAccess VIP
Posts: 31,413
From: NC, USA
Are you using Acc03 as specified in your version? If yes then replace should work...if it doesn't then maybe you have a reference issue. Open the vba editor (ctrl+g), tools--references...and check if any are marked missing. If yes then correct that. Where did you put the command?
HTH
Good luck
Go to the top of the page
 
+
Nash
post Jul 19 2006, 03:58 PM
Post #7

UtterAccess Addict
Posts: 202
From: A Rock In Space
I created an update query, brought the table in, dropped in the field, and put Replace([FieldName],"*", "") in the Update To line.
Go to the top of the page
 
+
R. Hicks
post Jul 19 2006, 04:07 PM
Post #8

UA Forum Administrator
Posts: 38,073
From: Birmingham, Alabama USA
You need to substitute "FieldName" with the actual name of the field that contains the data to alter ...

RDH
Go to the top of the page
 
+
Nash
post Jul 19 2006, 04:09 PM
Post #9

UtterAccess Addict
Posts: 202
From: A Rock In Space
I know, I did that.
Go to the top of the page
 
+
R. Hicks
post Jul 19 2006, 04:14 PM
Post #10

UA Forum Administrator
Posts: 38,073
From: Birmingham, Alabama USA
Make sure you have installed all updates for the version of Office/Access you are using.

RDH
Go to the top of the page
 
+
Nash
post Jul 19 2006, 04:16 PM
Post #11

UtterAccess Addict
Posts: 202
From: A Rock In Space
That's strange. I was attempting to do the update query on our server version of Access and it didn't run, but then I exported the table to my hard drive and used the version of Access there - it worked fine. Hmm.

Thanks
Go to the top of the page
 
+
R. Hicks
post Jul 19 2006, 04:18 PM
Post #12

UA Forum Administrator
Posts: 38,073
From: Birmingham, Alabama USA
Update Office and Access of the server with all updates and service packs .. and make sure that the latest Jet 4 update has also been installed ...

RDH
Go to the top of the page
 
+
Nash
post Jul 19 2006, 04:19 PM
Post #13

UtterAccess Addict
Posts: 202
From: A Rock In Space
Thanks
Go to the top of the page
 
+
R. Hicks
post Jul 19 2006, 04:23 PM
Post #14

UA Forum Administrator
Posts: 38,073
From: Birmingham, Alabama USA
No problem .. (IMG:http://www.utteraccess.com/forum/style_emoticons/default/wink.gif)

RDH
Go to the top of the page
 
+
« Next Oldest · Access Queries · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 23rd May 2013 - 06:21 AM