If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Customise current view
I have a number of categories set up on my outlook.
However i don't want the appointments in 3 of these categories to be visible at certain times. The ones i do want visible are those with the default null value in the categories field. i created a filter under view, current view, customise current view, filter, more choices tab, and inserted 1 category that i didn't want visible. i then went into the SQL tab and changed the syntax from ='personal' to 'personal' - this worked by displaying everything in my outlook except for appointments with personal as the category. However, when i then tried to add another category i wanted omitting it went back to displaying everything. Can anyone help? |
#2
|
|||
|
|||
Customise current view
What is the syntax you used in the SQL tab for adding another category?
-- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "JM" wrote in message ... I have a number of categories set up on my outlook. However i don't want the appointments in 3 of these categories to be visible at certain times. The ones i do want visible are those with the default null value in the categories field. i created a filter under view, current view, customise current view, filter, more choices tab, and inserted 1 category that i didn't want visible. i then went into the SQL tab and changed the syntax from ='personal' to 'personal' - this worked by displaying everything in my outlook except for appointments with personal as the category. However, when i then tried to add another category i wanted omitting it went back to displaying everything. Can anyone help? |
#3
|
|||
|
|||
Customise current view
I entered :
("DAV:isfolder" = false AND "DAV:ishidden" = false) AND ("urn:schemas-microsoft-comfficeffice#Keywords" 'Personal') which works for 1 catergory, however for more than 1 I entered: ("DAV:isfolder" = false AND "DAV:ishidden" = false) AND (("urn:schemas-microsoft-comfficeffice#Keywords" 'Personal' OR "urn:schemas-microsoft- comfficeffice#Keywords" 'Birthdays')) which is where it didn't work. -----Original Message----- What is the syntax you used in the SQL tab for adding another category? -- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "JM" wrote in message ... I have a number of categories set up on my outlook. However i don't want the appointments in 3 of these categories to be visible at certain times. The ones i do want visible are those with the default null value in the categories field. i created a filter under view, current view, customise current view, filter, more choices tab, and inserted 1 category that i didn't want visible. i then went into the SQL tab and changed the syntax from ='personal' to 'personal' - this worked by displaying everything in my outlook except for appointments with personal as the category. However, when i then tried to add another category i wanted omitting it went back to displaying everything. Can anyone help? . |
#4
|
|||
|
|||
Customise current view
Try changing that last OR to AND.
-- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx wrote in message ... I entered : ("DAV:isfolder" = false AND "DAV:ishidden" = false) AND ("urn:schemas-microsoft-comfficeffice#Keywords" 'Personal') which works for 1 catergory, however for more than 1 I entered: ("DAV:isfolder" = false AND "DAV:ishidden" = false) AND (("urn:schemas-microsoft-comfficeffice#Keywords" 'Personal' OR "urn:schemas-microsoft- comfficeffice#Keywords" 'Birthdays')) which is where it didn't work. "JM" wrote in message ... I have a number of categories set up on my outlook. However i don't want the appointments in 3 of these categories to be visible at certain times. The ones i do want visible are those with the default null value in the categories field. i created a filter under view, current view, customise current view, filter, more choices tab, and inserted 1 category that i didn't want visible. i then went into the SQL tab and changed the syntax from ='personal' to 'personal' - this worked by displaying everything in my outlook except for appointments with personal as the category. However, when i then tried to add another category i wanted omitting it went back to displaying everything. Can anyone help? . |
#5
|
|||
|
|||
Thanks for that i think its worked, HOWEVER, i now can't
see all my business entries which have a default category of NULL, i am sure this was working until today !! JM -----Original Message----- Try changing that last OR to AND. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx wrote in message ... I entered : ("DAV:isfolder" = false AND "DAV:ishidden" = false) AND ("urn:schemas-microsoft-comfficeffice#Keywords" 'Personal') which works for 1 catergory, however for more than 1 I entered: ("DAV:isfolder" = false AND "DAV:ishidden" = false) AND (("urn:schemas-microsoft-comfficeffice#Keywords" 'Personal' OR "urn:schemas-microsoft- comfficeffice#Keywords" 'Birthdays')) which is where it didn't work. "JM" wrote in message ... I have a number of categories set up on my outlook. However i don't want the appointments in 3 of these categories to be visible at certain times. The ones i do want visible are those with the default null value in the categories field. i created a filter under view, current view, customise current view, filter, more choices tab, and inserted 1 category that i didn't want visible. i then went into the SQL tab and changed the syntax from ='personal' to 'personal' - this worked by displaying everything in my outlook except for appointments with personal as the category. However, when i then tried to add another category i wanted omitting it went back to displaying everything. Can anyone help? . . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Outlook 2003 View Settings MADNESS | laura | General Discussion | 7 | August 20th, 2004 05:17 PM |
sql view | charles osborne | Using Forms | 1 | May 29th, 2004 05:42 AM |
How can I determine the current view? | Hugo Lengweiler | Setting Up & Running Reports | 3 | May 22nd, 2004 08:29 PM |