When copying the path and file name of an image that string has quotes round it. Is there a way to copy it without the quotes?
If not is there a way to delete the quotes after pasting it?
Thanks
When copying the path and file name of an image that string has quotes round it. Is there a way to copy it without the quotes?
If not is there a way to delete the quotes after pasting it?
Thanks
Paths must have quotes around it to identify it as a string.
then get the path w/o quotes:
Mid(sPath,2,len(sPath)-1)
Thanks again. Where would I put that line of code?
And could you explain the code line for my understanding..
Well Im not sure WHERE you want to use it.
In vb code there's no need for it. What do you want to do?
sPath = txtBox
sPathWithoutQuotes = Mid(sPath,2,len(sPath)-1)
(the code removes the end quotes) but why?
I am pasting the path into a data entry form which will be saved to the table with a field labeled 'ImagePath' and I'm looking for way to not remove them manually.
As you pointed out in the previous thread it can't contain the quotes.
As second question. What happens to the linkage if either the DB or the image folder is moved? Or what happens when the OS is updated or changed?