Search results

Any help from anyone here pls

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

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

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

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

thanks Isaac, will try now

I am adding my db for better clarification thanks

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...

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

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()...

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.

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.

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.

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

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...

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)...

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...

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

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.

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