Adding Dates

[Guest]

I'm creating an attendance database, and I've figured out how to click time
in and out and then in and out for illness. I'm doing all this in a subform
and the mainform has the client's name/information (169 records). The problem
is I don't want to add today's date for 169 people!!!!! (I'm entering all
their information in the subform (Timesheet Subform table). I know how to do
update queries, but my problem is my relationships--is there anyway of
getting around this? I can't add information to the Timesheet Subform table,
because it's needs my Autonumber from Timesheet Mainform table Does someone
have any ideas on how to quickly generated dates--I'd like to figure all the
days working for the year at once and be able to fiew client and all their
information on a screen.

 

[nanne]

use NOW() als standard value in table

suc6

 

[John Vinson]

I'm creating an attendance database, and I've figured out how to click time
in and out and then in and out for illness. I'm doing all this in a subform
and the mainform has the client's name/information (169 records). The problem
is I don't want to add today's date for 169 people!!!!! (I'm entering all
their information in the subform (Timesheet Subform table). I know how to do
update queries, but my problem is my relationships--is there anyway of
getting around this? I can't add information to the Timesheet Subform table,
because it's needs my Autonumber from Timesheet Mainform table Does someone
have any ideas on how to quickly generated dates--I'd like to figure all the
days working for the year at once and be able to fiew client and all their
information on a screen.

Rita, did you ever get your problem resolved? (an Update query would
be indicated)

John W. Vinson[MVP]

 

[Guest]

I didn't try the "now" suggestion... Guess I can play around with that. I
know how to use the updat query. How I worked around it was I created a field
[Update]Yes/No Field. For each person I put a check in there box for 3/1/06.
Then in my q Update Dates I selected all the records and pasted them. Then I
noted the the ID number ie. 741 of my first "copied" record. Then I did an
update query and took out the [Update] checkmark and changed 3/1 to 3/15.
Well, I have to do this for every single date!!!! But it does work, but I
couldn't think of another way. This is so much easier than going into each
record (there are 169). I need the "connection" of the autonumber in my main
form.

I really wanted to be "hands" off on this attendance database, but I think
I'll just take some time and enter 6 months at a time...

UNLESS there IS an easier way to do this.

I've created five other databases for my husbands company and they're
virtually "maintenance" free except for some occasional minor "tweaking..."
I'm tracking all kinds of information for people with disabilities (mentally
retarded). The government requires SO MUCH INFORMATION!!!!!!