Hi,
I am trying to put together a patient admission database. Just as a preliminary warning, since our IT dept is useless I am unable to use macros (they will not provide me with a digital signature).
I am stuck at time stamping. The default value trick does not work, because access creates an empty a new record in line 16 when you start filling in line 15. So the time when record 15 is filled in will be stamped onto record 16, an the time when record 16 will be stamped onto record 17.
What I would need is either manual new record creation, or some way of entering the date into the same field when entering the "time arrived" for a patient. My colleagues would be happy to enter time but I can't expect them to enter the date for every single patient.
Any help is much appreciated.