Calendar view

[diegomarino]

hi, i'd like to make a calendar view like that.





what's your suggestions about that? how do you think is the best way to do that?

if i'll make something good i'll share with the community, since i received a lot of help

[Minty]

I would have a google search for Peter Hibbs calendar database examples.

His are about as good as anyone's, and no point reinventing the wheel I'm afraid.

[davegri]

I think Access has a limit of 255 controls on a form. Your image shows about 290 altogether.
You might be able to get around this by having each column as a subform with 34 rows - that would reduce each column from 34 textbox controls to one subform control.

[Micron]

That could be 1 control in each column - e.g. the leftmost field being a record value from a table of time slots, which would make it a continuous form view.

[diegomarino]

That could be 1 control in each column - e.g. the leftmost field being a record value from a table of time slots, which would make it a continuous form view.

this is a good idea.
make a continuos for for every column, if there is a task in the relative timing the record should have a string and a color, if the task is longer than 1 slot (15 min) the record below should be colored too

[Micron]

Just to clarify, the "that" in my post referred to the image posted. The form in the pic could be continuous, but I certainly was not suggesting a continuous form for every 'column'.

[diegomarino]

well, i'll make some tests when i less busy

[Micron]

well, i'll make some tests when i less busy

The suggestion to check out Peter Hibbs calendar db was a good one. You should do that first.

[diegomarino]

The suggestion to check out Peter Hibbs calendar db was a good one. You should do that first.

sure, i forgot to thank about it, already downloaded