Help with browse

[Guest]

I have a form which needs a file name input into one of the fields. instead
of typing the full path to the file i would like to browse the file system
like windows does. then when i select a file from the browse function it
would be put into my field. i am new at access and VB so i have no idea if
and how to do this.

 

[PC Datasheet]

Go to www.mvps.org/access and go to the API section. Look at the first two
examples.

 

[StopThisAdvertising]

PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1100 users have come to me from the newsgroups requesting help
(e-mail address removed)

--
To Steve:
Over 370 users from the newsgroups have visited the website to read what kind of a 'resource' you are...

To the original poster:

Most people here have a common belief that the newsgroups are for *free exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell his services.

Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html

Arno R

 

[Douglas J. Steele]

http://www.mvps.org/access/api/api0001.htm at "The Access Web" shows the
best approach.

Don't be intimidated by the amount of code there. It's not important that
you understand what it all means. Simply copy all of the lines between Code
Start and Code End into a new module, and make sure you don't name the
module the same as any of the routines within it.

The 4 lines of code at the very top of the page shows what you need to put
into your program to use the dialog to find Excel files. There are also a
couple of functions (TestIt and GetOpenFile) included in what you
copied-and-pasted that give other examples of how to use the code. TestIt
browses for Access files (only MDAs or MDBs), dBase files, Text files, or
any file, regardless of the extension, while GetOpenFile browses only for
Access files (again, only MDAs or MDBs)