Search:

Type: Posts; User: vnwallace

Search: Search took 0.01 seconds.

  1. I have another question... In this sequence, I...

    I have another question... In this sequence, I need the error handler to go to the next record if I so choose to exit out of one of the emails (I do not want to send one some days). Any ideas? Also,...
  2. This works!! Thank you very much for all of your...

    This works!! Thank you very much for all of your help!
  3. I used Set objRp = Reports(0) which still...

    I used
    Set objRp = Reports(0) which still doesn't work
  4. It now says Run-time error '2457': The number...

    It now says

    Run-time error '2457': The number you used to refer to the report is invalid
  5. I still cannot get this to work.. it keeps saying...

    I still cannot get this to work.. it keeps saying

    Run-time error '2451': The report name 'Collateral Demand' you entered is misspelled or refers to a report that isn't open or doesn't exist.
    ...
  6. It says it is referring to a report that doesn't...

    It says it is referring to a report that doesn't exist but I have made sure the report is named exactly the same. Here is a link to my updated database. Thanks!!

    Collateral Database Test2 -...
  7. That definitely fixes the issue for saving the...

    That definitely fixes the issue for saving the file and the subject so thank you very much!! My computer at work does not allow for this software to run so I am putting the link below to a screenshot...
  8. Okay the report file attached to the email is...

    Okay the report file attached to the email is still named "DECO Import File" after I inserted your code and changed the report title. Also, since the file does not have a completely unique Identifier...
  9. Just checking to make sure you were able to...

    Just checking to make sure you were able to receive the more recent files? Thanks so much again, it's greatly appreciated!!
  10. Also, I realize that when changing the subject to...

    Also, I realize that when changing the subject to reference the Portfolio Name it will be hard when the file saves because it won't have a unique identifier separate from the others.. any thoughts?
  11. Yes, the original code is working except for the...

    Yes, the original code is working except for the 2 points listed in my message at 2:27 PM (CST). Thank you again for all your help!
  12. Yes, I had modified the database but changed it...

    Yes, I had modified the database but changed it back to original version after things started to get messed up. Here are the few changes I would like to make and when I do, the database messes up and...
  13. I have restored my database back to the original...

    I have restored my database back to the original version and used the previous code you gave me. Now from here can you help me rename my report?

    Private Sub Command11_Click()

    'This will...
  14. Apologies, here is the tagged code: Dim...

    Apologies, here is the tagged code:


    Dim stEmailMessage As String
    Dim stReport As String
    Dim stCaption As String
    Dim myPath As String
    Dim strSQL As String
    Dim stSubject...
  15. Also I notice now that when I see the emails...

    Also I notice now that when I see the emails there is not actual data in there with the below code. It takes out all of the fill ins.


    Dim stEmailMessage As String
    Dim stReport As String
    ...
  16. I also changed DoCmd.OpenReport "Collateral...

    I also changed
    DoCmd.OpenReport "Collateral Demand", acViewNormal How do I get my report title to change on the email? I think there is something that I am missing. Thank you again!
  17. Thank you this works great! I have now changed...

    Thank you this works great! I have now changed the Report title to "Collateral Demand" but I cannot seem to get the PDF to change to that title on the attachment in the email. I have my changed code...
  18. Thanks!! There are a few things that I need help...

    Thanks!! There are a few things that I need help with.. I need to add a "To" address to the emails that gather from the table and a "CC" address of derivcollateral@rgare.com. Also, I need either the...
  19. You are correct in that there is only one record....

    You are correct in that there is only one record. That day for our demands there was only one record that had the column for "collateral to receive" > 0. I am attaching another link for the excel...
  20. Apologies, I have attached the link to the file....

    Apologies, I have attached the link to the file. Thanks!

    DECO Import File - Download - 4shared - Valerie Wallace
  21. Thank you, I used 4Share like directed and below...

    Thank you, I used 4Share like directed and below is the link. Please let me know if this does not work, if it doesn't work I will use another one.

    Collateral Database Test - Download - 4shared -...
  22. Thank you! I will definitely do that next time!...

    Thank you! I will definitely do that next time! What share site should I use? I have never shared a database this way so any help would be greatly appreciated. Thanks again!
  23. Split In To Individual MS-Access Reports And Email To Corresponding Address

    Hi,

    I have the below code that will run my query, print my reports, save them in bulk as a single PDF, and send them in one email. I need help finding the right code to separate the reports so...
Results 1 to 23 of 23