MS Access VBA References (2 Viewers)

[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!

 

[Pat Hartman]

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

And I thought I was the only one who loved books. I can easily make notes in books. I can mark errors or add additional explanations. Can't do that to web pages. Also, very few web pages actually include publish dates so much of what you find is outdated also. At least with a book, you know its vintage and the software version is is linked to.

 

[arnelgp]

you must have Reference (in VBA) on

Microsoft Offix XX.X Object Library (XX.X being the version you have).

while on VBA, press F2 and search "msofile" (without quote).

 

[KitaYama]

I can easily make notes in books. I can mark errors or add additional explanations. Can't do that to web pages.

Anyone has preferences. Some feel better with books, I feel more comfortable with web pages. because I can copy paste. Of course some books come with DVD or have downloadable codes and sample files.
Not saying you're wrong or try to be argumentative, but taking notes or highlighting parts of a page, adding remarks etc. is easy.

1. Browser extensions. Some very famous are : Web Highlights / Weava / Glasp
   These let you annotate live web pages and often save the annotations even when you revisit the page.
   Web Highlights: Lightweight, supports highlighting and note-taking, syncs across devices.
   Weava: Highlight and organize notes by folder/project.
   Glasp: Social-focused tool that lets you share and browse highlights from others too.
   Highlights persist when you revisit the page.
   Usually exportable to markdown, PDF, or other apps.
   Hypothes.is
   Academic-oriented but excellent for annotating any web page or PDF.
   Annotations can be public or private.
   Collaborative—great for shared research.
   
   Of course there are more, with different options.
   
   
2. Note-Taking Extensions That Link to Webpages
   These don’t change the web page itself but let you take notes and link them to pages.
   I suggest Notion web clipper & Evernote Web Clipper
   
   
3. Full Page Overlay Note Tools
   Note Anywhere is very good for this.
   Adds sticky notes to any web page.
   Notes will stick to the page and reload when you revisit (unless the URL changes).
   Great for personal use.