Search results

  1. L

    Solved Help on blank Email body

    Any help from anyone here pls
  2. L

    Solved Help on blank Email body

    the attached db was working perfectly fine earlier. i tried to but not able to get this working' Dear Minty, i tried adding the above mentioned set objMail to the code but not sure how to take it forward request if you may have a look at the attached db for the actual issue
  3. L

    Solved Help on blank Email body

    i will not be able to comment on this due to my poor knowledge on vba. If anyone can help me on this, really appreciate this
  4. L

    Solved Help on blank Email body

    'Create e-mail item Set objMail = olApp.CreateItem(olMailItem)
  5. L

    Solved Help on blank Email body

    i HI! Isaac, i am getting a error, " Object doesnt support the property or method"
  6. L

    Solved Help on blank Email body

    thanks Isaac, will try now
  7. L

    Solved Help on blank Email body

    I am adding my db for better clarification thanks
  8. L

    Solved Help on blank Email body

    HI! I did some changes in the above code. I am now able to get the details in body of the email. But there is one issue now, the email recipient names are missing. any suggestions what i have done wrong here pls below is the code Private Sub send_mail_Click() 'modified by thedbguy@gmail.com...
  9. L

    Solved Help on blank Email body

    No Sir, it is completely blank, except the email address are correctly placed
  10. L

    Solved Help on blank Email body

    HI! i have previously got a solution here which was working fine. Recently without any warning the email body content shows blank. However the email address is correct assigned. Not sure why the body contents are not displayed. I am sharing the previous vba code Private Sub send_mail_Click()...
  11. L

    Solved Help on Select code on combobox

    Very True, thanks MajP once again, will make a note of that and change some of the tables which i am working. I will close this thread as Solved.
  12. L

    Solved Help on Select code on combobox

    Thanks MajP, got the concept. I fear that creating separate tables will fail my project at the end due to lack of knowledge in queries and vba. But yes i have read that creating separate data will help in the long run Thanks again for the knowledge, it was great.
  13. L

    Solved Help on Select code on combobox

    Thank you MajP, Amazing, solution. Honestly this solution has opened new doors where i can replicate this in my other projects Thank you once again. Thanks to Minty for the dlookup option and your valuable time.
  14. L

    Solved Help on Select code on combobox

    Thanks gemma-the-husky for your valuable feedback. Will certainly look at it at later stage.
  15. L

    Solved Help on Select code on combobox

    HI@ MajP, There are close to 99 banks so far, the logic is same for 97 banks which is ABC 003 or PQR 003, For the remaining 2 banks: ABC 001-002 and PQR 001-002 as mentioned in row 1&2 and 5&6 ABC 004 & PQR 004 is not applicable so mentioned NA as there is no bank involved. Hope if i am able to...
  16. L

    Solved Help on Select code on combobox

    Thanks MajP, i am trying to understand your logic and yes the above you analyzed is correct. I am just trying to clarify or better understanding, there won't be any futher additions. Hope this is clear 2 ORG: 1) ABC 2) PQR (This can increase in future) 4 BankId: a) 001 b)...
  17. L

    Solved Help on Select code on combobox

    Thank Minty & MajP for the clarification, I replaced the word to ORG and the ORG combobox, i put below sample of what i have done the change. so far, but i am still getting the same error. Private Sub BankId_AfterUpdate() Me!BankName = Me.BankId.Column(1) Select Case BankId Case...
  18. L

    Solved Help on Select code on combobox

    HI! MajP, how arey you Sir, hope you are doing well. I tried to fill in the code provided by Minty in post #13, did not ask him the meaning of OPR and tired to replace with other controls from the table
  19. L

    Solved Help on Select code on combobox

    HI, i am just trying to identify why the error code 2471 is appearing. I dont know whether i am updated the code correctly or the table itself is wrong.
  20. L

    Solved Help on Select code on combobox

    HI, i am now getting new error 2471, any suggestions i am attaching my db, if i have put the code in the proper place thanks
Back
Top Bottom