A
afr0ninja
Ok, I admit I'm self taught with Access, and that I'm not necessarily
the brightest crayon in the box however, I cannot figure out a stupid
command button date function for the life of me.
I have a command button set up as
txtDate.Value = Now()
BusUnit.SetFocus
The problem is that the Now() function puts in the time into the date
field. This is causing hell with my date queries where I'll miss
information or if I add a +1 to the end of the date range it grabs an
extra date so I really want to simply get rid of the times entered into
the form.
I've tried things I've found on the forum like
me.txtdate = date
It seems that if I try to use 'date' instead of 'now' the code will
just set focus to the next field and not enter a date.
Any assistance or thoughts would be greatly appreciated. Please keep
in mind that I'm rather new to coding so any detailed information would
be.. uhm.. greatly, greatly appreciated!
Thanks in advance!
the brightest crayon in the box however, I cannot figure out a stupid
command button date function for the life of me.
I have a command button set up as
txtDate.Value = Now()
BusUnit.SetFocus
The problem is that the Now() function puts in the time into the date
field. This is causing hell with my date queries where I'll miss
information or if I add a +1 to the end of the date range it grabs an
extra date so I really want to simply get rid of the times entered into
the form.
I've tried things I've found on the forum like
me.txtdate = date
It seems that if I try to use 'date' instead of 'now' the code will
just set focus to the next field and not enter a date.
Any assistance or thoughts would be greatly appreciated. Please keep
in mind that I'm rather new to coding so any detailed information would
be.. uhm.. greatly, greatly appreciated!
Thanks in advance!