Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17
  1. #16
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,430

    Yes - your example will replace the two characters when next to each other - it is the equivalent of replacing vbcrlf

  2. #17
    DMT Dave is offline VIP
    Windows 10 Access 2016
    Join Date
    May 2018
    Posts
    1,195
    Once again, thank you to you all, so far I have booked marked ASCLL link you guy's have posted, great learning from that

    After Debugging, pasted all numbers to excel so that i can go through ASCLL table and check what the result should be

    Going to go through the rest of the strings but the first string seems to be solved based on the ASCLL table

    Code:
    Dim ln() As String, sln As String, strFN As String, iln As Integer
      
               ln = Split(strMailMessage, vbCrLf)
                    For iln = 0 To UBound(ln)
                        If InStr(1, ln(iln), "Last Name:") > 0 Then
                            sln = Mid(ln(iln + 2), 1) & vbCrLf & vbCrLf
                        Exit For
                        End If
                    Next iln
                Me.txtName = "" ' Clear Text Box Data
                Me.txtName = sct & " " & sfn & " " & sln ' Should Be >> Title FirstName LastName
                Me.txtName = Replace(Replace(Me.txtName, Chr(13) & Chr(10), ""), Chr(9), "") ' Is >> Now Title FirstName LastName
    
                For i = 1 To Len(Me.txtName)
                    Debug.Print Asc((Mid(Me.txtName, i, 1)))
                Next i
    Thanks again, will mark resolved once i get through the rest of the code

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 04-07-2019, 07:08 AM
  2. Excel refresh blocks Access data entry
    By simaonobrega in forum Import/Export Data
    Replies: 4
    Last Post: 06-30-2017, 11:01 AM
  3. Importing huge files blocks Access
    By dskysmine in forum Import/Export Data
    Replies: 1
    Last Post: 06-14-2012, 08:24 AM
  4. Comment and Uncomment blocks of code
    By TheShabz in forum Tutorials
    Replies: 2
    Last Post: 12-14-2011, 10:23 AM
  5. Try to remove everything to the right of SF
    By murphy in forum Queries
    Replies: 2
    Last Post: 09-15-2011, 03:20 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums