Hi all!

With thanks to many here I'm making great progress on a database for a small business. Right now I'm working on entering hours worked for hourly employees. I have most of it except one small part. Usually I have timecards from previous days, for example I might have 60 cards for people who worked yesterday.

Is there a way to set a temporary date that will auto fill in the records I'll be entering without changing any previous records? For example, today is 01/05/2002, I'd like to set the date worked as an auto enter of 01/04/2002 for the 60 cards I have, and on Tuesday 01/08/2002 I'd like to set the autoenter date to 01/07/2002. It's not always the day before, especially when folks work the weekend!

Any ideas how to set a temporary auto entry date? I've tried setting up a second database, but I can not get a relationship to work, and I can't create a script to do this, either, and I've tried different layouts to no avail, so I know it's something in how I'm defining the fields. Any help?

Thanks!

Russ Conte

You could format the field to auto-enter the value from a global field, gDefaultDate. Then, you can set the value of gDefaultDate first, and then all newly records will have that date automatically set.

Hi!

I got the first part to work, (all the records have the correct date because I used a Global field) but all of the dates for the previous records also changed to the same date, because it is a global field. Is there a way around this so the old records don't change dates?

Thanks!

Russ Conte

I found an easy way to get this done. Simply check "Auto Enter Value from Previous Record", and it continues with a specific date, and when I have a pile of cards from another date, just put the correct date on the first new record, and all others follow just fine, without changing the old records.

I hope this helps others.

Russ