Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

File Selecter

Status
Not open for further replies.
DMHCCI

DMHCCI

Vendor
May 9, 2003
22
US
Was looking for a built in function or coding that would allow pressing a button to browse for a file on local or mapped drives and store the selected full path name in a control on a form.
 
Sort by date Sort by votes
Depending of the version of your msoffice you may consider the Application.FileDialog object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Upvote 0 Downvote
On pre-XP versions of Access you can use the Active-X CommonDialog found in the system directory, filename: comdlg32.ocx

There are also many examples around the Web showing how to use the API to do the same thing, although it's much easier to use the Active-X controls which can be dropped onto a form and have their properties set using a designer.

VBSlammer
redinvader3walking.gif

"You just have to know which screws to turn." - Professor Bob
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

renigar
  • Locked
  • Question
Code to write file path to field always writes to 1st record 1
Replies
5
Views
267
dhookom
dhookom
Moss100
  • Locked
  • Question
Access prompts "open or save" when I preview an excel file 1
Replies
1
Views
118
combo
combo
rdpress
  • Locked
  • Question
Question Open Shellling to File Explorer
Replies
3
Views
115
Andrzejek
Andrzejek
Aurillius
  • Locked
  • Question
Help with Unzipping a file and saving to a folder in Excel VBA
Replies
1
Views
230
Aurillius
Aurillius
AS Mughal
  • Locked
  • Question
Select Multiple Images and store their file path and image name in text fields of ms access table 1
Replies
7
Views
226
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top