MS Access VBA References

[jamesave]

So, I have been looking at sample codes regarding file picker. There is plenty of mention of FileDialog with msoFileDialogFilePicker.

How do one look at the details of the library? Using google, it show this particular page:

it's a link to learn.microsoft page (I can't post the link, but it does end in office.msofiledialogtype page

But it doesn't contain any link of what are the related function with this. For example, the sample codes does mention of .SelectedItems(1), but I'd like to know more what are the other options. How to find out what are the other options available in this msoFileDialogFilePicker?

 

[cheekybuddha]

Add a reference to the: Microsoft Office XX.0 Object Library

(the XX.0 will vary according to the version of Office installed on your machine)

This will allow you to get the intellisense in the VBA editor and browse all the properties/methods in the Object Browser (F2).

However, eventually, it's better to late-bind this object to avoid Office versioning issues.

The following seems like a pretty decent reference:

Application.FileDialog
Open
SaveAs
FilePicker
FolderPicker
Using Filters

 

[DickyP]

What this thread highlights is the downside of everything online. I've still got my Reilly 'In a Nutshell' books for VBA, VBScript, Access, Excel, Word and Office. These have all the things I ever need to look up. Can look at multiple detailed references as I code!

In fact, unless you have multiple screens online references are a pain full stop!