Recent content by mib1019

  1. M

    Solved Report Output (to pdf) question

    Thanks, theDBguy! That works perfectly.
  2. M

    Solved Report Output (to pdf) question

    Hello all, I know what is causing my issue but don't know how to fix it. I'm sure someone can point me in the right direction.... I have a button on a form that outputs a report to pdf, saves in a specified folder, then attaches it to an email. It's worked perfectly until I had the need modify...
  3. M

    Solved Form not opening as expected

    Thank you DBguy. I was just looking again at the arguments and found that. It's the only form I'm opening in acFormDS so I'd forgotten about that argument being necessary. I've been in lockdown for too long.
  4. M

    Solved Form not opening as expected

    I've got a weird thing happening; hopefully can get some advice here. I am working on a new form. Designed it as continuous form, which I will later develop with some filters, buttons. For now the datasheet serves the purpose. I have set these properties of the form: Default View: Datasheet...
  5. M

    Solved Placement of attachment on Outlook email

    I figured it out. Needed .bodyFormat=olFormatHTML in the setup.
  6. M

    Solved Placement of attachment on Outlook email

    Glad I could edit the original post and take those off! I have made progress in the Signature block issue by modifying the code: 'Set up message Set oEmailITem = oOutlook.CreateItem(olMailItem) With oEmailITem .Display signature = oEmailITem.Body .Attachments.Add strFilePath...
  7. M

    Solved Placement of attachment on Outlook email

    You are right. I thought about it after the fact. YIKES!
  8. M

    Solved Placement of attachment on Outlook email

    Thanks, Isaac. You are correct; it shows correctly at the top of the email when I receive it, so I guess I'm good on that. One other question, though, and that's why is Outlook ignoring my Signature block when sending these attachments via Access VBA? Is there something I need to add in the...
  9. M

    Solved Placement of attachment on Outlook email

    Asked too soon. I sent it to myself and it appears correctly. It still looks funny in the sent items folder though.
  10. M

    Solved Placement of attachment on Outlook email

    Hi all, I have the following VBA code working correctly, except for the wierd placement of the attached pdf in the body of the email. Here is the pertinent code. 'Build email variables strTo = Me.txtSContactEmail Debug.Print "Email to " & strTo strTo = Left(strTo, InStr(strTo, "#mailto") - 1)...
  11. M

    Query filter for this quarter and next

    I'm good with not using the Quarter field for the query, just need all dates that fall into the current and future quarters, with the wrinkle of needing dates to include back to Monday of the week where the quarters start. Thanks for your help!
  12. M

    Query filter for this quarter and next

    I have some date functions in my db but will add whatever you've given me here that are different. Thanks!
  13. M

    Query filter for this quarter and next

    Thank you! That looks like it will work, and will test it tomorrow when I get back to my office.
  14. M

    Query filter for this quarter and next

    Database is used for the purposes media buys, with the quarter starting on the Monday of the week where the quarter rolls. 2021-Q1 begins on 12/28. Air-times they pay for during the last few days of the month are billed in the new quarter. This database doesn't address what their books would...
  15. M

    Query filter for this quarter and next

    The text string is calculated on a form and recorded in a table. I can use dates for the query though.
Top Bottom