Search results

  1. I

    Looping through 2 recordsets

    Mike and plog, I understand what you are suggesting, but I am not certain as to how to arrive at the desired results in SQL. @Mike Krailo you wrote: "...you can iterate through your new query that contains the count of repeat failures." Do you have any suggestions on how I can do this? I...
  2. I

    Looping through 2 recordsets

    Thank you for your reply. Both recordsets are based on a query from the same tables. The Downtime table contains records for the Station Name, duration of the downtime and comments regarding the downtime. There is a one-to-many relationship with a main table that records the date and shift...
  3. I

    Looping through 2 recordsets

    Using Office 365, I have an Access database that generates an email. Currently it loops through a recordset to determine if any records are greater than 30 minutes in duration. If they are, they appear in red font in an HTML table in the body of the email, if not, then black. The database is...
  4. I

    HTML Email look through two recordsets help

    Gotcha - now :) and so, I did that... and I see 3 open table tags and 3 closed table tags....so, it must be the placement.... " <TABLE Border="" 1 "", Cellspacing="" 0 ""> <TR> <TH Bgcolor="" #2B3856 "", Align="" Center ""> <Font Color=#FFFFFF><b><p...
  5. I

    HTML Email look through two recordsets help

    I thank you for all of your patience with me so far, but I am still muddled. I don't have a text editor. You stated: . So I pasted the code into a Word document and used the Find to count how many instances of the word "table" were in my code to determine if I had too many open table tags...
  6. I

    HTML Email look through two recordsets help

    So, I have neither of those text editors ... so I pasted into Word and did a Find for "table" I have 2 open table tags and 2 closed table tags.... strBody2 = "<TABLE Border=""1"", Cellspacing=""0""><TR>" & _ . . . strBody2 = strBody2 &...
  7. I

    HTML Email look through two recordsets help

    Thank you....so much.... I am almost there! I updated the code as you suggested and I am still getting the 2nd table embedded in the first.... Sorry but I am confused by your comment:
  8. I

    HTML Email look through two recordsets help

    Sorry, I thought it was where the "</table>" flag was... what do I do to overcome this? So should I be filtering by rs3 to what I am on in the first loop? I thought maybe this, but it doesn't work: strSQL3 = "SELECT * FROM qryZonePermCM " & _ " WHERE...
  9. I

    HTML Email look through two recordsets help

    But I got the second table embedded in the first table when I did that.... I do not know how to do this.... any suggestions on how I can accomplish it? I am starting to Google it....
  10. I

    HTML Email look through two recordsets help

    Thanks.... strSQL3 is set just before I build the tables.... strSQL3 = "SELECT * FROM qryZonePermCM " & _ " WHERE qryZonePermCM.ZoneMeetingID = " & HoldMeetingID & "AND ZoneIssueID = " & HoldZoneIssueID however the ZoneIssueID will change...
  11. I

    HTML Email look through two recordsets help

    The "</table>" tags are not in the correct place. Don't I need to close the first table? If I leave them where they are the CMs table gets embedded in the issues table. And If I close the first table by doing this: '*********** display issues & CMs strBody2 =...
  12. I

    HTML Email look through two recordsets help

    Yes, I am getting closer..... made it all strBody2 '*********** display issues & CMs strBody2 = "<TABLE Border=""1"", Cellspacing=""0""><TR>" & _ "<TH Bgcolor=""#2B3856"", Align=""Center""><Font Color=#FFFFFF><b><pfont-size:14px"">No.&nbsp;</p></Font></TH>"...
  13. I

    HTML Email look through two recordsets help

    Cronk, are you asking me to change to this? rs3.MoveNext Loop rs3.Close strBody3 = strBody3 & "</table>" rs2.MoveNext Loop...
  14. I

    HTML Email look through two recordsets help

    Thank you for your response. I had the closing tags in here: .HTMLBody = strBody2 & "</Table><br>" + strBody3 & "</Table><br>" I have since moved them here: rs3.MoveNext Loop rs3.Close...
  15. I

    HTML Email look through two recordsets help

    Hello, I am using Office 365 and am trying to create an email from my Access database in HTML using two linked queries. The email generated looks like this: But my preference is to look like this with each CM following after each issue: Below is my code... can anyone point me in the right...
  16. I

    Error! Filename not specified

    I found this very helpful post and I believe I have resolved my problem: https://stackoverflow.com/questions/27807802/vba-trim-leaving-leading-white-space Thank you getting me on the path to thinking that it's not a blank space.
  17. I

    Error! Filename not specified

    I tried your suggestion as well - Trim(HoldPicturePath) and also have [CODE]DeBug.Print HoldPicturePath [\CODE] in my code and there is still a space at the end despite the Trim... so, I guess it's not a space.... :-( I don't know what do do from here.....
  18. I

    Error! Filename not specified

    This at the top of my form: Option Compare Database Private Type OPENFILENAME lStructSize As Long hwndOwner As Long hInstance As Long lpstrFilter As String lpstrCustomFilter As String nMaxCustFilter As Long nFilterIndex As Long lpstrFile As String nMaxFile As Long lpstrFileTitle As String...
  19. I

    Error! Filename not specified

    DBGuy - I was revising my post when you posted your reply... could you look it again? Thank you.
  20. I

    Error! Filename not specified

    This one has me stumped. I am using Access 2016 in Office 365. I have a database where a user has an input form to collect data and, if they wish, add a picture to the record. This works just fine. The user can then send an HTML email of the record out with the picture embedded. This I got...
Top Bottom