i would recomend u to add a new collum to the "tickets table" (or whatever is the table where u put the tickets) with whatever name u want...next put a new textbox and make it not visible....and in teh code do
Me.*textbox name here*.value= Format(NOW(), "HH:MM","DD-MM-YYYY")
H->Hour
M->Minutes...