Modifying form controls according to calendars

A

AlecJames

I want to create a form that shows me the free / busy status from several
outlook calendars. Each calendar is for a meeting room. I want to show a
graphic of the floor plan that shows the location of rooms (as a picture
control) and then put a marker over each room which will be
Green = free
Yellow = busy within 1 hour
Red = busy now

I thought I could use an icon for the marker and change the icon image in vba.

I'm new to Outlook forms so I'm looking for some examples of how to -
Run vba script on form load to query the calendars
Read several calendars to know whether appointments exist now (or within 1h)
Select a picture for an icon

Can anyone point me a some tutorials or examples that will get me going?
Reading the calendars from the form load vba is the part I have no idea how
to do.
Thanks
Alec
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top