Hi
Does anyone know if it is possible to use an access form and have a field automatically flag to another system - ie via email or directly into Word - if data is entered into the field. We are currently looking at setting up a monitoring system and if issues are highlighted, admin staff need to be made aware without having to trawl daily through hundreds of records. Also this would have a very high number of users and high number of records so would an access database be the best option?
Any advice greatly appreciated.