Search results

I have been developing our DB for 20 years plus and never had a single issue with it in general terms until by chance our IT dept provided 2 new PC's both running 64BIT Office which then caused random DB crashes we had never seen. Not realising the cause of the issue at the time we spent a few...

I am going mad here trying to work out the InStr, InStrRev, Len, Mid, Right, Left VBA functions!!! Can you help end my struggles please……!? I have a foldername = "c:\TEST\tempfoldera\" (example) And using one/mix of the above functions I want to retrieve everything AFTER the 2nd “\” from the...

OK, again thanks for your help so far. Unfortunately I have hit another problem which I think is a bit above me! I have got to the stage where I have been testing on some small limited chunks of live data. What I have found is this scenario which occurs about 10% of the time when I call the the...

Wow, brilliant thanks, so I assume that I add in the IsFileOpen call where the debug.print is? Like this? Private Sub TEST_Click() Dim c As New Collection Dim i As Long Call RecursiveDir(c, "F:\SFA 2021\Running projects\SSE Contracting Ltd\J32944 Centenary House Crawley (WSCC)\", "*.*", True)...

Ok that is interesting. I would estimate that each time this process runs there will be around 100 files to check BUT, this process is only very infrequently triggered when a user makes an alteration to a CustomerName which as you will appreciate does not happen vey often. So given it is so...

Ok thankyou, I had wondered how hungry it would be on the system. Thanks again for all your help, it is going to be an extremely useful tool!

Hi, I have now got all the code working correctly and updating the folder names on the file system as required. The one obvious problem I have come across is if a folder I am trying to rename is open, or if a file or subfolder within that folder is open. I have a function that will test to see...

Thankyou so much, that is really helpful and as a result I have learned a lot. I have rewritten it slightly and added a process and some counting in as follows, all thanks to your assistance. Much appreciated! Private Sub cmdUpdateFolderpaths_Click() Dim arSQL(1 To 5) As String Dim i...

Hi, one further question if you don’t mind. I am trying to learn and understand how to write code more efficiently without repeating myself. So, in my code above I currently loop through my recordset called “strSQLJobs“. However I need to do this exact same loop for 5 x different recordsets from...

Thanks so much, works perfectly on my test folders! No I've just got to risk running it on our actual data folders!

Thanks very much for this. I have tried this and it works fine, The only issue I have now is if 2 of the folder names have changed, for example: If Foldername = "C:\FolderA\FolderB\FolderC\FolderD\" And I set FoldernameNew = "C:\FolderA\FolderB\FolderCDE\FolderDEF\" The function as it stands...

Thanks, reference my more recent post below do you still think this would work? I guess I’d have to then delete the original Folder?

Hi, just to be clear I don’t want to rename files, I want to rename a folder in the middle of a folder path, so as an example; I want to rename the following original folder path C:\FolderA\FolderB\FolderC\FolderD\ to; C:\FolderA\FolderABC\FolderC\FolderD\

Hi, I have some code which alters the final subfolder name in a folderpath. The code works fine. However, I now want to be able to edit the name of a folder in the middle of the path, i.e. a folder that contains a number of sub-folders. The code I am using errors when I try this. Does anyone...

Thanks. The problem is that I have to calculate about 12 values and am currently already using a DSUM for each which works fine. The reason I was looking to try it with a query was to see if speed the process up.....

Hi, I have a totals query in VBA which has only 1 column which creates a single totalled value. Can anyone advise how I can then take this value and then assign it to a variable so I can use it elsewhere? Thanks

Yes could do but when adding tables etc its such a pain to rearrange things so you can see what your doing for it only to get undone by the time you next go into it!

With a growing DB and ever-growing relationships view I keep trying to rearrange it all to make it clearer and easier to understand however after saving and going back in it always seems to condense all the tables on top of each other at the top of the screen. Has anyone else experienced this...

Hi, thanks for the comment. In answer, there is no pattern to the cursor disappearing, it simply happens randomly on any form at anytime. In terms of on timer events there is one that runs on the main switchboard form that runs a small block of code every 1 minute to check user activity and...

Hi, I am experiencing an issue with the mouse pointer disappearing intermittently whilst using Access. It completely vanishes but then just reappears a few seconds later (anywhere between 2/4 seconds). We are using Windows 10 and Office 365 latest version. I thought it was related to my...