Timetable needed

[DCXtreme]

Hi There guys,

I need to create a timetable for my sports center database, the center is hired out monday - sunday in half hour slots, i would in effect need a calander with places to input each booking every 30 minutes.

Can this be done, has it been done before?

Jon

 

[statsman]

The way to approach this would be based on the facility.
Is it just a gym or do you have other facilities on the premises.

For example, if you have
a gym
and a weight room
and a running track

Each facility can be rented out for a half-hour regardless of who has rented the other facilities. So if a football team has rented the gym for indoor practise, this does not effect the availability of the weight room

If it's just one big room, once its hired it not available to anyone else.

 

[DCXtreme]

Its one big room.

Edit: infact I found the perfect thing for it, its attached, however I am having great problems trying to get it to work - are there any obvious code errors you can spot?

 

[statsman]

I had a look at it. It works fine for me.
It seems to do what it claims, which is book appointments.
It doesn't seem to have any other capacities such as billing clients for the time they use.

 

[DCXtreme]

What version of office did you try it with? I have office 2007 beta - probabbly why, I can work out the billing section of it myself I think.

I think i'll have to get my hands on office 2003 to see if it works!

 

[statsman]

I was using Access 2003.

There is no billing section (at least not in what you sent me).

What you will have to do is add a "Client" table with the info about who hires the facility and the billing information. Assign each client a code (4 or 5 letters).
Add a client field to the appointment table and form to record which client hired it. You would enter the client code here.
Add a query so you can create an invoice for the client. You should include in the query a start date and end date set to your billing schedule (weekly/monthly)
Finally add a report run from the query which would be the Invoice.

 

[DCXtreme]

No you're right there is no billing query.

I actually have found out why it doesnt work on my computer.

It is using the US dates format, but my copy of access / windows uses the UK time and date format.

When I click on September the 12th 12/09 is get December the 9th

Any easy way of fixing this?

 

[DCXtreme]

I was using Access 2003.

There is no billing section (at least not in what you sent me).

What you will have to do is add a "Client" table with the info about who hires the facility and the billing information. Assign each client a code (4 or 5 letters).
Add a client field to the appointment table and form to record which client hired it. You would enter the client code here.
Add a query so you can create an invoice for the client. You should include in the query a start date and end date set to your billing schedule (weekly/monthly)
Finally add a report run from the query which would be the Invoice.

Hi again, I have now come to the point where I need to setup a billing section (although the Large Calendar problem is not fixed) I was wondering if you had any further advice.

 

[Steve2003]

Your calendar was exactly what I was looking for and I had the same problem as you. I have managed to fix it by changing your code slightly.

in your Displaymeetings I changed

strApptDate = Left(strApptDate, intLen - intPos)
to
strApptDate = Left(strApptDate, 2)

and then in your Displaydailymeetings


"WHERE tblAppointments.ApptDate = #" dteMyDate "# " & _
to

"WHERE tblAppointments.ApptDate = #" & Format(DateValue(dteMyDate), "mm/dd/yy") & "# " & _


I am using access 2003 but I hope this helps

Steve