Access VBA Tip: Select File or Folder using FileDialog

Update: 2017-06-30

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/

Comments

In Channel

How to Create Relationships with Referential Integrity in Microsoft Access

2018-01-1102:50

add Save As to the Quick Access Toolbar (QAT)

2017-12-3002:27

Synchronize List Box in Microsoft Access using VBA to change SQL

2017-12-0409:58

Subform to show Calculations in Microsoft Access

2017-11-1010:32

Mainform + Subforms for data from mutiple tables with a Microsoft Access User Interface

2017-10-1908:38

How to Create Calendar Reports from Access Queries ... as shareable Web Pages - easy!

2017-07-2808:56

Triangles! and Circles! in a Microsoft Access Query -- Get Previous Record too

2017-07-1111:18

Change Graphs and Charts in Microsoft Access with VBA

2017-07-0719:25

How To Make a Graph with Microsoft Access

2017-07-0107:45

Access VBA Tip: Select File or Folder using FileDialog

2017-06-3007:46

Show Bar Graphs in Access Query using Unicode characters

2017-06-2206:52

Three steps to activate Bot features within SharePoint Framework

2017-03-2515:49

Introduction to Artificial Intelligence for Bot Developers with LUIS

2017-03-1335:22

Getting started with bot development using Microsoft Bot Framework

2016-12-2126:04

#spfx. SharePoint Framework Developer Preview

2016-10-3101:36:57

How to create Tab in Office 365 SharePoint Lists

2016-09-0609:20

Access Kung-Fu

2016-07-2736:19

Migrating Access to SQL Server

2016-07-2032:41

Access Web Apps - Reporting Using Power BI

2016-07-1314:47

Access Web Apps - Connecting to AWA Data

2016-07-0627:16

00:00

Access VBA Tip: Select File or Folder using FileDialog

#box-pro-ellipsis-176242438269862{-webkit-line-clamp:2;}Access VBA Tip: Select File or Folder using FileDialog

Access VBA Tip: Select File or Folder using FileDialog

Adrian Bell (MVP)

Access VBA Tip: Select File or Folder using FileDialog