Multiple Records, one for each day of the week, One Employee, One

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database that has a daily input form. My employers now want this
form changed so that it allows input for a week per person. I want to keep
my table on a daily basis so I have put subforms for each of the days of the
week on one form. I now need to find out a way of telling each of these
subforms what day of the week they represent and be able to grab that record.
Some of the days will not have any input and I would like to keep the
database from saving null or 0 hour days. When I go to the next person, I
need to be able to have 7 clean days, so when I push the next records button
it will give me the next employee record and their 7 days of already inputted
time or 7 days of blank hours rather than the an actual next record.
 
I have a database that has a daily input form. My employers now want this
form changed so that it allows input for a week per person. I want to keep
my table on a daily basis so I have put subforms for each of the days of the
week on one form.
Click to expand...

Owwwwwww....

Not the best idea.

Why not use a Continuous Form? You can display five (or any needed number) of
records on a form simultaneously.
I now need to find out a way of telling each of these
subforms what day of the week they represent and be able to grab that record.
Some of the days will not have any input and I would like to keep the
database from saving null or 0 hour days. When I go to the next person, I
need to be able to have 7 clean days, so when I push the next records button
it will give me the next employee record and their 7 days of already inputted
time or 7 days of blank hours rather than the an actual next record.
Click to expand...

You're making this much more difficult than it needs to be!

John W. Vinson [MVP]
 
A continuous form would be wonderful but I do calculations with the time as
it is being inputted, the information they input is wider than the screen AND
they want all the colors and pretty stuff.

Why do you feel this isn't the best idea?

I realize it is much more difficult than it needs to be but they have been
putting information into this system for the past 6 months and now they want
this change but they don't want to loose any of the information. It would
need a major re-write to be able to make everything look pretty like they
want it to. I would also have to re-write all the reports based on this one
screen if I went to a weekly input rather than a daily.

I have to have this database tested, completed and disbursed by June 30th.
This is a database that I have been working on for the past year and now they
decide on this change. This is just the beginning of the changes they want.
Eventually they want an input from the time clock AND they want all the
Dining Units (7) to be able to access the same database but will get
different information depending upon which Unit logs in.

Sorry....Blowing off smoke because I am really frustrated.
 
Have it all figured out. Thank you. I was just not thinking when I wrote
the previous post. I do appreciate your help.
 
Back
Top