Update

[mester]

Hi everyone,
I have a problem and i need your help, imagine i have a table with a large liste of image emplacement, let's say the begining of all the records in the liste is D:\
So what i need is a vba code to update only the beginig of the emplacement, so with one click, all the emplacement in the liste start by C:\
I hope i explain clearly. Thanks

 

[theDBguy]

Hi. You can use the Replace() function. For example:

UPDATE TableName SET FieldName=Replace(FieldName,"D:\","C:\)

Hope that helps...

 

[mester]

Hi. You can use the Replace() function. For example:

UPDATE TableName SET FieldName=Replace(FieldName,"D:\","C:\)

Hope that helps...

You are a great Teacher, thanks a lot

 

[theDBguy]

You are a great Teacher, thanks a lot

Hi. You're welcome. Good luck with your project.