Results 1 to 5 of 5
  1. #1
    WAVP375 is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Dayton Ohio
    Posts
    171

    Copying the path and file name of an image


    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

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    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)

  3. #3
    WAVP375 is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Dayton Ohio
    Posts
    171
    Thanks again. Where would I put that line of code?
    And could you explain the code line for my understanding..

  4. #4
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    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?

  5. #5
    WAVP375 is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Dayton Ohio
    Posts
    171
    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?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 01-13-2015, 07:16 AM
  2. Replies: 10
    Last Post: 01-09-2014, 03:00 AM
  3. Replies: 13
    Last Post: 12-12-2013, 07:22 PM
  4. Replies: 1
    Last Post: 05-14-2013, 11:49 AM
  5. Replies: 10
    Last Post: 03-04-2012, 12:17 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums