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

I beg your pardon. I never promised you a Rose Garden.  Along with the Sun
has to come a little rain sometime.

Eh?

Max
Ps With apologies to  Country Music lovers everywhere..
Hic!

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

Hi Max and Rocky

OK, that minor reason turned into a major; you will perform design changes
of the forms which isn't possible in an mde.

/gustav

>>> Gustav at cactus.dk 21-02-2009 16:10 >>>
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