Page 2 of 2 FirstFirst 12
Results 16 to 19 of 19
  1. #16
    Sephaerius is offline Advanced Beginner
    Windows 7 64bit Access 2013 64bit
    Join Date
    Aug 2013
    Posts
    62
    Quote Originally Posted by ridders52 View Post
    Thanks for doing all the tests.
    Next possibly stupid question.
    Are you absolutely sure the file exists on the user's computer and is in the specified folder
    I ask because some files have different locations in 32-bit /64-bit



    Have you tried defining x, Ext explicitly? As linq spotted earlier, at the moment they are defaulting as variant
    Which file are you referencing specifically, as existing on the users computer?

    I could try, but that wouldn't do me any good. The targeted files are daily reports that are named NAMEyyyymmdd.txt. Besides, once again, the function aside from the Kill statement, executes as it should. If there were an issue with the variant, wouldn't the function also fail to perform the copy/paste? And why does this work just fine on Access 2010 x32 and Access 2013 x64, but not on Access 2016 x32?

  2. #17
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    You do know why I said that, right? Because I'm not linq??
    Your attempts are always appreciated by all, I'm sure. Keep on keepin' on. Your answers in this one were well thought out and worthy of the effort and their consideration. In the meantime, I will park this one while I wait for the OP to clarify the declaration is an issue or not, and what the debug results are. It may not be an issue with the declarations at all, but if I was a betting man...

    This
    I have tried creating a completely separate function which does nothing other than execute Kill, with the same error 13 result
    really tells us nothing when the example wasn't presented. The new function could be as faulty as the last one, even if it's not for the same reason.
    Last edited by Micron; 05-03-2018 at 01:11 PM. Reason: added info

  3. #18
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    I tried debug.Print srcFile, and it returned the correct path/string that it should have.
    Sorry, I missed that because the whole acknowledging paragraph was headed with "Minty". Perhaps I could test in Access 2016 32 bit if I knew what the array was about.
    EDIT: I believe I said all the variables. In playing around, d is "" for me, but then again, I don't get how the array assignment is expected to work. Plus you've said this seems to be a user specific issue that (I think) was working before for said user, so it's puzzling. I don't recall the trusted issue being addressed either. Perhaps I'm forgetting that you did. Methinks that when an established user gets a new version, the trusted locations can get lost for them.

  4. #19
    Minty is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    I wonder if that's why I added the on error resume next - I have routines that clear out old log files from a central location, and sometimes the files are "locked" even though no body has had them open for months.

    I then list the "undeleteable" ones in a list box and send the list to our IT Admins to execute them at a server level, if I can't manually remove them.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 0
    Last Post: 03-02-2018, 11:08 AM
  2. Automating Outlook 2016 from Access 2016
    By jcc285 in forum Programming
    Replies: 10
    Last Post: 09-30-2017, 01:53 PM
  3. Replies: 5
    Last Post: 09-20-2017, 10:07 AM
  4. Replies: 1
    Last Post: 02-23-2016, 11:14 AM
  5. Replies: 2
    Last Post: 10-10-2012, 02:51 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