Recent content by jocph

  1. J

    Solved Help with elimination query

    I'm sorry but your example stilll gives no record. As arnelgp explains, there would always be a record with a 0 in the fields, thus eliminating all.
  2. J

    Solved Help with elimination query

    I have to digest this to contrast with making the condition =0, which gives the correct record (which is 4). Thanks as always!
  3. J

    Solved Help with elimination query

    Of course! I know it should be simple. Thanks arnelgp. I would like to understand though why my sample query does not give any record?
  4. J

    Solved Help with elimination query

    Hi all! I know this is simple but I cannot make it to give me the result I need. Say I have a table like this: How do I make the query not to include record 4 with all 0's in fields Number1, Number2, Number3 and Number4? I tried this: SELECT tblTemp.ID FROM tblTemp WHERE...
  5. J

    Picture Ole Server error

    Thank you isladogs for the dll. I tried registering the dll file but getting an error (fig. below). It might be for 32bit systems and would take some effort to run in 64bit systems. That would be beyond my capacity right now. Would try to run Leban's db in a 32bit system once I have the time. It...
  6. J

    Picture Ole Server error

    Hi isladogs! Along with the mdb, the dll file was included in the compressed file that was downloaded. I'll try to find a machine with 32bit Office and Windows 7 to match the environment it was created. That may be the best thing I can do for now. This is the zip file content: This is the error:
  7. J

    Picture Ole Server error

    Hi The_Doc_Man and Isaac! The database app was developed as 64bit from the start. The problem started to appear when our machines were upgraded to windows 10. It seems there is no ole server for picture type because other document types are not affected (excel, word, pdf, bitmap). I may just...
  8. J

    Picture Ole Server error

    Since it is more advisable to store image files to disk and only store the file locations in the table, I am now trying to extract the pictures from the tables and convert the field to text with links to the extracted pictures. I tried OleToDisk by Leban (http://www.lebans.com/oletodisk.htm) but...
  9. J

    Picture Ole Server error

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

    SQL to show lookup data when referenced twice in table

    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 =...
  11. J

    SQL to show lookup data when referenced twice in table

    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?
  12. 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.
  13. 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...
  14. J

    Mid Function

    I agree that MajP's solution would be best. No time like the present to learn custom functions.
  15. 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
Top Bottom