#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2011
    Posts
    64
    Rep Power
    6

    Question VBA Split Function?


    Hello all,

    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?

    thanks,
    dlopez
  2. #2
  3. No Profile Picture
    Grumpier old Moderator
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2003
    Posts
    14,508
    Rep Power
    4541
    Split() should be available in Access VBA. Check the Access VBA documentation for your version of Access.

    http://www.google.com/search?q=acces...ient=firefox-a
    ======
    Doug G
    ======
    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

IMN logo majestic logo threadwatch logo seochat tools logo