Recent content by disgracept

  1. D

    Problem with seting cell formula through vba

    Hi there! I'm getting crazy with a code i wrote to set a formula on a cell through vba. I have a workbook with as many sheets as the days in the month. in each sheet i have a table with 3 columns: client, address and value. When i change a value in the first column (selecting from a validation...
  2. D

    Change Border color of Form

    Now that i looked at it, the color of the form borders is the same as the color of Access... This means that it's coming from the main application?
  3. D

    Change Border color of Form

    I tried that... Didn't work... When i open the second one, this one keeps in front even if i set the focus for the 2nd in the event of the first. If the user clicks in the second it will gain the focus, but i wanted it to be automatic. But didn't try to set the modal property for the 2nd...
  4. D

    Change Border color of Form

    Indeed it's a custom designed form. I designed it. But it has a border. it's border style is set to "Dialog" as you can see in the screenshot below. I also tried with "Thin" border style, but the result was the same. I also thought about the themes and changed the theme of the database, and the...
  5. D

    Change Border color of Form

    Good morning. I have a problem... I can't figure out how to change the border color of the forms i have... In the screenshot below the border is dark pink... And i don't want that. Does anyone know how to do this since there is no border color property for the form? Thanks
  6. D

    [Solved] Send mail from VBA

    Thanks to all that helped me... This thread is now Solved...
  7. D

    [Solved] Send mail from VBA

    Thanks a lot! I'll take a look.
  8. D

    [Solved] Send mail from VBA

    Thanks Uncle Gizmo. I appreciate the offer and, if you can, i would like to have that copy, yes!
  9. D

    [Solved] Send mail from VBA

    vba_php, Sorry if only now i'm answering, but had a pretty busy day here at work. It doesn't work if i put the no-reply@gmail.com in the ReplyTo or From properties. It tries to send but always recieve an error message from google server saying that the account doesn't exist. Of course that, in...
  10. D

    New member here...

    Thanks
  11. D

    [Solved] Send mail from VBA

    In CDO there is a ReplyTo property... there isnt't in the OOM... But there's in fact a sender one... Unfortunately it's only used in a session where multiple accounts are defined in the profile. You can't assign an external mail here...
  12. D

    [Solved] Send mail from VBA

    Well... I'm not tottaly sure but intelissence doesn't show it... I can specify one! The default is the message sender, if you don't specify another one. But if, for example, i put "no-reply@google.com" will it work if i don't have such account created there?
  13. D

    New member here...

    Thanks!
  14. D

    [Solved] Send mail from VBA

    Well guys i tried using OOM and CDO... Both work... Here is the code i used for OOM: Dim OutlookApp As Outlook.Application Dim OutlookMail As Outlook.MailItem Set OutlookApp = New Outlook.Application Set OutlookMail = OutlookApp.CreateItem(olMailItem) With OutlookMail...
  15. D

    [Solved] Send mail from VBA

    Thanks for all your inputs! I think i'll try the OOM and see how it goes... I can always use my own exchange account to send the mails... I'll try to code it and, if i get stuck, i'll come back and ask again if you don't mind... ;)
Top Bottom