Recent content by jocph

  1. J

    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 to fix it.
  2. J

    Query format field

    I tried the samples and the function works correctly in the Select query. SELECT JuntaMesAnoValor.IdAdv_DataSusp, ConcatRelated("MesAnoValor","JuntaMesAnoValor","IdAdv_DataSusp = '" & [IdAdv_DataSusp] & "'","QuotasSolicitadas") AS Mensal, Len([Mensal]) AS Tamanho FROM JuntaMesAnoValor; But...
  3. J

    Mid Function

    I agree that MajP's solution would be best. No time like the present to learn custom functions.
  4. J

    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 mechani",12),5) 30551
  5. J

    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 the string input to the Mid function, like this: Debug.Print [IW49 - Line Items TBL]![Opr# short text] It might be the reason you are having trouble.
  6. J

    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 door handle mechani",8,5) 30551
  7. J

    Solved Need help in Query

    Thanks theDBGuy for your guidance! I'm sure I will be back for more.
  8. J

    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 (((t1.NDERequestDate)=[t2].[MaxOfNDERequestDate])) OR (((t1.NDERequestDate) Is Null)); Seems to be giving me the desired results.
  9. J

    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?
  10. J

    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 when allocated, which you change to True when done updating. You can then check if there is still a False entry in that field and prompt the user to finish...
  11. J

    Solved Need help in Query

    Okay, so I made a query with only 2 of the fields shown (WeldNo2 and MaxofNDERequestDate), which is good since the duplicates are gone. Let's say I name the previous query as T1 and this query without duplicates T2. How do I join them to get all fields from T1 but only the records from T2...
  12. J

    Solved Need help in Query

    Hi theDBGuy, I was thinking along those lines but still on the process of figuring out how to do it. Update you later.
  13. J

    Solved Need help in Query

    I am currently updating a project I inherited. I am trying to simplify some of the queries and I come accross this: SELECT DISTINCT DWR_1.NDEQRNo, DWR_1.ID AS RecID, DWR_Spools.ProjID, DWR_1.StatCode, DWR_Spools.DwgNo, DWR_Spools.SpoolNo, ([DWR_Spools]![WeldNoPrefix]+"-") &...
  14. J

    Solved Error 1004 Unable to set the WindowState property of the Application class

    Thank you both minty and arnelgp! Much appreciated.
  15. J

    Solved Error 1004 Unable to set the WindowState property of the Application class

    Sorry arnelgp, I posted my last comment while not having read your comment. I wonder why we get different values?
Top Bottom