Need a Flowchart type Calendar for a lodging reservation application (Activex?)

[Redstone]

For a Lodging reservatgions system, I need to build in a Flowchart type
Calendar. Also called a "Tape" in the lodging business. This has a
list of rental units down the left side and dates along the top. Booked
dates are blocked out.

A sample of what I need is at the following address:
http://www.fini.to/SamanthaFlowchartCalendar.pdf

Does anyone know of an ActiveX component or some code I could buy that
would do this.

 

[Damon Heron]

It seems to me if all you want is a visual aid, you'd be better off using a
pdf form or Excel. In Access, I would have a form that has a list of rental
units, and by selecting one, the form would show vacancy dates, and allow
for filling in a new reservation. If you wanted info on trends -for
instance, a busy weekend or holiday period, then you could have a report
that could show that.

HTH
Damon

 

[Albert D.Kallal]

I don't see why you could not build a continues form.

Here is some screen shots of continues forms:

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

You could certainly build a grid..and have a check box bound to a custom
function. If your access developer has good skills, then building such a
screen shot not be too hard at all.

here.

Another approach would be to use a activeX control....something like
tlist7...
Here is a few "test" screens I done with tlist7
http://www.kallal.ca/tltest/index.htm

On the other hand, the above tlist7 examples are really VERY much the same
as the ms-flexgrid (free if you have VB6). I have to say that the tlist7 is
a lot nicer, as once you learn one object, you can do treeview like stuff in
addition to grids.

You can find out more about the control here (and there is a trial
edition)...so, get your developer to play with this...and see what they
think...

http://www.bennet-tec.com/btproducts/tlist/tlist.htm


I would first use a continues form, and avoid a activeX control as my first
choice....