Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2012
    Posts
    54

    Unanswered: adding a filed wich will count the lenght of each record in a given field

    Hi guys...
    I need your help again
    I' ve question for you is quite easy:
    i'd like to create a filed in a table which will store the lenght of each values' filed:
    here is my code
    Code:
    Sub Lung()
    Dim rst As DAO.Recordset
    Dim MyString As String ' Initialize variable.
    Dim MyLen As String
    
    Dim l As Long
    
    
    Set rst = CurrentDb.OpenRecordset("Accounting", dbOpenDynaset)
        With rst
            Do Until .EOF
            .Edit
          
           !lun = Len([SCHEMA])
        
          
            
            .Update
             .MoveNext
    Loop
    .Close
    End With
    
        Set rst = Nothing
    End Sub
    the problem here is that I don't know how to manage the identity
    Code:
    !lun = Len([SCHEMA])
    in order to make this process wok properly.
    Last edited by jsirico; 02-02-12 at 05:29.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    why do this as a recordset operation
    rather than iterating through a record set it would be far quicker to do this as an upodate statememt


    update mytable set mycolumnlength = len(mycolumn)

    change:-
    mytable to the name to the table
    mycolumnlength to the name of the column to stroe the length of the string
    mycolumn to the name of the column you want to store the length

    this will only work with string columns not boolean, numeric or datetime columns. in any event datetime columns are stored as numeric.

    as to your second problem I haven't got a clue what you are trying to achieve. you really shoudl have two different threads one for each problem.
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jan 2012
    Posts
    54
    ok. thank you.....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •