Input Date form

[Charles D Clayton Jr]

A2K
I have a table with four fields: ID(Primary Key, autonumber),
ID_CostCodes (Foreign Key, Number), Dt (Date), Hrs (Number). For each
date (dt), I record the amount of hours (hrs) worked for a particular
activity (FK). What I need is a form that will have a text field for
each day of the week (i.e. Sun, Mon, Tues, etc.), and unbound box
called "Week Ending" which the user will input a date into and a combo
box for the FK.

Now we come to my problem. Based on the date in the "Week Ending"
field, I need a field below each Day of the week showing the date for
that day (e.g. Week Ending April 24, 2004 would show a date of "20"
below Tuesday, "21" for Wednesday, etc.). Then I need a field below
each date for the user to input the hours worked that day for that
Activity (FK). Not every date will have any hours entered into it.

Now it may be that I am going about the problem in the wrong way and I
am open to suggestions.

Thanks,

Charles D Clayton Jr

 

[Graham R Seach]

Charles,

Your approach seems fine to me. Just make sure you have code in the
WeekEnding combo's AfterUpdate event to recalculate the dates for each day.
Also, I would unbind the form, since each day will represent a separate
record.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html