I have an MS Access 2010 database which when opened, displays one of three Care Home Duty Rosters as part of its top menu. It can be an Early, Late or Night Roster depending on which 8-hour segment of the day and the date on which the database was opened. This arrangement works fine for the instant that the database is opened. We alight on the required dated record in the required Roster file. All well and good so far, but if whilst the database is open, the actual time of day should go past the time-bracket which is specified for the particular Roster showing, then of course that Roster will be out-of-phase. For example, an Early Roster will still be showing at a time by which the Late Duty team would have reported in for work. (Not what I want at all!) What I need to address this problem, is a way of getting my database to be aware of the time WHILST IT IS OPEN and not just WHEN IT IS OPENED, which is the case at present. Getting some time type object to fire at one-minute intervals would seem to be about right. I have tried setting up a Form Timer but without success so far. I would be grateful for any help on this or for any ideas or suggestions. Thanks in advance.
Comment