Need Help! :)

[hodpy62]

Hi All,



Very accomplished excel user but new to Access:

Does anyone know how I can add a date & time picked to a field? Can see the date one but want a joined one for the both of them?

Your help is much appreciated!

Thanks

Hodpy62

[AlexHedley]

There isn't a time picker, just a date one.
You could add buttons yourself that increase and decrease the hrs/mins/secs.

Custom
http://www.utteraccess.com/forum/Tim...ml&hl=date

http://www.utteraccess.com/forum/Tim...-t1454249.html

Links
http://www.accessmvp.com/JConrad/acc...calendars.html

[ItsMe]

I am not aware of a built in time picker for Access. Of course, the user can type the time in the date field. Maybe you could format a date field to display only the date and then have another text box control as a time picker. Then you could use VBA to concatanate the two together. You would have to build a time picker, perhaps with combo boxes or you can take a look at some examples provided by others.

here is an example of a data time picker. I have not looked at it myself but it seems like it is worth a look.
https://www.accessforums.net/code-re...3-a-30187.html

[hodpy62]

thanks for the replies people .. I am looking to have a date/time field in this format dd/mm/yy hh:mm just though it would be neat to use a picker but if not can someone tell me the correct input mask to achieve this? as i said i am new to access so please dont think im a moron i just dont know lol

[AlexHedley]

http://office.microsoft.com/en-gb/ac...#_Toc272229488