i have a database that when a colleague wants to update their record, they click add button and a user form appears. So far so good, they then press submit and the data transfers onto the table.
i Have left the option open for any user to input data directly onto the table. When it comes to the time format it must be as HH:MM so 13:45 not 13.45. If the user does not enter the time format in the correct way it still transfers the data but the sum value is wrong.
is it possible to put a code on the user from text box where it is asking for start time that they must put the entry in 00:00 format when entering onto the user form of add or use Else it will return a critical message to re enter.
Thanks
Paul
i Have left the option open for any user to input data directly onto the table. When it comes to the time format it must be as HH:MM so 13:45 not 13.45. If the user does not enter the time format in the correct way it still transfers the data but the sum value is wrong.
is it possible to put a code on the user from text box where it is asking for start time that they must put the entry in 00:00 format when entering onto the user form of add or use Else it will return a critical message to re enter.
Thanks
Paul