Recent content by Paul-Learning

Hi, Appreciate yr feedback but problem now solved ... thanks a lot

Thanks for your help arnelgp. Pasted your code into a new module however one line is showing a problem when I go to compile: Else ReDim arr(UBound(v-1)) Any ideas? Thanks Paul UPDATE: My knowledge of VBA isn't great but by breaking down the steps of what the code was doing I have...

Thanks to you all for your help, it's much appreciated however I appear to have missed something out which, in retrospect, is blindingly obvious. I went with theDBguy solution and it works perfectly, however, although I now have "Last Folder" I also need (as separate field) the first part of...

Hi, I'm new to Access (using office 365) and so far it's all going well but I'm a bit stuck. I'm trying to split (in a select qry) part of a text string (which is a file path) eg: Field "Path" eg D:\Music\CD Collection\2000\Rock\ what I'm trying to achieve is, irrespective of the number of...