timeline/calendar datagrid

[Guest]

hi all.
i'm hoping someone can point me in the right direction. i'm trying to
make a scheduling system in our office using access 2003 but i'm having
trouble figuring out how to make a core part of the interface. i need
to make a custom calendar (i guess you'd call it) that's in a
horizontal timeline format. i found a screenshot of something similar
but i can't figure out how it was done. i'm only trying to show the
month/year across the top and a grid for each week within each month.
i'm not interested in the color, etc of the screenshot. users will
enter a number into each grid cell representing how many hours they're
expecting to work. i hope that makes sense. any help will be greatly
appreciated. i don't necessarily need code snippets. i just can't find
a form control that i can change the column spans, etc of the grid (see
screenshot). Thanks. Mark

http://www.retreattracker.com/LodgingAvailability.jpg

 

[Duane Hookom]

This isn't very easy. You might want to take a look at a 3rd party control
like those available from DBI http://www.dbi-tech.com/Default.asp

 

[Guest]

Thanks! i'll take a look.

This isn't very easy. You might want to take a look at a 3rd party control
like those available from DBI http://www.dbi-tech.com/Default.asp

 

[Guest]

Duane,
I recently found/downloaded you DynamSubFrm.mdb demo. (Thanks!). I know
that xtab queries aren't updateable but i'm trying to see if there's a
way to trap changes made (or attempted) that might be sent as an update
query via code --the query would create a temp table then populate the
subform. using your demo as an example, if i clicked in a cell of the
xtab query results is there a way to determine what column/row (or
name/year) i was in? i've tried BeforeUpdate, AfterUpdate, etc but I
can't seem to get anything to trigger a response. Thanks again.

 

[Duane Hookom]

I would probably:
- use an unbound form and some code to add values and update values back to
the normalized table
or
- append records to a temporary un-normalized table for editing and then
posting changes back to the normalized table

I had created a form once that had a bunch of hidden text boxes that could
be made visible and positioned based on start and end times. Users could
drag the ends of the text boxes to adjust the times. It was quite a task and
required lots of error checking and patient users. That's why I recommended
the 3rd party tools.

 

[Guest]

Thanks again. I'm still looking into the 3rd party controls. i'm also
using this as an opportunity to learn more about uses/limitations of
the existing standard controls. i'm a novice at this. is there a way to
duplicate the 'look' of your subform control linked to the query? i
like the simple column/row look. the only events available are
enter/exit. if i make an actual form to use as the subform i have to
use the detail portion and add textboxes, etc to it. i've used
DoCmd.OpenQuery before to open a query and directly update the data but
i haven't been able to figure out how to trap errors/changes that way
either if the query isn't updateable.

 

[Duane Hookom]

I have provided you with all of the solutions that I can think of.

 

[Guest]

just found Form > default view > datasheet. which gets me the look i
want for the subform. now i just have to see how to add fields
dynamically since the xtab will give a different number of columns each
time. as said before, probably not a good way to tackle this but i'm
learning alot.