Entries with Autodate

[anonymust]

Good day all.

Im trying to create a database so I can Monitor grocery items from different supermarkets in my area.

I have been doing this on Excel for a while now, and its time to do it properly.

The only issue I would have is when I enter data.



I want to be able to track the price changes on items. I have my own.

So for example. Each time i enter the price of an item, I want a time stamp with it. (being the date when i entered the item, should be automatic)

Can someone assist me with this.

[June7]

Try setting the DefaultValue property of control on form to Date().

[Dal Jeanis]

If you want the exact time, you could also use the beforeupdate event to set your timestamp to now().

[akhmadahdiyat]

Try setting the DefaultValue property of TimeStamp to Now().

[anonymust]

Wow.. what am I doing here... I think I broke it... (sorry for the late reply also)

It doesnt work for some reason anymore...

I will make a new DB

[anonymust]

How can I set a validation now?

I was using same database on a computer of my friends, and his date was set wrong (his system was still in 2010)

I want to make sure that every new entry to this table isnt before the date of the last entry.

If you know what I mean

eg.
Say my last entry was 12-dec-2013
the next entry cannot be a date before 12-dec-2013

but It can be set to 12-dec-2013
or a date greater (after) 12-dec-2013

[June7]

I think that will require VBA code.