jocph's latest activity

  • J
    jocph reacted to strive4peace's post in the thread Query format field with Like Like.
    Here is a page from Allen Browne's site that discussion truncation of Memo fields. Long Text used to be called memo...
  • J
    jocph replied to the thread Query format field.
    I am not an expert so maybe others could tell why when DISTINCT clause is applied to the SELECT query, the long text gets cut. And how...
  • J
    jocph replied to the thread Query format field.
    I tried the samples and the function works correctly in the Select query. SELECT JuntaMesAnoValor.IdAdv_DataSusp...
  • J
    jocph replied to the thread Mid Function.
    I agree that MajP's solution would be best. No time like the present to learn custom functions.
  • J
    jocph reacted to MajP's post in the thread Mid Function with Like Like.
    Not sure how long you are going to keep banging your heads, but just saying.... tblSAP ID DAW 1 ZS-RPB (30551)Sliding door handle...
  • J
    jocph replied to the thread Mid Function.
    Try this: Daw_No: Right(Left([DAW],12),5) I get this from the immediate window; ?Right(Left("ZS-RPB(30551)Sliding door handle...
  • J
    jocph reacted to Gasman's post in the thread Mid Function with Haha Haha.
    Yes, it is, so you need to start at character 8? :mad:
  • J
    jocph replied to the thread Mid Function.
    In your code, on the line before this: Mid([IW49 - Line Items TBL]![Opr# short text],7,5) Add a Debug.Print so you would see...
  • J
    jocph reacted to MajP's post in the thread Mid Function with Like Like.
    Further it is also an extremely limited solution. It works for one example case. Registration has to be six characters, and number has...
  • J
    jocph replied to the thread Mid Function.
    Using the immediate window, this is what I get: ?Mid("ZS-RPB(30551)Sliding door handle mechani",7,5) (3055 ?Mid("ZS-RPB(30551)Sliding...
  • J
    jocph reacted to theDBguy's post in the thread Solved Need help in Query with Like Like.
    Hi. Glad to hear you got it sorted out. Good luck with your project.
  • J
    jocph replied to the thread Solved Need help in Query.
    Thanks theDBGuy for your guidance! I'm sure I will be back for more.
  • J
    jocph replied to the thread Solved Need help in Query.
    Yes. In case the NDE is not requested yet. Got it to work with this: ON t1.WeldNo2 = t2.WeldNo2 WHERE...
  • J
    jocph replied to the thread Solved Need help in Query.
    I'm almost there. I think the nulls from the dates are not being included. how do I include them?
  • J
    jocph replied to the thread Solved If Statement.
    Do you have a field where you would know if the records you allocated are finished? Maybe add a boolean field that is in False status...
Top Bottom