[AccessD] Find First in an Array?

Hi Rocky

The table. Create an index with the two fields.

/gustav

>>> rockysmolin at bchacc.com 19-02-2009 16:28 >>>
Gustav:

Compound in the table?  Or just the code?
 


Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com 
www.bchacc.com 
 
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Thursday, February 19, 2009 7:20 AM
To: accessd at databaseadvisors.com 
Subject: Re: [AccessD] Find First in an Array?

Hi Rocky

You will need a compound index on those two fields. 
The two fields would be FormName and ControlName.
Then:

strFormName = "frmSomeForm"
strControlName = "ctlSomeControl"

       .Index = "FormName_ControlName"
       .Seek "=", strFormName, strControlName

/gustav


>>> rockysmolin at bchacc.com 19-02-2009 15:38 >>>
Shamil!  I forgot all about Seek.  This is one of those rare occasions where
I'm working with a non-linked table. But this table is in the front end -
local to the  user - so each user can have their own language. 

I would have to seek on two fields however - the form name and the control
name.  Should I make a concatenated field, then?