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

    Join Date
    Jun 2003
    Posts
    14,439
    Rep Power
    4539
    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
    ======
    Bartender to Rene Descartes "have another beer?" Descartes: "I think not" and he vanished.
    --Alfred Bester

IMN logo majestic logo threadwatch logo seochat tools logo