Recent content by Sampoline

  1. S

    How do I prevent duplicates being created from an import of directory listing?

    Hi Moke, Thanks for that. Nearly all works. Except doesn't seem to return back the File Owner information. Need that one and the image horizontal resolution and compression and I will be golden. I think it's because those other information is in the details tab of a file, as opposed to the...
  2. S

    How do I prevent duplicates being created from an import of directory listing?

    Hi moke, sorry to keep bringing this thread up again. I just have been playing with your code since writing last and was very keen on the idea of retrieving file metadata from the directory listing. So we are already getting: rs!FPath = myfile.Path...
  3. S

    How to run a query on a column to give a different name

    Hi Arnel, I've checked the list completely and you've solved my issue. Thankyou so much! This was eating me up seriously.
  4. S

    How to run a query on a column to give a different name

    Thanks Arnel, I can see it all coming together now. After exploring the full list, I found a couple of ones that had the following sequence: B-GP-A3-13_scan-0001.jpg which would show up as B/GP/A3/13_scan is there a way to get rid of that text after the underscore? So should just be B/GP/A3/13...
  5. S

    How to run a query on a column to give a different name

    Hi Doc, Quite a few of my values can contain alphanumeric text in the 3rd or 4th string in the sequence. And there is one odd discrepancy I found last night: Found the value B/GA/C3/04.1 in there too. That was the only one, but that may mean in the future I could more data like that. Other...
  6. S

    How to run a query on a column to give a different name

    Hi Arnel, This worked for some of my fields except, but for ones like e.g. B/GA/C3a/01 becomes B/GA/C3a/01 (when it should be B/GA/C3a/1); or B/GA/C3/04.1 becomes B/GA/C3/04 (when it should be B/GA/C3/4.1); or B/JF/D3/094a becomes B/JF/D3/94 (when it should be B/JF/D3/94a) I think the issue is...
  7. S

    How to run a query on a column to give a different name

    Hi Doc, To answer your question, no, it won't be different. The Original Name should always relate to the Required Name. So if original name is B-GA-C3a-04-0001.jpg the required name will always be B/GA/C3a/4 and so on. Which I guess is a relief for me. Basically I want to use this new column...
  8. S

    How to run a query on a column to give a different name

    Hi, I need to run a query to get the 'OriginalName' column to return back the 'RequiredName' column. I've actually done this in Excel as I'm experienced with formulas but not quite strong in the Access query department, anyone know what to do? Thanks. And if possible, to return another separate...
  9. S

    Solved Using VBA to import all excel workbooks from a single folder?

    Funnily enough, not sure why my error was happening. But when I use the same path in a form and do an application.hyperlink "path" it works.. I'll keep working on it thanks
  10. S

    Solved Using VBA to import all excel workbooks from a single folder?

    When I use the UNC path I receive the error shown in post #9.. any ideas why?
  11. S

    Solved Using VBA to import all excel workbooks from a single folder?

    Yeah even I'm not too sure why user have different drive letters. I'm kinda new to the place, but from what I understand the user login profile isn't set up this way. I'll have to get that clarified.
  12. S

    How do I prevent duplicates being created from an import of directory listing?

    Awesome. This is exactly it! Thanks moke <3
  13. S

    Solved Using VBA to import all excel workbooks from a single folder?

    Out of curiosity, is there a way to not use a mapped network drive in the strPath to complete this. Because I've realised that everyone who uses the database would have to map their network drive to the drive letter I assign (in my case "W:\"). Which is not ideal of course. So at the moment it...
  14. S

    How do I prevent duplicates being created from an import of directory listing?

    Hi Moke thanks for the good wishes, Sorry to bring this thread up again. Just wondering if there was a way to control the recursive procedure to only find a specific file format in a folder. For example only ".tif" or only ".jpg" files, as opposed to simply an entire list of everything in the...
  15. S

    Solved Using VBA to import all excel workbooks from a single folder?

    Okay I've solved the issue. So like I said it's on a network location. Reason I blacked it out because it has some sensitive info in the naming. What I did was map the network drive. Plus I was using "acSpreadsheetTypeExcel9" when '*.xlsx' should be "acSpreadsheetTypeExcel12". Once I made these...
Top Bottom