Search results

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

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

    Got it now. Used debug.print to show me the value. Thanks for pointing me to the right direction. Public Const xlMinimized = -4140
  17. J

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

    Hi Minty, You're right. I looked at the Excel constants in the declaration and xlMinimized is not included. Would you know its value? Public Const xlAutomatic = -4105 Public Const xlDiagonalDown = 5 Public Const xlDiagonalUp = 6 Public Const xlEdgeBottom = 9 Public Const xlEdgeLeft = 7 Public...
  18. J

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

    As additional info, I am using Access 365 but computers in our office also use 2013 and 2016 versions.
  19. J

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

    I want to do late binding on an Excel application object but I am having an Error 1004 (Unable to set the WindowState property of the Application class) if I do it that way. The code runs fine when the Excel object library is referenced. Dim objExcel As Object Dim objWorkbook As...
  20. J

    Dark theme!

    I find it easier on the eyes. My Duckduckgo theme is also dark so as my Youtube and Facebook themes. Glad that you made this an option. (y)
Top Bottom