Programmatic message

[hbtousa]

I was reading the posting (
http://www.access-programmers.co.uk/forums/showthread.php?t=136643&highlight=programmatic+message) and one of the replays adivsed: "(1) Advise the user via programmatic message they they must exit the program for maintenance. If they don't get off after a couple escallated and timed messages, kill their job.". It is this possible in Access?. If so, how is it done.

Thanks

 

[llkhoutx]

In a backend database ad as table which has at least to field bytMessagePriority and sUserMessage. Link that table to each frontend mdb and probably hide it.

In each mdb that has that table linked from the backend mdb to the frontend do the following:

(1) add a hidden form which with VBA periodically check the backend table for bytMessagePriority and sUserMessage, if sUserMessage is not null, display the message in a popup window which stays open until closed by the user. Use the bytMessagePriority counter to count the number of times a message has been popedup.

(2) after so many messages, have the frontend hidden form, cause execute a Quit.Application line of code to be executed.

Just think about you'd do it manually.