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:p7tf21lro0ertgc4dnpirqhghk17urhmdn@4ax.com...[color=blue]
> Hi Alan!
>[color=green]
>>Paul,
>>Hotel reservations? VB has simple graphics primitives like polygons,
>>lines
>>& circles.[/color]
>
> 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
>[color=green]
>> 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.[/color]
>
> 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...
>[color=green]
>> 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?[/color]
>
> 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
> :-).
>
>[color=green]
>> 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?[/color]
>
> 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!
>
>
>[color=green]
>>"pw" <***paulwilliamson@***spamcop.net> wrote in message
>>news:0ocf215n6vq5o5ifo0mvd89qnuav39dslh@4ax.com. ..[color=darkred]
>>> 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
>>> =----[/color]
>>[/color]
>
> -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
> =----[/color]
