Date and time entry

[Joe]

Hi

Though I've used access before it has been with ready made templates.
I am now trying to write simple database programs using the wizard as I
am quite new to this sort of thing.
I have a simple database to log phone calls made and a field to enter
the date and another the time. I used the =Date() in the properties
field. (Same with the time).
How do I get the date and time to stay static and not change once entered?
I have tried =Now() but that doesn't seem to work.
As I've said I'm new to this so am not confident of going into Visual basic.
Appreciate any help with this one.

Thanks

Joe

 

[Jerry Whittle]

At the table level you should be using Date() and Time() as the default value
for new records. This will not change existing records nor will it change
when the record is modified. Of course someone could manually modify the date
and time fields.

I would recommend only one field with Now() as it contains both the date and
time.

 

[Joe]

At the table level you should be using Date() and Time() as the default value
for new records. This will not change existing records nor will it change
when the record is modified. Of course someone could manually modify the date
and time fields.

I would recommend only one field with Now() as it contains both the date and
time.

Thanks Jerry but I tried that. I still keeps updating the time and date.
In the properties box of the timefield I entered =Now() and the same in
the date field.
However it doesn't stop the field from updating.
Do I have to go and do i with code?
Regards

Joe

 

[Jerry Whittle]

What properties box are you talking about? If you are using a form, I'm
thinking that something in the form is updating the records. Set the default
value at table level and remove anything like =Date() in the properties of
the form.

If you are using the default value at the table, new records get the current
date/time. This date/time isn't changed unless something else forces it to
change.

I'm thinking that something is going on at form level.

If this happens at table level, I'd like to see a copy of that database. We
are talking Access tables and not a table linked to another RDBMS database
like SQL Server?

 

[icyfingers]

What properties box are you talking about? If you are using a form, I'm
thinking that something in the form is updating the records. Set the default
value at table level and remove anything like =Date() in the properties of
the form.

If you are using the default value at the table, new records get the current
date/time. This date/time isn't changed unless something else forces it to
change.

I'm thinking that something is going on at form level.

If this happens at table level, I'd like to see a copy of that database. We
are talking Access tables and not a table linked to another RDBMS database
like SQL Server?

As I said previously I'm completely new at this so bear with me.
I guess it is what you call 'at form level'. I created a simple form
to show date, time, name, phone no. and comments boxes.
In the properties of the date and time I tried entering =Date() and
for the time =Now(). That did not work so gave your other suggestion a
try and used one field with =Now(). That doesn't work either.
No, we are talking about a really simple database that a newbie would
attempt. You would probably fix it in a few seconds.
I could send it if you have the time or the inclination (don't blame
you if you don't !). Not sure how I do that in a newsgroup though.

Thanks

Joe