Brian-
You need to write code behind a command button that either calls the Windows
Open File dialog directly or uses the Office File System Object. You can find
sample code to call the Windows Open File dialog here:
http://access.mvps.org/access/api/api0001.htm
If you call it correctly, it'll return the file and path selected by the user,
and you can use that to update your field.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of briandri
Sent: Friday, May 20, 2011 5:34 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] VBA: select file name from explore and drop file name
into field
In a form by clicking on a button linked to a field (called FileNameField)I want
to open Windows Explorer, go to a folder and select a file. Clicking on the file
should result in copying path and file name into a filenamefield on the form.
HOw do I do this in VBA
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar