Recent content by Sampoline

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...

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...

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

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...

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...

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...

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...

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...

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

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

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.

Awesome. This is exactly it! Thanks moke <3

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...

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...

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...