Calendars

[hhh]

Hi, I'm very new to Access, and to here. I'm trying to make a database for our small charity run preschool. I've been getting on ok, but what I would really like to do is have a calendar which I can select which days we are open. I have made a form with tick boxes to say which days each child is in, I want to link the two so that when I invoice, it automatically calculates the amount of days in the date range the child will attend , according to the dates we are open.

Could anyone point me in the right direction? Also, if anyone could suggest any books or websites which I can learn from I would be very interested. I'm really enjoying learning about it, but am very aware my knowledge is somewhat lacking! :banghead:

Many thanks

 

[Gasman]

I helped modify this a good while ago.

There well might be others in the Sample database forum?

http://www.access-programmers.co.uk/forums/showthread.php?t=275897

Something to start from at least.?

 

[hhh]

Thanks for the reply - I think I've been looking at this the wrong way. Perhaps I should create a form with a date range, and then get a subform to fill in all the dates between. Then just add tick boxes for the days we are open. The calendar you have looks great but I can't see how I can just tick yes or no with it - or perhaps I am totally missing something else?

 

[Simon_MT]

Perhaps and this is the long way around the problem is having a table with all the days that the preschool is open and by having a start and end date run through this table and count the days here is something similar.

Periods.[Period Start Date] <=#" & SearchDate & "# AND Periods.[Period End Date] >=#" & SearchDate & "#

Simon

Simon

 

[Gasman]

Thanks for the reply - I think I've been looking at this the wrong way. Perhaps I should create a form with a date range, and then get a subform to fill in all the dates between. Then just add tick boxes for the days we are open. The calendar you have looks great but I can't see how I can just tick yes or no with it - or perhaps I am totally missing something else?

I've not even used that calendar, I just amended it for someone on this forum who wanted the week to start on a different day.

From what you are saying I would have a table with all your open dates in it, OR the start dates for each week Then have a table for all the children.

You then have another table that links the two, lets call it ChildDays. All that really needs a a minimum is
ID PK
OpenDays ID FK
Children ID FK

The interface is up to you, but perhaps a few experts will chip in to help there, bearing in mind my signature.

If you went the start date route (and I'm thinking that would be my choice), you might have a drop down for the date, check boxes for the days in the week, dropdown for the child, then a button to create the records in the ChildDays table?

If you got adventurous, you could even have a list box for the children and add records for more than one child at a time for the same week?

At the end of the day, the more work behind the scenes means less work on data entry, and more to learn/discover?

 

[hhh]

Thanks again! I think that may be the way to go - I invoice half termly, so it wouldn't take too long to add all the open dates to one form. I have a form already for children with yes/no boxes for each session (as each does different hours!) so I'll have to try and work out how to link them together.

All the help much appreciated!

 

[Simon_MT]

The preschool is only open on certain days and nothing to do with a child starts. I would have the calendar orientated to the days open and then count the days from when the child starts or days open in the month.

Simon