Easiest way to input Date & Time into Date/Time field

[StarvinMarvin]

Looking for the fastest & easiest way to input a user selected date & time into a Date/Time field. Date picker only does dates.

Or, a way to add multiple records to a table based on a datepicker date and checkboxes indicating specific times.

ie.

Date chosen is 15-Mar-2010 and user checks boxes labeled 2:00pm, 4:00pm and 8:00pm and save button inputs 3 records with 15-Mar-2010 and each of the times checked in the checkboxes?

Data entry for this task is hugely repetitive and greatly slowed by having to hand enter each time for the same date.

 

[vbaInet]

What are these values that are going to be entered 3 times? Does the user press a CONFIRM button after checking the check boxes before it would create the records?

 

[Steve R.]

Several questions come to mind:
1. Are you only interested in when the data is entered into a form? In that case you could simple use "Now()".

2. Are you entering date/time information related to when a product is produced? You might want to have a bar code stamp/reader?

3. Are you monitoring work flow, station 1, station 2 etc.?? Have terminals, that use "Now()" when the product passes through the station.

4. Do you really need to record time? As you note, manual data entry is time consuming. manual data is also prone to error, so think of your data validation issues.

 

[StarvinMarvin]

Hey thanks for the replies guys! This all goes back to a front end we need to produce for assigning employees. This is all entered by hand and a timestamp isn't the info entered. The needed input is date, start time in military time. An example of what is going on now is:

Date: 14-MAR-10
Time: 14:00
Enter

Date: 14-MAR-10
Time: 18:00


Needless to say this is repetative and it would greatly improve throughput if 3 option buttons could insert the 14:00, 18:00, 20:00 or any combo of the three, and then the enter button inserts the same date with the associated 14:00, 18:00 & 20:00 if they are selected.

Up to 3 records, same date, one enter button. This would prevent them from having to type or select the date 3 times and enter those start times 3 times.

 

[Steve R.]

Sorry, but I am confused. Just use the NOW() function when the form is activated (????)

 

[highandwild]

Why not have a date picker using the calender control and then three append queries to enter the three different time records for that date.

 

[StarvinMarvin]

ahhh.... I got them to just change the table to include a field for each start time....wastes a bit of space but there's never more than 1000 records or so in the table anyway. I'll just just the option boxes for each one. Actually it wasted more space repeating the employee number 20 times anyway

Got a new question tho... any way to make the datepicker default to Month+1 to show the next month instead of the current month?

Let me rephrase that, how to make the activex calendar control indicate the current month + 1

 

[vbaInet]

calendarControl.value = DateAdd("m", 1, Date())

 

[StarvinMarvin]

thanks!

that's for the activex 12.0 control?

 

[vbaInet]

It's for any calendar control (in Ms Access)

 

[StarvinMarvin]

hmmff.... I keep getting object doesn't contain automation object calendarcontrol..... I'm using it wrong..... tryin' ta git the form control to display the next month rather than this month....

 

[vbaInet]

Calendar Control 12.0 yes.

You put that code on the ON LOAD event of your form. Obviously you change the text "calendarControl" to the name of your calendar control

 

[StarvinMarvin]

eh...loads but no change.... I'm gonna go get something to eat and forget this crap until tomorrow

 

[vbaInet]

There's probably something you're not doing? Try it on the OPEN event as well.

 

[StarvinMarvin]

OK, now I'm back at work and it's calendar control 11

Still can't find the calendar control when it runs...

 

[vbaInet]

Still can't find the calendar control when it runs...

This is a new development? Not your initial query

 

[StarvinMarvin]

yah, the tables have been changed to facilitate simpler entry on checkbox clicks.... it'd just be handy to have the activex calendar control onload to current month + 1 but everywhere I try it the control can't be found or doesn't allow control of it this way.... I dunno


aaaaannd I just thought of something, changing the tables to checkbox 3 fields for time screws me up for reporting! I can't group if there aren't times for each record.

Back to one button press inserting multiple records. The preferred method would be datepicker for the date, 3 checkboxes for each time and enter submits multiple records based on how many "time" checkboxes were clicked:

03-Mar-10 picked, and the operator clicks 1400, 1800, the enter button submits 2 records with same date and a time of 1400 in record one, 1800 in record 2 etc. If they click 3 boxes then 3 separate records with the same date and 3 separate starting times.

I'm getting bogged down with this entire project.

 

[vbaInet]

What is the name of your calendar control?

 

[StarvinMarvin]

as of now it's calendarcontrol0

Actually now that I screwed up the reporting side of this it's more important for a method to submit multiple records using up to 3 checkbox controls... researching that one now...

 

[vbaInet]

Good luck with that. Don't forget to use the Advanced Search on the forum.