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

    Join Date
    Oct 2011
    Posts
    64
    Rep Power
    4

    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
    Stumpier old Moderator
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2003
    Posts
    14,409
    Rep Power
    4538
    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
    ======
    It is a truism of American politics that no man who can win an election deserves to. --Trevanian, from the novel Shibumi

IMN logo majestic logo threadwatch logo seochat tools logo