Results 1 to 4 of 4
  1. #1
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    2,095

    Persistent error executing a Name function

    Below is a screenshot of a persistent error raised when I attempt to rename a file. The error handler messaging includes an exact copy of what amounts to the program statement that raised the error.
    Click image for larger version. 

Name:	002.jpg 
Views:	22 
Size:	249.7 KB 
ID:	52539

    I cannot see anything wrong. I cannot even guess what might cause the input file to be open, even if it was, I would expect an error indicating as such. The 3rd-party ffmpeg app just concluded converting a wav file to the mp3 file seen here as the input to the rename.



    Thoughts?

    WOW, now with a close-up view seen in the screenshot, I see the play duration includes NO NO colons in the expression.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,652
    Glad you sorted it Bill! I was going to suggest debug printing the path and seeing if it was valid. Bad eyesight, I couldn't tell those were colons rather than semi-colons.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    2,095
    Well, to give a better idea of how bad my eyesight has become, I started with a few Debug.Print approaches but still didn't see the colons. It was only with the enlarged screenshot. There is a reason for the "Old Geezer" avatar.

  4. #4
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,552
    Perhaps increase the font size on your computer, if that is the case.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

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

Similar Threads

  1. Replies: 7
    Last Post: 11-27-2023, 02:27 PM
  2. Persistent .ldb
    By knarfreppep in forum Programming
    Replies: 1
    Last Post: 02-11-2015, 03:32 AM
  3. How to make a persistent ODBC connection MySQL to Access
    By Yann63 in forum Import/Export Data
    Replies: 4
    Last Post: 01-24-2014, 09:44 AM
  4. Replies: 0
    Last Post: 11-08-2012, 09:34 AM
  5. Non-persistent Font
    By mystifier in forum Access
    Replies: 0
    Last Post: 11-22-2010, 01:38 PM

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