Re: After date entered, populate additional dates in other fields

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I used Wk2Date to let me know the difference between Week 1 and Week 2.
Currently we are using an Excell speadsheet and that is the way it is setup.
In Excell it is easy to have the worker enter a date in one cell and then
the dates are automatically populated for both weeks. I guess I am just
trying to emulate the spreadsheet, keeping it simple as possible. At the
moment that is all I am looking for. Thanks for the response and I hope that
I answered your questions.
James

"DStegon via AccessMonster.com" wrote:

First off, if it is always a 2 week payroll, why insert a Wk2Date? You
already know that date from the first date you insert. Are you trying to
create a work schedule plan where your client is inputting the week and
scheduling hours, which are then tracked and reported on and is your program
then doing log ins that are time based to track their actual work hours?

Mike is correct in that this does require some interesting challenges, but
not too crazy. We have a couple different tables that help control the this
process. I can help you with some of the ins-and-outs and table structures
we have used on similar things. We created the ability to insert a 7 day
schedule based on any beginning date, having it fill in already previously
scheduled days within the date range and then saving the "schedule" allowing
it to be printed.

Can you give a little more insight and answer question above.

J T wrote:
Thanks for helping.
Using Access 2003
Client enters date range, in Wk1Date example 3/15/09 and in Wk2Date example
3/28/09.
After the date entrys I want to populate the date in fields Wk1Date1 through
Wk1Date7 and in Wk2Date1 through Wk2Date7.
Wk1Date 1 in my example would be 3/15/09 etc. through 3/21/09 and Wk2Date1
in my example would be 3/22/09 etc. through 3/28/09.
This is for a 2 week payroll program where the first date entered, 3/15/09
will populate the first 7 days and when Wk2Date is entered the next 7 days
will populate additional fields.
Hope this isn't too confusing.
Any help appreciated!
Thanks,
JT

--
DS

Message posted via http://www.accessmonster.com


.

Relevant Pages

  • Re: After date entered, populate additional dates in other fields
    ... First off, if it is always a 2 week payroll, why insert a Wk2Date? ... schedule based on any beginning date, having it fill in already previously ... After the date entrys I want to populate the date in fields Wk1Date1 through ...
    (microsoft.public.access.formscoding)
  • Populate table with stored proc
    ... I am looking to populate a Schedule table with information from two ... A CalendarDays table contains: ... have SQL populate the rows with data based on days off, ...
    (comp.databases.ms-sqlserver)
  • Populate a Table with Stored Proc.
    ... I am looking to populate a Schedule table with information from two ... A CalendarDays table contains: ... have SQL populate the rows with data based on days off. ...
    (comp.databases.ms-sqlserver)
  • two questions
    ... existing schedule and expected the value in that field to automatically ... populate but it did not. ... Jack ... Prev by Date: ...
    (microsoft.public.project)