Fixing the Date/Time data type so that it display the date and time and not just the date.

[radguy]

I am having trouble getting the proper format in a field where I would like to track the date and time that is inputted into my inventory tracking database. It is ONLY recording the date that I inputs into the database. In the table titled, replacement event, I have 6 fields that have the data type of date/time. In each of them the format is General Date. I would like to be able to record the date AND time but it only records the date Can anyone help me figure out how to display the time AND the date?

Attached are pics of my in design and datasheet view. Let me know if you need anymore pics.

Thanks

[June7]

Try not applying any format to the field.

Can set DefaultValue property of [Date Tool Taken Out of CCAM] to Now() and the date/time will automatically populate when record is created.

Advise no spaces or special characters/punctuation (underscore is exception) in naming convention. Those are very long field names. Why not simply DateOut?

[azhar2006]

The words of Professor (June) True
And for more information see here
http://office.microsoft.com/en-ca/ac...474.aspx?CTT=1

[Missinglinq]

The Default Value cannot be set to Date(), as that only returns the date portion! It has to be set to Now() as June7 suggested! Now() returns both the date and time component.

Linq ;0)>

[radguy]

Is there a way to edit the time? or put in a specific time. I would like to track how much time it takes to do a specific task and I do not want the time the time that it is completed to automatically populate. Is there a way I can add a button to be pressed once a task is finished and then the time it's press the time is populated?

Here is a screenshot of what my form looks like:

[June7]

Sure. Can certainly type the date and/or time. But most users find that annoying, even with the aid of input mask.

Can use code to populate field. I use VBA.

Me.tbxStart = Now()

[azhar2006]

Professor (Missinglinq)
It works well with me
Look at the pictures

[Missinglinq]

Can use code to populate field. I use VBA.

Me.tbxStart = Now()

You can use this code behind a Command Button, or, and I've used this before, place the code in the DoubleClick event of the Control; you DoubleClick on tbxStart and it is populated.

Linq ;0)>

[Missinglinq]

Professor (Missinglinq)
It works well with me
Look at the pictures

Your example in Post #7 shows the Default Value set to Date() which will only populate the field with the date portion; it doesn't matter that the Datatype is set to Date/Time! The poster of this thread wants the date and time, which requires the use of Now()!

Linq ;0)>

[azhar2006]

Ahaaaa
Unfortunately, I understand the question by mistake
Unfortunately renew

[radguy]

Can someone post a screenshot of the proper way to code Me.tbxStart = Now()? I am new to using VBA and I am not 100% sure the correct way to input it into the database. I would like to add it to the Dbl Click event of the field in the property sheet.

[June7]

tbxStart is example of name for a textbox. Use whatever name you have assigned to the textbox or use the fieldname directly.

Do you want macro or VBA? I use only VBA and that is the example given.

Select [Event Procedure] in the event property then click the ellipsis (...) to open the VBA editor. Type code.

http://office.microsoft.com/en-us/ac...010341717.aspx