Search results

  1. T

    HTML construct shows as plain text in email body

    ok, I figured this out! I changed to .HTMLBody = strMessage and it worked! Thank you
  2. T

    HTML construct shows as plain text in email body

    I just used outside email and still not getting HTML. These is got to be a way to send it as HTML
  3. T

    HTML construct shows as plain text in email body

    Can you please send me CDO that sends HTML? I am using CDO to send but don't see any options for HTML or plain text.
  4. T

    HTML construct shows as plain text in email body

    Thank you, Changed that.
  5. T

    Too few paramaters. Expected 2 in OpenRecordset

    I think post #15 (Use TempVars) is more close to the real solution. Thank you Sir!
  6. T

    Too few paramaters. Expected 2 in OpenRecordset

    I resolved this by replacing form references with TempVars and it worked :) Thank you all!!!!!
  7. T

    Email report in body of email

    Thank you!!!
  8. T

    Email report in body of email

    Thank you for the tip. I export as PDF, Attach and then delete? How do I delete this file after I send?
  9. T

    HTML construct shows as plain text in email body

    I used HTML construct when sending email in email body but receive as a plain text. What am I missing? here is my code: Function BuildHtmlBody(SQLStatement As String, ByVal Name As String) Dim html, State, Qty html = "<!DOCTYPE html><html><body>" html = html & "<div...
  10. T

    Too few paramaters. Expected 2 in OpenRecordset

    Can't do that. I use form references in queries that are way before this final query I use in openrecordset. Form is open. If I use debug.print and put this into query, everything works.
  11. T

    Too few paramaters. Expected 2 in OpenRecordset

    No, no tempvars in presecur. standard form references.
  12. T

    Too few paramaters. Expected 2 in OpenRecordset

    Dim db As ADO.Database Dim rs As ADO.Recordset Set db = CurrentDb sql = SQLStatement Set rs = db.OpenRecordset(sql, dbOpenSnapshot) Anything is wrong here? sql query is no problem when open outside of the function
  13. T

    Too few paramaters. Expected 2 in OpenRecordset

    Form is open. I researched that one first :)
  14. T

    Too few paramaters. Expected 2 in OpenRecordset

    Eval() did not help. I wrapped references with Eval() and query works fine but still same error in OpenRecordset... What else can I try?
  15. T

    Email report in body of email

    Thank you very much for your input on this. My problem is that I need to send report via email automatically and DoCmd.SendTo, opens up mail client. I need to automatically convert report to pdf, attach to an email (with email address that will be coming from complex query) and send it without...
  16. T

    Too few paramaters. Expected 2 in OpenRecordset

    Thank you Paul. Yes, there is a form reference inside of precursor query but not in openrecordset statement. Would that still be a problem? Also, I never used this Eval() function. Do I need to use it wrapping form reference?
  17. T

    Multiple time periods in timer

    Very interesting solution. Did not thought of that. To have table with all the time periods and run timer very frequently to check against current time but then I need one field with time when last run for this particular customer. It's the same report with different criteria in bounded query...
  18. T

    Too few paramaters. Expected 2 in OpenRecordset

    No, it's simple 2 query joins... Nothing fancy.No even criteria in final query
  19. T

    Too few paramaters. Expected 2 in OpenRecordset

    Same result with QueryDef... Can't believe this. Query gets data from SQL Server originally. It's going thru multiple layers of query including union query but query itself works by itself as I mentioned... What else can it be? Can't believe I stock on this simple statement.
  20. T

    Too few paramaters. Expected 2 in OpenRecordset

    Thank you but same problem. Did not help
Top Bottom