Recent content by o2is4u

  1. O

    Split into two text if overflow

    Good Day Any Help Please am totaly lost
  2. O

    Split into two text if overflow

    Thanks for your reply Paul The 2 text boxes are not next to each other actually the second one is bellow to the left. I did try changing the Mid() to so many starts including 76 as you advised, yet the best was to set same to 67. :) any help
  3. O

    Split into two text if overflow

    Good Day I followed your method Paul with bellow details Text 1 Details =Left([Text86],75) And the Text 1 Box is positioned at (Left 5.45) Text 2 Details =Mid([Text86],67) And the Text 2 Box is positioned at (Left 0.926) It works for some arguments and not all. Whenever there are more...
  4. O

    Split into two text if overflow

    Hi Paul I will reflect the can grow and using left and mid as suggested and note if the value is longer it might create a problem. Can Grow Ninety-Seven Million Five Hundred Sixty Thousand Nine Hundred Seventy-Six exactly ///\\\ =Left([Text86],75) Ninety-Seven Million Five Hundred Sixty...
  5. O

    doCmd with two Condition

    I managed to find a solution by changing the second condition with an auto number field from the table having Voucher No. Like this Private Sub Command50_Click() On Error GoTo Err_Command50_Click Dim stDocName As String stDocName = "Payment Voucher" DoCmd.OpenReport stDocName, acPreview, , "...
  6. O

    Split into two text if overflow

    Thanks pbaldy for your quick response. My problem with can grow is it will hit another field. So I want to postion Text2 somewhere else with the overflow from Text1.
  7. O

    Split into two text if overflow

    Good Day I am trying to create another text filed if the first one is overflow in a report. Text= If my time was right I would have taken the chance to find another job but it was not possible since there was nothing available at that time Text count for above is 147. Text1 width =85...
  8. O

    doCmd with two Condition

    Dear pr2-eugin The date is "Short Date like 31/10/13" where it is the end of the month for each voucher. And the objective is to match the Voucher No (Unique) Voucher Month (could be Repeated). I have also tried on another date field still not wotking. Await a reply Thanks in advance
  9. O

    doCmd with two Condition

    Hello Again, I tried to apply same concept as follows: ///// Private Sub Command50_Click() On Error GoTo Err_Command50_Click Dim stDocName As String stDocName = "School Voucher" DoCmd.OpenReport stDocName, acPreview, , " [Voucher No] = '" & Me.Voucher_No & "' And [Voucher Month] = " &...
  10. O

    doCmd with two Condition

    :) missinglinc .. Thanks it worked with a little twest as follows DoCmd.OpenReport "FixedDiscptnActvty", acViewPreview, , " PaytoCurrency = '" & Me.PayToCurrency & "' And StmntID = " & Me.StmntID
  11. O

    doCmd with two Condition

    Maybe answered before but failed to see where :banghead: . Appreciate to assist in setting two criteria where the two filed are text: DoCmd.OpenReport "FixedDiscptnActvty", acViewPreview, , "StmntID = " & Me.StmntID & " And PaytoCurrency = " & Me.PayToCurrency “StmntID =” & Me.StmntID…are...
  12. O

    Hello to All from the Land of Smile

    Good Day to all My name is Frank and and currently staying and living :) in Bangkok for a while. I have been using access and still learning since 2005. I always visit this excellent site for great solutions :confused: when I am stuck naturally . Hope I will learn more as the time comes...
See more
Back
Top Bottom