VBA Programming Public Shared Calendar

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When a user enters a shared public calendar, I would like to ask the user to
enter in a subject. The subject entered by the user would then be used to
filter all the appointment in the calendar. Only the information that
contains the information in the subject enter by the user would be displayed
in the shared calendar. Any help would be apprieciated. Thanks.
 
By "enter" do you mean when the user makes that the current folder? Trap
Explorer.FolderSwitch or .BeforeFolderSwitch to get an event you can use to
do what you want.
 
By enter, I mean when a user clicks on the calendar located in the shared
directory. I'll look into those two events that you have provided. In
regards to the filter, I believe it would entail using the restrict function.
I've tried using the restrict function on the calendar but see no results.
Thanks for your help in advance.

felice
 
Restrict returns a filtered set to your code, not to the UI. You would have
to define a custom view for that folder, save the view to that folder and
use code to make it the current view for the folder. The view would
encompass the restriction, however that couldn't be done in real time. So
with a variable filter you don't have any real good options, especially with
Outlook 2000.

About the only thing I can think of offhand would be to use some HTML grid
control on a browser form and set a Web view of that folder.You would use
code to fill the grid based on your restriction and set columns with any
properties you wanted to display.

I think the Outlook View control has limitations with its restrictions from
code but I never use it so I'm vague there. If you search on the control at
www.outlookcode.com you can find Sue's information on the Outlook view
control.
 
Back
Top