Đang chuẩn bị liên kết để tải về tài liệu:
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 ra.Hình 12,6 tin nhắn thành côngsau khi tất cả các nhãn đã được in.Chứ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 9.2 Selecting a custom folder for storing documents in a database. FIGURE 9.3 Setting a reference to the Office 12.0 object library. 269 Part II Writing VBA Code to Exchange Data between Office Components The FileDialog object has several useful methods and properties Filters.Add Lets you specify the filter s for displaying files such as fd.Filters.Add 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 9.4 shows the MsoFileDialogView enum with all the options for setting the view for the dialog. FIGURE 9.4 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 9.5. If you don t see the Microsoft Scripting Runtime selection in the References dialog you can get this library by downloading Microsoft Windows Script 5.6 or whatever is the current version plus the Microsoft Windows Script 5.6 Documentation files from the Microsoft Windows Scripting Downloads page at http www.microsoft.com downloads details.aspx familyid 01592C48-207D-4BE1-8A76-1C4099D7BBB9 displaylang en. FIGURE 9.5 Setting a reference to the Scripting Runtime library. The Help file