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

Hi Gustav,
Pub is now dry.. came home...ha!
Well, if you are sending an MDE you would run the Translation Program then
convert to an .MDE and then send it to client and then go back to pub - eh?
Max


-----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