tailieunhanh - access 2007 vba bible phần 5

Hình 12,6 cho thấy "Hoàn tất" tin nhắn sau khi tất cả các bộ của các nhãn đã được tạo 12,6 tin nhắn thành côngsau khi tất cả các nhãn đã được năng Get DocumentsPath để lấy đường dẫn tài liệu từ tblInfo được liệt kê bên cạnh chức năng GetTemplatesPath tương tự như: | Working with Files and Folders 9 FIGURE Selecting a custom folder for storing documents in a database. FIGURE Setting a reference to the Office object library. 269 Part II Writing VBA Code to Exchange Data between Office Components The FileDialog object has several useful methods and properties Lets you specify the filter s for displaying files such as Word documents .doc InitialFileName The default file name for a File Picker dialog the default path for a Folder Picker dialog ButtonName The button caption in case you want something other than Select . DialogType A selection of File Picker Folder Picker Open or Save As dialog type from the MsoFileDialogType enum which can be viewed in the Object Browser . InitialVi ew Lets you set the view for the dialog Details Large Icons Preview and so on . Look at the MsoFileDialogView enum in the Object Browser for the full selection. AllowMultiSelect If set to True lets users select multiple files in the dialog for File Picker dialogs only . Figure shows the MsoFileDialogView enum with all the options for setting the view for the dialog. FIGURE Viewing the MsoFileDialogView enum in the Object Browser. 270 Working with Files and Folders 9 The FileSystemObject The FileSystemObject library provides another way to work with Windows folders and files . To use the components of the object library in a database you need to set a reference in this case to the Scripting Runtime library as shown in Figure . If you don t see the Microsoft Scripting Runtime selection in the References dialog you can get this library by downloading Microsoft Windows Script or whatever is the current version plus the Microsoft Windows Script Documentation files from the Microsoft Windows Scripting Downloads page at http downloads familyid 01592C48-207D-4BE1-8A76-1C4099D7BBB9 displaylang en. FIGURE Setting a reference to the Scripting Runtime library. The Help file