Search results

  1. R

    Referencing ASCII Character

    Background: This beast of a problem came about when an Outlook Contacts folder was exported to a Table in Access. Since Outlook allows for muliple lines in the "Address" field, the information doesn't make sense in Access, which only allows single line input. So, I've written the following code...
  2. R

    Count Command?

    Thanks to Pat, I've come up with the following code: Sub Macro69() Dim Mystring As String, MyArray, Msg DoCmd.OpenForm "String" Mystring = Forms!String!Address MyArray = Split(Mystring, "*", -1, 1) Msg = MyArray(0) MsgBox Msg Msg = MyArray(1) MsgBox Msg End Sub Returned excatly what I needed...
  3. R

    Count Command...Maybe?

    Thanks to Pat, I've come up with the following code: Sub Macro69() Dim Mystring As String, MyArray, Msg DoCmd.OpenForm "String" Mystring = Forms!String!Address MyArray = Split(Mystring, "*", -1, 1) Msg = MyArray(0) MsgBox Msg Msg = MyArray(1) MsgBox Msg End Sub Returned excatly what I needed...
  4. R

    Refrencing a Field in the Split Command

    The following routine will take a string _expression and break it into parts as set by the delimeter: Sub StringTestMacro() Dim MyString, MyArray, Msg MyString = "VBScriptXisXfun!" MyArray = Split(MyString, "X", -1, 1) Msg = MyArray(0) MsgBox Msg Msg = MyArray(1) MsgBox Msg Msg = MyArray(2)...
  5. R

    Spli Command Question

    The following routine will take a string _expression and break it into parts as set by the delimeter: Sub StringTestMacro() Dim MyString, MyArray, Msg MyString = "VBScriptXisXfun!" MyArray = Split(MyString, "X", -1, 1) Msg = MyArray(0) MsgBox Msg Msg = MyArray(1) MsgBox Msg Msg = MyArray(2)...
Back
Top Bottom