Category: VBA Functions

Function Greeting User on Open: MS Access

TGoldenEye

Function Greeting User on Open Form. Create Greeting morning when program opened ================================= Public Function partOfday(mytime As Variant) ‘Morning from 00:00:01 AM – 11:59:59 AM If mytime > TimeSerial(0, 0, 1) And mytime < TimeSerial(11, 59, 59) Then      partOfday = “Good Morning” ‘Afternoon from 12:00:01 PM – 5:00:00 PM ElseIf mytime > TimeSerial(12, 0, 1) And mytime < TimeSerial(17, 0, 0) Then      partOfday = “Good Afternoon” ‘Evening from 5:00:01 PM – 11:59:59 PM ElseIf mytime > TimeSerial(17, 0, 1) And mytime < TimeSerial(23, 59, 59) Then      partOfday…

Read More