Search results

  1. M

    Loop through many fields in a table to create a new field

    Thank you for your response. The numbers in total are arbitrary. I just put any numbers. Because I have many fields I did not put all of them. But you are right the total for first row should have at least 3. Ok, I know how to transpose (union all) but is there a way to transpose using loops...
  2. M

    Loop through many fields in a table to create a new field

    I am sorry if my question was not clear. I do not create tables or add new records to them. I get excel sheets and I import them in access. I am looking for a Vba code to loop through the records across the fields.
  3. M

    Question related to a double quotation in Len() function

    Thanks to all of you for your informative explanations. It is clear now
  4. M

    Question related to a double quotation in Len() function

    Sorry I have made a mistake. You are right, it is the second one ,Len (“”& me.searchbox) = 0
  5. M

    Question related to a double quotation in Len() function

    Yes I am, the code is working fine but I needed to understand what it means
  6. M

    Question related to a double quotation in Len() function

    I have a question related to this code please : Len(“”, me.searchbox), what does it mean. I understand all the components of the code but I am trying to put all the pieces together to interpret it correctly. It is a part of the following code , if Len (“”, me.searchbox) = 0 then do something...
Top Bottom