Search results

Thanks Minty, my fault but I don't think I am making my problem clear. If it was just one instance of the below I can split that out OK already. Z: = \\Server01\Customer Support ; My problem is the way the script has generated the output is that the below is all generated in one excel...

Thanks Minty but that's left me even more confused as it seems to be just finding spaces and not splitting out like I require.

Hi all, I've been handed a spread sheet that is an output of information captured by a script that captures network drives attached to a user's profile. An example of the output, for one user, is below: K: = \\Server01\MARKETING ; P: = \\Server01\APPLICATIONS ; R: = \\Server02\ENGINEERING ; S...

Thanks Simon, much appreciated!

Hi guys, I'm new to the forum and to Access. I don't know any VBA yet. I have a problem with a cascading form, which writes back to another table. The scenario is: There are three tables. Users, Departments & SubDepartments. Each table has an Autonumber set as the primary key...