How to create an accommodation availability chart in Access?
I am creating an accommodation rental database.
How can I include an availability chart like in the picture below?
Can it be done in Access?
Should I link to or embed Excel or Outlook?
I am using Access 2010.
How can I include an availability chart like in the picture below?
Can it be done in Access?
Should I link to or embed Excel or Outlook?
I am using Access 2010.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Jeff,
Yes that is precisely what I need.
It will surely not be trivial and I will need a lot of help.
In the mean time I suppose I will do the calculations in Access and export tables to Excel for the visual mapping. All I need is to show visually where accommodation is available and where not.
Hi Dale,
I think I will be using Excel as discussed in your second and third paragraphs.
Hi Scott,
Thanks, Interesting!
Yes that is precisely what I need.
It will surely not be trivial and I will need a lot of help.
In the mean time I suppose I will do the calculations in Access and export tables to Excel for the visual mapping. All I need is to show visually where accommodation is available and where not.
Hi Dale,
I think I will be using Excel as discussed in your second and third paragraphs.
Hi Scott,
Thanks, Interesting!
It is not just tables that are limited to 255 columns. Queries are also limited so your export to Excel will need to use OLE automation. You won't be able to use TransferSpreadsheet or link to Excel. Forms/Reports have a maximum width so you will run into that also and probably before you run into the column limit.
If you create the interface in Access (and you can), you need to use a sliding technique where only a period of data is visible at one time. Eight months would be the maximum possible but you might limit it to two months so the controls are bigger. You would have to scroll left and right one month or week at a time.
I should warn you that all that conditional formatting to colorize the controls will make the form sluggish and make it flicker. So, the fact that you can do this in Access doesn't mean you should.
If you create the interface in Access (and you can), you need to use a sliding technique where only a period of data is visible at one time. Eight months would be the maximum possible but you might limit it to two months so the controls are bigger. You would have to scroll left and right one month or week at a time.
I should warn you that all that conditional formatting to colorize the controls will make the form sluggish and make it flicker. So, the fact that you can do this in Access doesn't mean you should.
ASKER
Thanks for the support.
(No points wanted)
At first glance, Outlook would appear to be a good choice because the exact "Gantt" look it would give you.
(Scheduling Assistant)
For example:
1. Each of your "Properties" would need to be separate Outlook "users"
2. You would not have any of the "Property Groupings" you are looking for
...etc
JeffCoachman