June 21st, 2012, 02:35 PM
VBA Split Function?
I'm using VBA in an Access database. I need to split data that looks like this:
1/10/2012 1:14:43 PM1/10/2012 1:14:43 PMLastName, FirstName
I need to split on the PM(or AM) section of this. It doesn't look like there's a Split() function in VBA like there is in VB.NET. Does anyone have any ideas for this?
June 21st, 2012, 02:45 PM
Split() should be available in Access VBA. Check the Access VBA documentation for your version of Access.
I've never been able to appreciate the sublime arrogance of folks who feel they were put on earth just to save other folks from themselves .." - Donald Hamilton