Need help with schedule!

[Phalanx]

Im trying to make a week schedule containing the week days and hours, my problem is how to make a form that contains Days on top, hours on the side and extra info in the middle, without making 7 queries and 7 forms (1 for each day)

it should look something like

Hours | Sunday | Monday | Tuesday | ......
6:00..| Jhon... |............|...James..
7:00..|...........| Smith....|............
........|...........|............ |..Sarah..

Iv made a fine example of what i need in the attachment, please reffer to it and tell me how can i do it!

 

[Ron_dK]

Have a look at the example in this thread :
http://www.access-programmers.co.uk/forums/showthread.php?t=64828&highlight=scheduler
This might give an idea how to configure your Dbase.

 

[Phalanx]

Have a look in my example, its not the database im having problem with

 

[Fizzio]

With the Db structure you have, you will find the scheduler impossible to do. It is actually difficult to pull this off effectively so I would search this forum and comb through the relevant results as it has been asked a lot.

If you persist with your current Db structure, expect impending doom

 

[Phalanx]

I was searching up the forums before I've posted this thread.. havent found anything useful for me :\

 

[Rich]

Search for scheduler, there have been many posts on the subject.

 

[Phalanx]

If you'll answer the question in the post below, i belive i can figure my problem out....

http://www.access-programmers.co.uk/forums/showthread.php?p=346276#post346276

 

[Ron_dK]

Phalanx ,

Have a look at this thread and follow the hyperlink :

http://www.access-programmers.co.uk/forums/showthread.php?t=71811&highlight=appointment

http://www.weascend.com/Downloads.htm

These are excellent examples of how to configure a scheduler/appointment
dbase.

Good luck