Search results

  1. J

    Code Help.....

    If CNo is number data type, no quotes needed and if Criteria is an entry box in the form, try this: " SELECT COUNT(*) as TotRec FROM T_IssuedWarnings " & _ " WHERE CNo = " & CboSearchWarn.Column(1) & " AND Criteria = '" & Criteria & "'"
  2. J

    Solved Export a Query, Format and save as CSV

    Another approach would be to do the data preparation in Access then write to a text file with csv extension using VBA.
  3. J

    My query keeps asking the user to fill in the parameter

    With the form EmailTableMaintFrm open, open the delete query in Design View, change it to Select Query then open in datasheet view. See if you get the record for the email add in EmailToDeleteFld.
  4. J

    Not Looping as I expected...

    Glad it works. Goodluck!
  5. J

    Not Looping as I expected...

    Hi. Your .Textbody was always overwritten by data from the last record, in the code. Try this: With mail .To = " blah " .From = " blah " .Subject = "Availability Status" .TextBody = "" While Not rs.EOF .TextBody = .TextBody & rs.Fields("sku")...
  6. J

    Can a pdf shown in a web browser control be read only?

    Hi the DBGuy. What you say makes sense. We have the pro Acrobat version so should be able to disable printing if we save the file as secured pdf. Thanks for the reply!
  7. J

    Problem background...

    The form may be doing a refresh or a repaint. And there must be some code behind the button that makes the background move.
  8. J

    Can a pdf shown in a web browser control be read only?

    Good day to the very helpful members of Access World! We have some forms with web browser control that shows the pdf file for a specific selection from a list box. For security reasons, the management wants to disable saving a copy and printing capability of the pdf being shown. Is this...
  9. 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.
  10. 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!
  11. 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?
  12. 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...
  13. 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...
  14. 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:
  15. 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...
  16. 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...
  17. 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...
  18. 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 =...
  19. 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?
  20. 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.
Top Bottom