My form login in my Ms Access application hide immediately after login in a user because I use it to reference the user name control and store the names of the users and those approving documents in the table called tblcontrol for purpose of a proper audit trail. Now I want to reference also all the massages so that they become personalized, I have massages like:
MsgBox “Please check your book keeping entries are not balancing”
Now I want personalize the massage by ensuring that it pick the user name as the starting word like below:
MsgBox “Chris please check your book keeping entries are not balancing”
How can I insert this reference like below within the above message?
What I want to achieve is that all error messages must be personalised, this will help the users to think psychologically that the system knows exactly what they are doing:
I want to replace the (MsgBox “Chris please check your keeping entries are not balancing”) with
MsgBox “Forms!FormName!ControlName.Value please check your keeping entries are not balancing”
but does not work any suggestion here or is there other ways of achieving that?