I have implemented a calendar form into my database pulling files that are due on specific dates. Some calendar days are blank, but some have up to 30 files due on a specific date. Is there a way I can have the calendar distribute space based on the number of files due? On months that have days with many files indicated on that date, the calendar would "grow" to accommodate the number of files. On months where we have no files due, the calendar would maintain a normal size. Also, I would like to hyperlink the file name in the calendar to another form in my database pulling the data specific to that file? I have a form which, based on the file title and date, gives the end user information specific to that file.

joeyc,

Greetings and Welcome to UtterAccess (IMG:style_emoticons/default/welcome2UA.gif)

See if this helps.


AvgJoe (IMG:style_emoticons/default/hat_tip.gif)

Thank you. I don't think this is the same issue, but I would like to see those files because they would be useful in a different area.

My issue: My form always displays every Location and then either displays the word "Available" or the [Event] if it is booked for that date.

This was helpful in another area but it is still not the answer I am looking for. Any other ideas from anyone?