RE: [MS_AccessPros] RE: FindFirst method syntax

You can still use the Seek method but your DB object needs to be the back-end database file rather than CurrentDb.

Set db = Opendatabase("YourRemoteAccessFileNameHere")

Duane Hookom MVP
MS Access

----------------------------------------
> From: graham@mandeno.com
>
> Hi Phucon
>
> I'm glad you have got it working :-)
>
> One thing you should be aware of, regarding the Seek method, is that a linked table cannot be opened as a table-type Recordset, and therefore Seek will not work. As your application grows, and especially when you put it into production, you should split it into a back-end containing the data and a front-end containing the code and linked tables. At that point you will need to convert all your Seek methods to FindFirst.
>
> Best wishes,
> Graham
>
>
> From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of saigonf7q5@yahoo.com
>
> Thanks Duane and Graham
>
> I played with the 6 different coding methods that Graham provided. They all worked great!
>
> As a matter of fact, in the production db, I use the SEEK method (it works great) instead of the FIND method since it's table-type recordset. I played with the FIND methods just was because I wanted to learn more and experiment...
>
> Except the date fields, all other fields are text data type. The procedure below is the one that's used in production db.
>
> Thanks Duane
> Phucon

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://info.yahoo.com/legal/us/yahoo/utos/terms/