I have started working with MS Access for my employer and I have been tasked with creating a 911 floor tool for our Security staff.
When 911 is dialed by anyone in the building Security will receive an email with their name and floor number.
The idea for the tool I would be making is when a Security Officer types in the individuals name into a combobox the image of their floor would appear and their name would be highlighted where their office is. This would enable quick response from the officer if necessary.
I have attempted to do this by making the floor plans and labels not visible and trying to make them viisble by referencing a column from the combo box but I have been unsuccessful.
Any tips would be appreciated.
Thank you.
When 911 is dialed by anyone in the building Security will receive an email with their name and floor number.
The idea for the tool I would be making is when a Security Officer types in the individuals name into a combobox the image of their floor would appear and their name would be highlighted where their office is. This would enable quick response from the officer if necessary.
I have attempted to do this by making the floor plans and labels not visible and trying to make them viisble by referencing a column from the combo box but I have been unsuccessful.
Any tips would be appreciated.
Thank you.