Hello,
If someone could help me I would be very grateful.
As part of my job, I maintain a database using Access of which I have limited knowledge. Recently, there has been the need to make some changes to this database & I would like to create an alert.
How I want this alert to function is like this: there is a field where the received date of a document can be recorded. If this field is left blank, I want a message to appear somehow questioning whether this document has been received so that every time the data entry is accessed, they are reminded to check for said document. Additionally, if the date the document is received is entered into the field, I want the alert/warning to go away. This is to prevent people from doing things without having received the correct approval letters & so forth.
I have looked at some answers provided for people with similar queries but they did not appear to be quite the same & sadly, I need it explained to me in the same way a child might need something explained to them.
Again, any help would be really appreciated.
Many thanks in advance
Cali
If someone could help me I would be very grateful.
As part of my job, I maintain a database using Access of which I have limited knowledge. Recently, there has been the need to make some changes to this database & I would like to create an alert.
How I want this alert to function is like this: there is a field where the received date of a document can be recorded. If this field is left blank, I want a message to appear somehow questioning whether this document has been received so that every time the data entry is accessed, they are reminded to check for said document. Additionally, if the date the document is received is entered into the field, I want the alert/warning to go away. This is to prevent people from doing things without having received the correct approval letters & so forth.
I have looked at some answers provided for people with similar queries but they did not appear to be quite the same & sadly, I need it explained to me in the same way a child might need something explained to them.
Again, any help would be really appreciated.
Many thanks in advance
Cali