Find/Replace Update Query

[benkingery]

I am collecting data on image URLs. My entry folks find the specified URL link, copy it and paste it into the field I've indicated. I need to perform a STANDARDIZED update to EACH record that gets a URL.

Currently as they paste them into the field they begin with "ftp://" and I need to run an update query that will replace any records containing the above text with "http://".

The easy answer would probably be to open the table and run a quick Find/Replace on the columns containing the data, but I don't want them to get into the tables, not to mention I'm asking them to enter this on multiple tables through forms.

Does anyone know of a way that I can do this? I will ALWAYS be finding and replacing the exact same values.

Thanks for the help.

 

[Kiwiman]

Howzit


You can try the Replace function in the after update event

Private Sub yourcontrol_AfterUpdate()

Me.yourcontrol= Replace(Me.yourcontrol, "ftp://", "http://")

end sub

 

[benkingery]

PERFECT!!! This is exactly what I needed. Thank you for your help! I knew there was an easy way to do this.