View Full Version : Modifying stored path


dynamictiger
02-22-2002, 12:15 PM
I had set up a simple picture database, to capture some images of documents used at work. It was kinda how you goin, but worked.

Trouble is my staff not paying attention have typed the word Outdoor as Ourtdoor on several records.

This is the format of the path as it currently is set up

C:/BamBam/12122001-OurtdoorPool

I have never had to correct anything like this before, however, I can see it can be done, can someone explain it for me.

Thanking you in advance

Alexandre
02-22-2002, 01:13 PM
One observation first. You can avoid typo errors in files paths by having the path recorded through the use of the common dialog control. Make the related textbox not editable so that users can t modify the captured path and that s it.
If you are interested, I can set up a sample DB for you.

Now, if I understand well, you want to replace a string (Ourtdoor )with another (Outdoor ), in various records.
There certainly are various ways to do it.
Here is one:

1. Make a backup of your DB before anything else.

2. Use a query to select your records:
SELECT TableName.PathFieldName
FROM TableName
WHERE (((TableName.PathFieldName) Like "*Ourtdoor*"));

3. Use the replace menu item to replace all "Ourtdoor" occurences with "Outdoor" in your query.

Hope this helps.

Alex

[This message has been edited by Alexandre (edited 02-22-2002).]

[This message has been edited by Alexandre (edited 02-22-2002).]

dynamictiger
02-22-2002, 05:57 PM
Thanks I can see how this works now, I just wasn't sure where to start