Search results

Our database has a table with ole object field. Stored in this field are photos of employees. Users insert the photos by copying in Word or Excel and pasting in a bound control on a form. This used to work fine. When we upgraded to Windows 10, photos cannot be inserted anymore using the form. No...

Ok, got it! Found out you can add the lookup table twice in the query builder. SELECT tblWeld.WeldNo, tblProcess.ProcessCode, tblProcess_1.ProcessCode FROM (tblWeld INNER JOIN tblProcess ON tblWeld.ProcessA = tblProcess.ProcessID) INNER JOIN tblProcess AS tblProcess_1 ON tblWeld.ProcessB =...

Let's say I have 2 tables, tblProcess and tblWeld, as shown in the figures below: How do I create the sql so that what I get in ProcessA and ProcessB is the corresponding ProcessCode without doing DLookup?

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.

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...

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

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

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.

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

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

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.

I'm almost there. I think the nulls from the dates are not being included. how do I include them?

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...

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...

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

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]+"-") &...

Thank you both minty and arnelgp! Much appreciated.

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

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

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...