Browse for a file

[Sam]

Hello

Can I give the ability to my user to browse for a file
from his drive C and to choose a file by clicking on a
bottom


Thanks

 

[Cheryl Fischer]

Yes, you can. There is code to do that at:

http://www.mvps.org/access/api/api0001.htm

hth,

 

[SAM]

Hi Cherryl,

Thanks for your help, I've got the code, but it's give me
a error for the keyword (Left) do I have to add any
references, I have the error waiting for array, I'm using
Access XP

Thanks

 

[Cheryl Fischer]

Sam,

One of the most common reasons for a failure on a common built-in function -
like Left() - is that there is a missing reference.

First of all, open any code module and then click Tools|References. I am
guessing that you do not have a reference set to Microsoft DAO 3.6 Object
Library which is not automatically set as a default for new databases. If
you do not have such a reference set, scroll through the list of references
and click in the checkbox to the left of that reference. If you do already
have a reference set to Microsoft DAO 3.6 Object Library, check your
references for any which may be marked MISSING.

Post back if we need to look into this further!