[AccessD] Today's Stupid Question

Frank Tanner III pctech at mybellybutton.com
Mon May 12 14:19:14 CDT 2003


And now for today's stupid question....

I am using Microsoft's DateTimePicker ActiveX control,
because I am mot skilled enough to code my own
caledaring and time system, and am running into some
problems.

I have one DTP (date time picker) in Calendar mode for
start date, and one in clock mode for start time.  I
also have one for end date and time as well.  Due to a
limitation of the ActiveX components, I cannot
directly access the info from my query, so I have to
fill out "invisible" text boxes with the info.

Now comes the problem....

The field I am comparing to is a datetime field in the
following format: mm-dd hh:mm:ss.  I am having no luck
converting the two seperate date and time fields into
a single field in order to compare it to this datetime
field.  Does anyone have any ideas on how I can do
this?  Any assistance you can give would be greatly appreciated.


More information about the AccessD mailing list