Saving current time and date as record

[Gilberto]

Hello

I have a form where the user enters some pricing information. I need to store in the pricing table (fields time and date) the time and date WHEN the information was entered, so that later the user can print a report with these forms and can see EACH form at what time and date it was ORIGINALLY created/modified.

So far i added two textbox to the form with time and date that show the CURRENT time and date, but when i try to print the report, EVERY form displays the time and date at the time of the printing (current time) not the time they were created. Like a "HISTORY".

How can this be done???

[questionit]

Hi

In the table, you can set the date/time field's default value to =Now()

This way, whenever a record is created, its creation time is automatically written in the date/time field in the table.

You need to make date/time field of Date/Time type.
Qi

Hello

I have a form where the user enters some pricing information. I need to store in the pricing table (fields time and date) the time and date WHEN the information was entered, so that later the user can print a report with these forms and can see EACH form at what time and date it was ORIGINALLY created/modified.

So far i added two textbox to the form with time and date that show the CURRENT time and date, but when i try to print the report, EVERY form displays the time and date at the time of the printing (current time) not the time they were created. Like a "HISTORY".

How can this be done???

[Gilberto]

Hi

In the table, you can set the date/time field's default value to =Now()

This way, whenever a record is created, its creation time is automatically written in the date/time field in the table.

You need to make date/time field of Date/Time type.
Qi

Thanks for the reply.

I cant get it to work. They just appear BLANK, no errors no nothing.

I have in table fields:
time as date/time format long time
date as date/time format medium date
both with default value: =Now()


and in the form textbox:
name: time
control source:time

name:date
control souce:date

[questionit]

Gilberto

When a new record would be entered then your time and date fields would be filled with the values. These fields wouldn't fill up for your old records.

On your form, when you enter the details and click on Save button (if you have one) or by whatever method you save the datain the table, the data will be saved and the current time at save will also be added in your table automatically.

Hope it helps.

Qi

Thanks for the reply.

I cant get it to work. They just appear BLANK, no errors no nothing.

I have in table fields:
time as date/time format long time
date as date/time format medium date
both with default value: =Now()


and in the form textbox:
name: time
control source:time

name:date
control souce:date

[Denburt]

Thanks for the reply.

I cant get it to work. They just appear BLANK, no errors no nothing.

I have in table fields:
time as date/time format long time
date as date/time format medium date
both with default value: =Now()


and in the form textbox:
name: time
control source:time

name:date
control souce:date

First Date is a reserved word as well as Time is a reserved word they are used as a function like so Date() This retrieves todays date. Never use a reserved word for field names in a table, query, or control names in a form etc. Change those names up maybe you can use dated or myDate as a field name in your table etc. they may be confusing MS Access. Once you have completed that then what you have set up should be sufficient to fill a new record with the current date/time info

[Gilberto]

First Date is a reserved word as well as Time is a reserved word they are used as a function like so Date() This retrieves todays date. Never use a reserved word for field names in a table, query, or control names in a form etc. Change those names up maybe you can use dated or myDate as a field name in your table etc. they may be confusing MS Access. Once you have completed that then what you have set up should be sufficient to fill a new record with the current date/time info

Thanks it works perfectly now.

[Denburt]

Thanks it works perfectly now.

That's great, nice job QuestionIt!

Remember, it is usually the little things that will cause you the biggest pains.