Access VBA Tip: Select File or Folder using FileDialog

Sign in to queue

Description

Do you ever wonder how to prompt for a file or folder from within an Access database?
I'm going to show you how to select a file or folder using the FileDialog object that comes with Microsoft Office. This is available from Microsoft Access of course.  I also have some VBA code here you can download to help you do this.

~~ Links ~~

Select a File or Folder using the FileDialog Object
http://bytes.com/topic/access/insights/916710-select-file-folder-using-filedialog-object

Download: FileDialog.Zip
http://bytes.com/attachments/attachment/5382d1314897792/filedialog.zip

Bytes free forum to get Access help
http://Bytes.com/

Access and Excel Consulting
http://www.AccessConsultantUK.co.uk/

Adrian, AKA NeoPa
http://Bytes.com/profile/51203/NeoPa/

Tags:

Access, Office, VBA, File

Embed

Download

Download this episode

The Discussion

  • User profile image
    strive4peace

    Great video, Adrian. Lots of applications (Access, Word, Excel, or PowerPoint) need to select files and folders. You explain things thoroughly -- from referencing the Microsoft Office Object Library to specifying information for the the file and folder dialog box and using the return value in VBA ... and also setting Breakpoints and tracing through the code.  

    Thank you, this tutorial will be a good link to pass on ~

     

  • User profile image
    AdrianBell​MVP

    Thanks Crystal.

     

    Your help and involvement with the presenting of the information was invaluable :)

     

    -Ade.

  • User profile image
    strive4peace

    @AdrianBellMVP: you're welcome and thanks, Ade -- it was fun, and I learned a few things too!

Add Your 2 Cents