Personalizing Ms Access error masseges
Hi
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?
Forms!FormName!ControlName .Value
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!ControlNam e.Value please check your keeping entries are not balancing”
but does not work any suggestion here or is there other ways of achieving that?
Regards
Chris
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?
Forms!FormName!ControlName
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!ControlNam
but does not work any suggestion here or is there other ways of achieving that?
Regards
Chris
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
no worries Norie, I knew sometimes that happens.... just to point out cheers
No idea where they came from.
Wait, when I look at the code in the question it appears to have the strange quotes and I copied that into my reply.:)