Fancy calendars for Access?

[pw]

Hi,

We need a Gantt chart type calendar for Access 97 (and soon, Access
2003).

We need it to list the days of the month (for a date range) going
horizontally across the top, the names of the rooms and the names of
who is in those rooms (and how many people are in them) as the detail
records. The rooms would be listed vertically, with the room
information listed under the appropriate days of the months.

Actually, it would be a bar with a person's name on it that would
extend from their arrival date to their departure date (for the
appropriate room).

Any one know of something like that, or how I would do something like
that?

Thanks,
-pw
remove astericks (*) from e-mail address
(use paulwilliamson at spamcop dot net)

----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----

[Alan Webb]

Paul,
Hotel reservations? VB has simple graphics primitives like polygons, lines
& circles. There is enough capability in an Access report object to display
a report of the relationships in a database. Your report would use similar
techniques. I don't know of anything prepackaged to do this so coding may
be your only choice. What I want to know is why Access? There has to be
plenty of packaged hotel reservation and point of sales software around. Is
it cheaper to pay a programmer to write another one in Access?
"pw" <***paulwilliamson@***spamcop.net> wrote in message
news:0o********************************@4ax.com...

Hi,

We need a Gantt chart type calendar for Access 97 (and soon, Access
2003).

We need it to list the days of the month (for a date range) going
horizontally across the top, the names of the rooms and the names of
who is in those rooms (and how many people are in them) as the detail
records. The rooms would be listed vertically, with the room
information listed under the appropriate days of the months.

Actually, it would be a bar with a person's name on it that would
extend from their arrival date to their departure date (for the
appropriate room).

Any one know of something like that, or how I would do something like
that?

Thanks,
-pw
remove astericks (*) from e-mail address
(use paulwilliamson at spamcop dot net)

----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet
News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+
Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption
=----

[GAAPMan]

pw wrote:

Hi,

We need a Gantt chart type calendar for Access 97 (and soon, Access
2003).

We need it to list the days of the month (for a date range) going
horizontally across the top, the names of the rooms and the names of
who is in those rooms (and how many people are in them) as the detail
records. The rooms would be listed vertically, with the room
information listed under the appropriate days of the months.

Actually, it would be a bar with a person's name on it that would
extend from their arrival date to their departure date (for the
appropriate room).

Any one know of something like that, or how I would do something like
that?

Thanks,
-pw
remove astericks (*) from e-mail address
(use paulwilliamson at spamcop dot net)

----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups ----= East and West-Coast Server Farms - Total Privacy via Encryption

=----

[GAAPMan]

Try Bandwood.com. I implemented an add in from them that created a
Gantt chart. Works fairly well. They have a 97, 2000 and 2003
verison. $50.00 but saves a lot of time and effort.

[pw]

Hi Alan!

Paul,
Hotel reservations? VB has simple graphics primitives like polygons, lines
& circles.
Nah, not Hotel reservations. Fishing and hunting lodges, etc....
Mostly small ones.

Not going to work. Too archaic.

What do you think something like this was written in? :
http://www.rezovation.com/rezovation...p/screens.html
There is enough capability in an Access report object to display
a report of the relationships in a database. Your report would use similar
techniques.
I'd like it on a screen/form. With the ability for a user to click on
a square and it would bring up the reservation, etc...
I don't know of anything prepackaged to do this so coding may
be your only choice. What I want to know is why Access?
That is what we decided on years ago, and we like Access :-) I am
mostly a Visual FoxPro guy though.

What else do you recommend? We are having someone work on
web-enabling our application in .NET (ASP.VB) and there are some nice
tools to do this, but can't find anything nice for a desktop version.
We want a nice desktop version and .NET isn't there yet (still .YET
:-).

There has to be
plenty of packaged hotel reservation and point of sales software around. Is
it cheaper to pay a programmer to write another one in Access?
Not sure! We've been burned twice on our web version and have lost
more money than we care to think of (it is just my wife and I).

Thanks!
"pw" <***paulwilliamson@***spamcop.net> wrote in message
news:0o********************************@4ax.com.. .

Hi,

We need a Gantt chart type calendar for Access 97 (and soon, Access
2003).

We need it to list the days of the month (for a date range) going
horizontally across the top, the names of the rooms and the names of
who is in those rooms (and how many people are in them) as the detail
records. The rooms would be listed vertically, with the room
information listed under the appropriate days of the months.

Actually, it would be a bar with a person's name on it that would
extend from their arrival date to their departure date (for the
appropriate room).

