Search results

I have a form based on a table named <Staff>. The fields in the form are StaffID, Surname, Name, Grade. What I am trying to achieve is that when a particular StaffID is selected, the other corresponding fields (Surname, Name, Grade) are filled up automatically. Could anyone assist? Thanks.John.

Imagine a form where you have to input time value, example 15:30 or 02:00 etc... Is there a simple way to input 1530 or 0200 and access converts the value into proper time? The reason is to eliminate using the ":" each time.

I am trying to build a form to calculate time elapsed/time difference. Example if one turns up for work at 1900hrs (start) and ends his duty at 0200hrs the next day (end), how much time has elapsed? I am trying to use this argument : Elapsed: IIf([end] > [start], Format([end] - [start], "Short...