I originally posted this under the Forms Newsgroup and didn't get any
responses, so I thought I would repost under this group.
Using Access 2000
I have a form, bound to a table, that allows the users to lookup an
employee. Once they are on the correct employee, they then enter time/
payroll, into a subform, for that individual employee.
What is happening, is that we are sending out crews of 2 to 4 guys at
a time to the same job site. In the past,
we would send out just one guy, but with gas prices, etc, we are now
doubling up guys.
So, the payroll girl is entering time, in the subform, for the prior
day, for the one guy. Then she moves onto the next guy on the crew
and enters the same exact data, only for the second guy, then the
third, etc. Thus, she is doing a lot of redundant entry.
What I'd like to be able to do is then take all the records in a
subform for one employee and allow the user to copy that to another
employee. They can manually copy and paste, with no problems. I've
been searching for a way to do this under a command button or
something of that nature.
The form and subsequent subform is isolated for daily entry. Meaning,
that when she gets done entering the daily activity, she has a total
for hours at the bottom for just that day. It's the entries in the
subform, that I want to be able to copy and paste to the next guy on
the crew. Right now, I have her highlighting the rows and doing a
copy, then going to the next person on the crew and pasting, but this
is a manual process and can cause some issues because the girl gets
lost in what she is doing.
So, I am trying to find a way to add code, that will do the copy and
paste for her, without her having to manually highlight and copy, then
highlight and paste.
Any help?