Trying to add to my DB. Looking to be able to keep track of time worked on stock parts on a weekly basis. Would like to be able to enter time at the end of the week, by week. IE; On the week of Sept 10th 29 hours were dedicated to restocking our shelves with stock parts. Is there an easy way to accomplish a calendar setup like this, as I seem top be over complicating the issue I think. If someone could point me in the basic direction on this that would be great.
Calendar in Access
- Thread starter Rylinkus
- Start date
Ive looked at several calendars and none of them seem to be exactly what I want. Ideally what I'd like is something similar to the calendar control built into access. But I'd like to be able to select a week at a time vs. each day of that week. Or even if I could prevent any day but friday from being selected and thusly make it a week ending date. Anyone do anything similar that may be applicable here. Many thanks.
- Local time
- Today, 07:06
- Joined
- Feb 28, 2001
- Messages
- 30,347
In general, when you implement a control, you get to implement some event routines for that control. Such as, for example, a CLICK event. In the OnClick routine, you could check on what was selected and if unacceptable, you could display a message box and refuse to pass focus to another control.
As to selecting a day, week, month, or year, forget about it. This is a matter of interpretation, not selection. If you want someone to select a week, you would make them select a day that is in the week you want, then use your OnClick routine to decide whether the selection makes sense.
Perhaps you could combine a calendar control with a radio button group to select day, week, fortnight, month, quarter, or year. Then select any date within the period. Then use DatePart to decide what you really wanted.
For instance, if you select a week, DatePart would tell you whether the user selected a Monday or not. You could then either adjust backwards to the Monday or reject the selection. Ditto for month, quarter, or year.
Whether you allow the selection is your call.
As to selecting a day, week, month, or year, forget about it. This is a matter of interpretation, not selection. If you want someone to select a week, you would make them select a day that is in the week you want, then use your OnClick routine to decide whether the selection makes sense.
Perhaps you could combine a calendar control with a radio button group to select day, week, fortnight, month, quarter, or year. Then select any date within the period. Then use DatePart to decide what you really wanted.
For instance, if you select a week, DatePart would tell you whether the user selected a Monday or not. You could then either adjust backwards to the Monday or reject the selection. Ditto for month, quarter, or year.
Whether you allow the selection is your call.
