[AccessD] Find First in an Array?

I second that motion.  You also have the advantage of keys with a
collection.

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Murphy
Sent: Wednesday, February 18, 2009 3:11 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Find First in an Array?

Try a collection.

Doug 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
at Beach Access Software
Sent: Wednesday, February 18, 2009 2:57 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Find First in an Array?


Dear List:
 
I have an app set up for multiple languages.  The translations are
pulled from a table at the time the form or report is opened by cycling
through the controls (labels and button captions) and getting the
appropriate translation.  To make the thing run faster (there's a
noticeable translation delay), I'm thinking of loading these
translations into an array in memory and fetching the translation from
the array.  However, AFAIK, there's no equivalent to a FindFirst in an
array like there is in a recordset.  So, is there a better way to find
the right translation in the array short of going through the array in
sequence for each item to be translated?
	
	
MTIA for any ideas,
 

Rocky Smolin

Beach Access Software

858-259-4334

www.e-z-mrp.com <http://www.e-z-mrp.com/> 

www.bchacc.com <http://www.bchacc.com/> 

 

 


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

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