Any one know of something like that, or how I would do something like
that?

Thanks,
-pw
remove astericks (*) from e-mail address
(use paulwilliamson at spamcop dot net)

----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet
News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+
Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption
=----

-pw
remove astericks (*) from e-mail address
(use paulwilliamson at spamcop dot net)

----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----

[pw]

>Try Bandwood.com. I implemented an add in from them that created a

Gantt chart. Works fairly well. They have a 97, 2000 and 2003
verison. $50.00 but saves a lot of time and effort.

Too good to be true! I am going to check this out some more!

Thanks so much,
-pw
remove astericks (*) from e-mail address
(use paulwilliamson at spamcop dot net)

----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----

[pw]

>Try Bandwood.com. I implemented an add in from them that created a

Gantt chart. Works fairly well. They have a 97, 2000 and 2003
verison. $50.00 but saves a lot of time and effort.

We need the names of the reservation within the bands though.
Hmmmmm.... I've looked at the DBI-Teck stuff but am trying not to deal
with them if I have to.

Thanks again,
-pw
remove astericks (*) from e-mail address
(use paulwilliamson at spamcop dot net)

----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----

[Alan Webb]

PW,
My first answer in the buy vs. build dilema is try really hard to buy
something first, then decide to build it. Buying someone else's code is
almost always cheaper than enduring the development cycle and building
something. So I'd look at the packages suggested here first. If they don't
serve your needs then coding this has a couple options. One would be an
embedded Excel worksheet where the rows would be a lodging unit (room,
lodge, cabin, whatever) and the columns would be dates available for
reservation. The merge & center cell formatting capability of Excel since
?97? means a reservation is marked on the worksheet using merged cells. You
can embed hyperlinks in Excel worksheets to link to a detail form. I
believe Excel fires a click event when a cell is clicked on and that even
can also trigger code which would bring up a detail form about a
reservation. Two would be to work with label controls positioned on a form
using the top and left properties of the label. With labels you need to
know where the top left corner of the label will be, the width and height of
the label. Labels have a click event which would let you open up your
reservation when one is clicked on. There is enough in labels to do what
you want. Excel adds a heavy load in terms of licensing, computing
resources & so on but gives back enough in return that I'd spend some time
exploring it as a home for this data.
"pw" <***paulwilliamson@***spamcop.net> wrote in message
news:p7********************************@4ax.com...

Hi Alan!

Paul,
Hotel reservations? VB has simple graphics primitives like polygons,
lines
& circles.

Nah, not Hotel reservations. Fishing and hunting lodges, etc....
Mostly small ones.

Not going to work. Too archaic.

What do you think something like this was written in? :
http://www.rezovation.com/rezovation...p/screens.html

There is enough capability in an Access report object to display
a report of the relationships in a database. Your report would use
similar
techniques.

I'd like it on a screen/form. With the ability for a user to click on
a square and it would bring up the reservation, etc...

I don't know of anything prepackaged to do this so coding may
be your only choice. What I want to know is why Access?

That is what we decided on years ago, and we like Access :-) I am
mostly a Visual FoxPro guy though.

What else do you recommend? We are having someone work on
web-enabling our application in .NET (ASP.VB) and there are some nice
tools to do this, but can't find anything nice for a desktop version.
We want a nice desktop version and .NET isn't there yet (still .YET
:-).

There has to be
plenty of packaged hotel reservation and point of sales software around.
Is
it cheaper to pay a programmer to write another one in Access?

Not sure! We've been burned twice on our web version and have lost
more money than we care to think of (it is just my wife and I).

Thanks!

"pw" <***paulwilliamson@***spamcop.net> wrote in message
news:0o********************************@4ax.com. ..

Hi,

We need a Gantt chart type calendar for Access 97 (and soon, Access
2003).

We need it to list the days of the month (for a date range) going
horizontally across the top, the names of the rooms and the names of
who is in those rooms (and how many people are in them) as the detail
records. The rooms would be listed vertically, with the room
information listed under the appropriate days of the months.

Actually, it would be a bar with a person's name on it that would
extend from their arrival date to their departure date (for the
appropriate room).

Any one know of something like that, or how I would do something like
that?

Thanks,
-pw
remove astericks (*) from e-mail address
(use paulwilliamson at spamcop dot net)

----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet
News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+
Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption
=----

-pw
remove astericks (*) from e-mail address
(use paulwilliamson at spamcop dot net)

----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet
News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+
Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption
=----