select file name

[peggypph]

Inside the input form, there is one text field which suppose to store the filename. During field input, I would like to design in such a way that the user can browse the drive, path, folder and click the file name at last rather than manually key in the exact path and file name e.g. c:\stock\abc\example.doc. Are there any examples or functions or ActiveX I can learn? Thanks!

 

[directormac]

Peggy:

The second step when you hit any snag in Access should be checking the forum archives. This question has been answered many times, including in this thread.

--Reminder Mac

 

[peggypph]

select filename (again)

Thank very much!

If I want to select only (.bmp) OR (.jpg) files, would you please advise me how to set in variable "sFilter"

Existing example :
sFilter = "Word Files (*.doc)" & Chr(0) & "*.doc" & Chr(0)

which allow *.doc only

 

[directormac]

Are you using the Ken Getz code? The TestIt() function shows an example of filtering on multiple file type extensions.

--Multiple Mac

 

[peggypph]

f

I am not using Ken Getz code. Last time, I started from the hyperlink "this thread" on your reply and then download the sample.zip file which is the reply thread from WayneRyan.

By the ways, how can I get Ken Getz testIT() function?

 

[directormac]

The Ken Getz code was a little farther down in the thread. I think you'll find it a little more flexible.

--Limber Mac