How to combine date and time in the database

Giganews Newsgroups
Subject: How to combine date and time in the database
Posted by:  Luvin lunch (martina_mull…@o2.ie)
Date: 18 Aug 2006

Hi,

I'm new to access and am very wary of dates as I have limited
experience in their manipulation and I know if they're not done
properly things can turn ugly quickly.

I would like to use a calendar control to allow my users to enter a
date but I need them to enter a time as well.  It doesn't look like the
calendar control will allow times to be entered so I was thinking of
having two text boxes.  One text box would contain the date they enter
and would be linked to a calendar control. The second text box would be
of type short time and would allow the user to enter time.  I also
thought I would have a hidden date/time field.  It would be populated
by code I would run in the onChange events of the first two text boxes
and it would be bound to the date/time database field.

So to my questions:
Is this the simplest way of implementing date/time entry?
What function should I use to combine the date and time in the hidden
field?

I'm not sure if what I've suggested is completely ridiculous or not.
Any help would be gratefully received.

Thanks

MM

Replies