Posted on 2002-05-01
I am currently trying to put together a small access program that will untangle an anagram.
I already have imported a LARGE dictionary file with over 1 million entries. It is very simplistic with a single entry on each line.
I know there are probably loads of ways to do this but I finally decided on using filters on a form. First to exclude all entries that are not of the relevant length.
me.filter = "len(dict) = len(field1)"
I then thought that for each letter of the anagram I would add another filter layer that would exclude all those entries without the relevant letters. I got a certain way but couldn't cope with problem of repeat letters. Sysntax was also a problem due to there being only one filter command.
So my questions are.
Is there a way to apply to filters to the same set of data on a form.
Am I going about this the wrong way?
If not then can someone suggest how I might overcome the problem of duplicate letters?
Any other comments/suggestions are encouraged.
Points will be awarded to anyone with any in depth thoughts.