
Interesting problem - random vocabulary self-examination program
Well, I make for myslef special directory in Outlook containing vocabulary.
Every item contains, lets say, English word and its Spanish equivalent....
(I want to be examined regularly by Outlook)
Then I created custom Calendar form, which triggers when Custom property
(now I dont exactly remember which one) is changed - when Reminder Pops,
i.e. every time I click "snooze" then I'm examined one of the words (I have
to complete the Spanish version), then successful or not successful hit is
recorded to the word Item and it is stored back.
So each word "remembers" how hard it is for me.
The problem is / it is very slow:
a) HOW TO get random one (from the most complicated group) without
looping through all the items
b) or, better, how to sort the items collection (the words) according to
the custom field ?? because i want to be examined for the word I make most
mistakes with, or i want to be examined e.g. the word with less of hits
!! CDO neither Outlook object model cannot sort Items, according to the user
defined field, stupid, isn't it ? !!!
c) or, how to loop through all of the words once only, then remember for
example next 10 items...ie.e where to store the 10 items IDs in the
calendar item ? Must I hard code custom fields F1, F2, F3....huh nothing
clear ... or some kind of grid, or persistent field, which will keep the
values saved and can access them quickly ?
Thanks for any idea for improving.
Filip Laburda