[AccessD] Find First in an Array? - The Solution

ha!  who said I was sleeping?

Dream Programming is what I do....Wake up with the answer most of the time
(well "a" answer if not "the" answer)

Max


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: 21 February 2009 15:11
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Find First in an Array? - The Solution

Hi Max

Very good! You have point here. 
It's a bit like Drew's suggestion but with a clever twist which I will leave
for others to figure out (I have seen the sample db from Max).

I can, however, think of one minor reason to not use your approach.

Who said you don't get bright ideas while sleeping?

/gustav

>>> max.wanadoo at gmail.com 21-02-2009 13:47 >>>
Hello Rocky,
Well, I have read with interest all the to-ing and fro-ing from the various
contributors.
So, I laid me down laterally and started thinking laterally.
The solution came to be sometime around my 3rd drink.
I consolidated my thoughts in bed.
When I woke this morning, I tested them out with a sample mdb using English,
French and German.  All work beautifully.  Add as many languages as you
want.

The solution I have has the following benefits:

Instantaneous
No variables
No Collections
No Classes (although the solution could be said to be upper class <ha!>
No Arrays
No Memory overheads
Forms shown the language required every time with no overheads.
Unlimited Languages

Should I post the sample mdb to you?

Max
Ps. Bet your intrigued - you will love this solution.



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com