Question Message box when a certain user logs on

[Steve_T]

Hi all,
Just a question which i hope you can help me with.
If i create a Table "tblMessage" with the following fields "Username" and Message".
Within the above table there is a message for username() "smithj" how would i get the contents of that message stored in the above table to be shown on a message box when user "smithj" logged on?

i understand this would be a code which is set to the "open form" or "load form" function of the switchboard but not sure how to code it as i am still new to Access.

Sorry the above is a mouth full, and any help i would be very greatfull for.

PS, I have already looked under pop up reminders and message boxes on this forum with no joy but if i have overlooked something please let me know.

 

[gemma-the-husky]

are you using access security or testing windows login

if the latter then simply
environ("username") will give you the logged in windows account

if the former then currentuser gives you the logged in access account
(but if you dont use access security -everyone is "Admin")

 

[Steve_T]

are you using access security or testing windows login

if the latter then simply
environ("username") will give you the logged in windows account

if the former then currentuser gives you the logged in access account
(but if you dont use access security -everyone is "Admin")

Sorry probably did not explain my self i know how to see who the user is i just need a way to tie a message to a certain user via entering both in a table so i dont need to rewrite the code everytime either the user or message changes.