Show data in a calendar

[Rose B]

I have a table that contains bookings for resources (can be for one day or
multiple days) and would like to be able to display them in a kind of Outlook
Calendar format (within Access) - so, for example, if on one day there are 3
bookings, these are displayed as 3 lines under that day. What would be ideal
is if they could be 'highlighted' in a different colour depending upon what
the status of the booking is - Provisional or Confirmed. The display would
show a calendar month at a time and the user needs to be able to move
forward/back a month. If more detail needs to be viewed for a given booking
then they should be able to double click it and this would fire up another
form with the details.

Hope that this is understandable ....... and that there is a way of doing
this in Access!

 

[Peter Hibbs]

Rose,

There is but to get the look of Outlook you would need to use a Flex
Grid Control which will do what you want but you will need
to write a bit of VBA code. Have a look at my Flex Grid Demo program
for some examples.

Go to http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=180

If that looks like something you could use then I also have another
demo which does more or less what you want which you are welcome to
have a copy of. If you are interested, email me at the address in the
documentation and I will send you a copy.

HTH

Peter Hibbs.

 

[Mark Andrews]

A few different routes:
1. Get some calendar code for Access and make that work. I think if you
search on utteraccess.com you can find some examples.
2. The flexgrid examples that were mentioned
3. use a third party calendar component
http://www.dbi-tech.com/
http://www.codejocksoftware.com/
a few others

In general they get tougher but more professional as the numbers get higher
(in my list of 3).
Note: I have been building a scheduling application using #3 and have found
it much tougher than expected.

If you can't find any samples send me an email and I'll send you some and
keep a look out on my site for the scheduling app.
It might be just what you are looking for (probably at least two months away
from launch depending on how busy I get with other projects
that date could be extended).

You could also buy a scheduling app. I've probably downloaded and tried
every app out there so email me if you need some help.
All contact info on my website.

HTH,
Mark Andrews
RPT Software
http://www.rptsoftware.com