Automatic reminder
Solved
ifontes
Posted messages
56
Status
Member
-
le meruvien Posted messages 1414 Status Member -
le meruvien Posted messages 1414 Status Member -
Hello,
I have a database consisting of tables and forms with client data and billing data, due dates for payments.
How can I program in ACCESS automatic alerts either when opening my database or directly sent to my Outlook calendar, reproducing the client name and the job/site and have it placed as an appointment in the calendar (Outlook or Google) if one is simpler than the other.
Thanks for your help.
Configuration: Windows / Firefox 33.0
I have a database consisting of tables and forms with client data and billing data, due dates for payments.
How can I program in ACCESS automatic alerts either when opening my database or directly sent to my Outlook calendar, reproducing the client name and the job/site and have it placed as an appointment in the calendar (Outlook or Google) if one is simpler than the other.
Thanks for your help.
Configuration: Windows / Firefox 33.0
3 answers
Hello, when you post a question, at least take the time to look at the answers!!
https://forums.commentcamarche.net/forum/affich-31020703-mettre-des-rappels-automatique#p31024316
https://forums.commentcamarche.net/forum/affich-31020703-mettre-des-rappels-automatique#p31024316
Hello, Meruvien and I had already told you that the procedure you want cannot be executed without VBA, possibly with a macro, but as I told you, you still need to know when and under what condition your alert will open. That said, we can only help you on specific points and with advice, but we cannot really provide turnkey, ready-to-use solutions for you. Best regards.
Hello
thank you for your responses to both of you!
it is true that I hoped for an answer via a query, a form and a macro to be able to set that up.
so I made a query with dates already past and put in a form that I open each time and a status field done or not done and so as soon as I open my database in the morning I open my form and if there are rows without a checked state it means I’m late, so it isn’t automatic but it just gives me the necessary elements to see at a glance.
in any case thank you again to both of you
thank you for your responses to both of you!
it is true that I hoped for an answer via a query, a form and a macro to be able to set that up.
so I made a query with dates already past and put in a form that I open each time and a status field done or not done and so as soon as I open my database in the morning I open my form and if there are rows without a checked state it means I’m late, so it isn’t automatic but it just gives me the necessary elements to see at a glance.
in any case thank you again to both of you
Hello,
At last!
"it's not automatic but it just puts the necessary elements for you to see at a glance."
That's exactly how it should be done: bypass the difficulty by doing something similar but that we know how to do. We progress step by step, we learn, and afterwards we can do what seemed too complicated.
Wishing you all the best and good luck.
At last!
"it's not automatic but it just puts the necessary elements for you to see at a glance."
That's exactly how it should be done: bypass the difficulty by doing something similar but that we know how to do. We progress step by step, we learn, and afterwards we can do what seemed too complicated.
Wishing you all the best and good luck.
Hello,
Well, you’re almost there, now you just need to put this little code in the form's On Open property:
If Me.RecordsetClone.RecordCount = 0 Then 'the form is empty
DoCmd.Close
End If
Don't panic, it's VBA, but very easy to set up!!
In the On Open property of your form, select "Event Procedure" and click the three dots to the right; it opens the VBA window, and there you enter the procedure lines... and End Sub, put this little code.
Well, you’re almost there, now you just need to put this little code in the form's On Open property:
If Me.RecordsetClone.RecordCount = 0 Then 'the form is empty
DoCmd.Close
End If
Don't panic, it's VBA, but very easy to set up!!
In the On Open property of your form, select "Event Procedure" and click the three dots to the right; it opens the VBA window, and there you enter the procedure lines... and End Sub, put this little code.
I replied to your post on my previous request; not knowing a bit of VBA, your answer is already too complicated for me, but mainly I don’t understand it at all. So my request is more: is it possible for Access to send me this as an appointment in Google Calendar or Outlook Calendar, which will automatically remind me, hence my new post to explain my request.
Sorry if I upset you, but I’m desperately seeking a solution because it’s for my work
Thank you for your response and your understanding
Isabelle