Search results

  1. J

    Error 94

    Thx I solved the problem with If IsNull (Control) then exit Sub
  2. J

    Error 94

    I have a problem and sure that it started after a windows 10 update. My FE DB give error 94 (invalid use of null). This happened when I want to add a new record.
  3. J

    Save Email to Directory

    Thx Gasman
  4. J

    Save Email to Directory

    Yes But sending Amendment emails, see posts above, from the db the email addresses, subjectline and email body is pulled through to Outlook, so it's just a matter of click send. The email is then saved to the client's sent email subdirectory but in still to send status. But the fact that db...
  5. J

    Save Email to Directory

    Before I tried this as I never placed code in Outlook and is new to me. Will this code in ThisOutlookSession only be linked to emails I send from access DB or all so emails send outside the DB
  6. J

    Save Email to Directory

    Thx I will give it ago
  7. J

    Save Email to Directory

    Arnelgp The link refer to export a list of send email. I try to save a email that was already send. Like in Outlook one send the email and that email is then transferred to the send box. That is the email tried to save.
  8. J

    Save Email to Directory

    Thx Arnelgp will have a look
  9. J

    Save Email to Directory

    Arnelgp I thought about it, but due to the volume of emails send will make it time consuming. That's why I thought there might be away to automate the action.
  10. J

    Save Email to Directory

    Arnelgp Sent Email dir is created if not already exists and email is saved. I picked up that email is save in the before send status. Is there a possibility to save it after I send the message, I know focus shift to Outlook to actually send the email.
  11. J

    Save Email to Directory

    Sent it again to your PM
  12. J

    Save Email to Directory

    Is it something I need to do on my side.
  13. J

    Save Email to Directory

    Arnelgp I have sent the FE and BE hope I did it right Please keep data confidential
  14. J

    Save Email to Directory

    Arnelgp I got the FE as an .accdb extension. Don't ask me how I just tried and tried but BE and FE is now .accdb The Private Sub AmendmentInsurer_Click(), the above code is stopping. I looked at the Reference I have not change the code but strangely it is working in the old version which to not...
  15. J

    Save Email to Directory

    Arnelgp Can I email my DB to your PM I have a problem. My FE and BE are converted to 2007 - 2016 file format. I have a problem that Outlook pause/stop while running the amendment_click code. So just to make sure that all the users are up and running on Tuesday I change back to the older version...
  16. J

    Save Email to Directory

    I did
  17. J

    Save Email to Directory

    Looks as if I did get it right to convert the FE and BE to .accdb FE and BE are communicating with one another Now on to the Email part. I see that your Form1 Record Source is table EmailTmpT and the Email control on the Form1 Control Source is Email with Row Source SELECT EmailsT.Email FROM...
  18. J

    Save Email to Directory

    I did get it right to convert the back to .accdb Now I need to do the same with the frontend My frontend is quite large
  19. J

    Save Email to Directory

    it is a .mdb I do not know how to change the file format. I use Access 2019, but DB was wrote in 1997 or 2000
  20. J

    Save Email to Directory

    Arnelgp I changed Display Control under the Lookup tab in my tblInsContactDetailsTemp to Combo Box with Data Type Short Text. But under the Lookup properties there not setting for "Allow Multiple Value" all else are there except this one.
Back
Top Bottom