>>>This is really more of an Access question than FoxPro but I know most of you have at least had some occasion to use Access.
>>>
>>>I am trying to implement something very simple, in Access, that would act like the FoxPro LOCATE() command. That is to say, pop up the file locator dialog window so the user can select a file name from anywhere they are mapped to and return it to a text box on the active form.
>>>
>>>I can't believe something like that isn't in the Access functions. Where am I missing it?
>>>
>>>TIA!
>>>Tom.
>>Tom,
>>I don't use Access but I think FileSearch object that's in other Office products (word, excel) should be available in Access too.
>>Cetin
>Hi Cetin,
>
>Yes, I saw that and it will return file names and I can create a list box so the user can choose one or more, but it really seems like a long way around to do something that is so simple in FoxPro, Powerbuilder, and other languages.
>
>Thanks!
>Tom.
You can also use the common dialog control. There is an alternative method that uses API calls that you can download code for at The Access Web