So difficult for me - training reservation.

[George]

Dear friends,

I am in the process of developing a training reservation system. I have
already created tables for employees, trainers, trainingCourses and
trainingRooms.

e.g. I have 4 training rooms, 10 trainers, a lot of employees and several
courses.

Each trainer can teach some of the courses (so, I think I will create a
table to record the courses of each employee). Training courses vary from 1-5
days (I record this info into the trainingCourses table).

Using a form, I need to choose the trainer, the training room and then
record the starting date of the course - So far so good! What is needed now
and is too difficult for me:

In case I choose a course which has to be tought in 5 days, this must be
taken into consideration (using days from Monday to Friday) in order to book
the specific room and trainer for those days.

The trainer must be available for those dates and also the training room
should be available.

Any ideas will be highly appreciated.

Thanking you so much in advance,

GeorgeCY

 

[bhicks11 via AccessMonster.com]

I would design a query with the Query Designer that checks the trainers
availability. In the control that you select the trainer, when you exit the
control put some code that runs the query to check if the trainer is already
booked on those days and returns a message if he/she is, setting focus back
on to the control to select a different trainer.

Same thing for room.

Bonnie
http://www.dataplus-svc.com

 

[George]

Bonnie, thanks a lot for your answer.

The main problem is that I need to reserve the trainer and the room for more
than one dates (working days). In my form I will select the starting date,
the trainer, the course and the room. Some courses have to be for 2-7 days.
So, how can I have fill in al the following dates with this information (in
order to be checked lateron for availability)?

Thank you again.

GeorgeCY

Ο χÏήστης "bhicks11 via AccessMonster.com" έγγÏαψε:

 

[bhicks11 via AccessMonster.com]

Yia Sou George,

Add the number of days plus one to the date that the room is book (get it
from your take of courses that indicates how long the class is).

Here's a link about calculating dates:

http://www.databasedev.co.uk/dateadd_calculation.html

Bonnie
http://www.dataplus-svc.com

Bonnie, thanks a lot for your answer.

The main problem is that I need to reserve the trainer and the room for more
than one dates (working days). In my form I will select the starting date,
the trainer, the course and the room. Some courses have to be for 2-7 days.
So, how can I have fill in al the following dates with this information (in
order to be checked lateron for availability)?

Thank you again.

GeorgeCY

Ο χÏήστης "bhicks11 via AccessMonster.com" έγγÏαψε:

I would design a query with the Query Designer that checks the trainers
availability. In the control that you select the trainer, when you exit the

[quoted text clipped - 36 lines]

 

[George]

Yia Sou Bonnie

I need in someway to add all those following days into a new table? How? It
should take into consideration the number of days (1-5) and should take into
consideration only workdays.

Please help, I am so desperate

Kali sou mera (Have a wonderful day)

Ο χÏήστης "bhicks11 via AccessMonster.com" έγγÏαψε:

Yia Sou George,

Add the number of days plus one to the date that the room is book (get it
from your take of courses that indicates how long the class is).

Here's a link about calculating dates:

http://www.databasedev.co.uk/dateadd_calculation.html

Bonnie
http://www.dataplus-svc.com

Bonnie, thanks a lot for your answer.

The main problem is that I need to reserve the trainer and the room for more
than one dates (working days). In my form I will select the starting date,
the trainer, the course and the room. Some courses have to be for 2-7 days.
So, how can I have fill in al the following dates with this information (in
order to be checked lateron for availability)?

Thank you again.

GeorgeCY

Ο χÏήστης "bhicks11 via AccessMonster.com" έγγÏαψε:

I would design a query with the Query Designer that checks the trainers
availability. In the control that you select the trainer, when you exit the

[quoted text clipped - 36 lines]

GeorgeCY

 

[bhicks11 via AccessMonster.com]

Here's a bunch of good date related functions. You can check workdays.

http://www.tek-tips.com/faqs.cfm?fid=4531

Bonnie
Kali Mera

http://www.dataplus-svc.com

Yia Sou Bonnie

I need in someway to add all those following days into a new table? How? It
should take into consideration the number of days (1-5) and should take into
consideration only workdays.

Please help, I am so desperate

Kali sou mera (Have a wonderful day)

Ο χÏήστης "bhicks11 via AccessMonster.com" έγγÏαψε:

Yia Sou George,

[quoted text clipped - 27 lines]

 

[George]

Efcharisto poly Bonnie (Thanks a lot).

I think I now have a lot of information to ivercome my nightmare.

Cheers

Ο χÏήστης "bhicks11 via AccessMonster.com" έγγÏαψε:

Here's a bunch of good date related functions. You can check workdays.

http://www.tek-tips.com/faqs.cfm?fid=4531

Bonnie
Kali Mera

http://www.dataplus-svc.com

Yia Sou Bonnie

I need in someway to add all those following days into a new table? How? It
should take into consideration the number of days (1-5) and should take into
consideration only workdays.

Please help, I am so desperate

Kali sou mera (Have a wonderful day)

Ο χÏήστης "bhicks11 via AccessMonster.com" έγγÏαψε:

Yia Sou George,

[quoted text clipped - 27 lines]

GeorgeCY

 

[bhicks11 via AccessMonster.com]

Tipote George! You can do it.

Bonnie
http://www.dataplus-svc

Efcharisto poly Bonnie (Thanks a lot).

I think I now have a lot of information to ivercome my nightmare.

Cheers

Ο χÏήστης "bhicks11 via AccessMonster.com" έγγÏαψε:

Here's a bunch of good date related functions. You can check workdays.

[quoted text clipped - 22 lines]