Timestamp and choose DATE and Time in form's TextBox

[johnseito]

I was able to select General date after I ended and then re-opened the access application, but the end_date in the table is still shown as date and no time.

I have a pics below.

 

[Mihail]

ReEnter dates

 

[johnseito]

how, you mean refilled the form?

I just did that and it still shows only the date and not the time.

 

[johnseito]

ReEnter dates

what does reEnter dates mean?

 

[johnseito]

Ok, after I have looked it over, I don't think is possible to choose a date from a calendar pop out and also a time and input this into the fields in the table.

Because is not possible, I am just going to create a separate date and time filed. Unless is possible with one step.

 

[johnseito]

Ok, I noticed another problem when I tried to separate the date and time field.

I can't create a time field, where a user can choose a time after they use the calendar pop up to choose the date. I believe bc if the user have the option to choose the time, it will be difficult because each hour have 60 minutes and there are 12 hours,

12 times 60 = 720, so there would be 720 options which is a lot.

 

[Mihail]

See post 20

 

[johnseito]

Upload the database (I use A2007)

Upload the database, how do I do that?

I have both access 07 and 10 installed.

 

[Mihail]

2007, but, better, 2003

 

[johnseito]

I use 2007 and is the same result.

The calendar pop up can only choose a date that gets populated into
The auction table and only the date shows, not the time.

 

[ntyler1]

Thanks Milhail.