Thank you very, very much Arnel this worked!!! Appreciate all your help in getting this done. I kept your notes/name within the codes so whoever will look at it will see the help you did. Again, thank you so much.
Hi Arnel, When I run the form I get this error. I have not touched anything from what you had sent. You mentioned to move lblNoticed to the main form. My apologies but I'm not quite familiar on what you are asking me to move and how to do it or where to place within the main form. When you say...
Thank you so much Arnel! It worked and an email popped up. One thing though, there were supposed to be 4 recipients but the email that was created was only for the 1st one (Employee 4). When I changed the "Query1_due_date_Subform" single form to continuous form, I see the message "Creating...
Yes I have the query Query1_due_date_Subform. The TimeText textbox is located in the Form Header.
Thanks Micron. I can post a copy of the DB. Where can I save a copy that you can have access?
I'm told that this database will be of no use if an email notification cannot be sent out concerning the due dates. Since the data have several due dates depending on the document, I guess I will need to recreate different forms. One question, I understand that in order for the email to be sent...
I did all the changes but I still get the same error message. Do I need to create an email template? It's supposed to do the email through Outlook. Is there anything special that needs to be done to have the connection between the two? I'm using Microsoft 360 and both Outlook and Access are the...
Ok I believe you are correct. My understanding is when the form is clicked it's supposed to generate the email based on what is listed in the modAutoEmail module. My question is do I need to create template? is this why it is saying method is missing?
Thanks Micron. I hope I got what you are asking. I clicked on the 3 dots on the event within the form properties and it pops up to this. Seems it is attached to the correct form. Did I answer your question?
Hi There!
You can consider me an intermediate in Access and I need your expert advice/help. I'm working on a due date form that would pull the information based on the date range specified. I have put the following and but when I open the form it gives me the error message "The expression On...