|
| 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 | Search this Thread | Display Modes |
|
#1
July 21st 07, 05:41 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
SQL filters with MAPITABLE
I'm using Redemption to create a session, then I get the current folder, then I create a oCurrentItem by mapping it to my oCurrentFolder.Items.
I can get oCurrentItem.Count to return 27, the number of items in that folder, but what I want to do is use SQL to find all the items that have the AllDayEvent flag set, and, in another area of my code, find all the appointments that have a Start Some_Date AND Start Some_Other_Date. I declare a oRecordSet object, then map it to the oCurrentItem.MAPITABLE.ExecSQL("Select Subject From !Don't_Know_What_Goes_Here! Where AllDayEvent 1) 1. What goes in the "From" part of the string, and 2. Is the AllDayEvent 1 correct? -- Thanks, Dennis 
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Redemption MAPITable - how to deal with empty fields | SummerSky | Outlook and VBA | 2 | December 20th 06 04:27 PM |
| How do I get a propertyvalue from a mapitable | [email protected] | Outlook and VBA | 1 | October 4th 06 06:51 PM |
| Redemption - MapiTable : BusyStatus | Tadwick | Outlook and VBA | 4 | August 10th 06 06:36 PM |
| Task filters should be linked to calendar filters | fetch98 | Outlook - Calandaring | 0 | January 19th 06 08:06 PM |
| Redemption MAPITable | Dmitry Streblechenko | Add-ins for Outlook | 1 | January 12th 06 04:09 AM |
Threaded Mode