Search results

Sorry for holding you up Vlad, take your time. Will talk with you whenever you are next free tomorrow. I will try the break and step as you suggested till now. Thanks for your time!

HI Vlad, the process doesn't seem to be working? I ran the sub and it didn't copy, move nor create the folder.

So this what I added to this is: Name ToPath & sFileName As ToPath & "\" & "OldVersions" & sFileName 'Check if file already exists in ToPath and skip if yes If Dir(ToPath & "\" & sFileName) <> "" Then GoTo Next_File Name ToPath & sFileName As ToPath & "\" & "OldVersions" &...

Hi Vlad, say if in Location_Source a more updated version of the .tif is created intentionally, and I need that to replace the .tif in Location_Copy, how would I go about that. So let me give a scenario: A file is created into Location_Source, it copies into Location_Copy but only if it doesn't...

Awesome, thanks for that Maj!

Thanks a lot Vlad @bastanu , apart from it working, the code itself makes a lot of sense to me; I knew I was kinda on the right track but just didn't know how to put it all together. You've spared me some headache hours this morning. Cheers for that sir and thanks for taking time out of your day...

Hi Vlad, thanks for that. I've so far successfully worked out how to copy the files from Location A to Location B (only if they don't exist in Location B already). But I'm having trouble understanding how to do the next few parts. I've attached the file for review, if you could help me out...

Hi. I am trying to create an access database that will perform file backups for me. So I'll need to use code to do this. Okay, let's breakdown what I need to do into steps: 1) Set the UNC path of where all files are located (they will all be found in one main folder that contains sub-folders...

Hi Arnell, I tried this but I still receive the recordset not updateable error. Like I mentioned above, if there are duplicates in my data for either FK fields then will this cause this issue?

So in saying this, if I have data that are duplicates in the fields: callnowithsequence tblcontentlisting.[call no]; Then I will receive an error that recordset is not updateable?

Hi Maj, Thanks for the SQL format strings tip! I'll use that in the future. And in regards to your solution, so I tried using Inconsistent Updates but all that did was remove some fields from my query when I ran it and even then it was still giving me a recordset is not updateable error. And...

That's a good question. I hadn't really considered that. Sorry I'm an inexperienced user to Access. I tried to recreate everything, so I've changed my table and text field names btw. Here is the SQL: SELECT tblCallNoFormula.CallID, tblCallNoFormula.FName, tblCallNoFormula.FPath...

I have a main form (frmFileMetdata) that uses a query (qryFileMetadata) as it's recordsource. This query is simply two tables with a foreign key that matches the tables together. In my form, I have a button (that is supposed to open a file using the UNC path of that file (from one of the two...

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