Regina Whipp

The difficult I do immediately, the impossible takes a little bit longer.

Display a custom greeting on the Main Menu

1. Go to design mode of your Main Menu

2. Create a text box

3. Copy and paste the below string in your text box

 

="Good " & IIf(Hour(Time()) < 12, "Morning", IIf(Hour(Timer()) < 16, "Afternoon", "Evening")) & ", " & epFirstName

 

Note:  If you are using an unbound form as a Main Menu then you will have to substitute ‘epFirstName’ with a DLookup to your employee/associate table using either CurrentUser() or if you have a Log-On form that remains invisible.

 

4. Close and save your changes.

5. Log-on to the application!

Forms