[AccessD] Find First in an Array?

Rocky Smolin at Beach Access Software rockysmolin at bchacc.com
Thu Feb 19 09:28:10 CST 2009


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?



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




More information about the AccessD mailing list