alert messages

[FahadTiger]

Hello experts...
when I sit for a long time on my database

I want alert messages..for example

Reminder message every 20 minutes with eye rest

Reminders with a message every 30 minutes to maintain a sitting position

Remind every 45 minutes to move the neck in multiple directions

Reminders every 60 minutes to get up and walk around the office

Any advice?

 

[theDBguy]

Hi. Look into the Form's Timer event.

 

[Gasman]

Buy a Google Mini or an Alexa, and let them do the hard work.
You could do it all with timers, but not sure how much that would affect your DB running 4 at a time?

 

[FahadTiger]

Hi. Look into the Form's Timer event.

I Know that ...
but how can i do it?

 

[Pat Hartman]

If you are actively developing, you do NOT want ANY timer event running in the background. In fact, in apps where I use timer events, I have a hidden "off" feature so that they won't run when I am changing code. You are asking for corruption if you change code while a timer is running.

You couldn't pay me to put an Alexa or Google mini or anything else designed to spy on me in my house. If you want to do this with Access, create a separate app that does just this. That way, you can run it without interfering with your development and also when you are not working on your Access app at all You could alternatively use Excel since it also uses VBA.

Here's an example -- vba - Countdown Timer in MS-Access - Stack Overflow
Here's another example -- On Timer Event - Microsoft Access / VBA (bytes.com)

 

[GPGeorge]

Pat. Google knows all about you anyway, right ?

Seriously, if this is something needed outside of the purpose of any given Access relational database application, or any other application, for that matter, then it should be a standalone application, outside the purpose of any given application, whether in Access or not. Access happens to be a handy way to do that, is all.

As noted, user the Timer event on a form....

 

[FahadTiger]

If you are actively developing, you do NOT want ANY timer event running in the background. In fact, in apps where I use timer events, I have a hidden "off" feature so that they won't run when I am changing code. You are asking for corruption if you change code while a timer is running.

You couldn't pay me to put an Alexa or Google mini or anything else designed to spy on me in my house. If you want to do this with Access, create a separate app that does just this. That way, you can run it without interfering with your development and also when you are not working on your Access app at all You could alternatively use Excel since it also uses VBA.

Here's an example -- vba - Countdown Timer in MS-Access - Stack Overflow
Here's another example -- On Timer Event - Microsoft Access / VBA (bytes.com)

thanks Pat ..I will try it

 

[Pat Hartman]

Pat. Google knows all about you anyway, right

Doesn't mean I need to invite them into my home. I don't use Google. I use DuckDuckGo for searching.