如何在MS Access中存储指向附件的链接? [英] how do I store the links to an attachment in MS Access?

问题描述

我需要制作一个表，以便用户可以将附件链接添加到一个字段中.有没有一种方法可以允许用户浏览文件夹并在MS Access中创建指向附件的链接?这样可以解决我面临的尺寸问题.

I need to make a table such that the user can add attachment links to one of the fields. Is there a way to allow the user to browse through a folder and create a link to the attachment in MS Access? This will solve the size problem I am facing.

推荐答案

看看Application.FileDialog:

Have a look at Application.FileDialog:

Sub ShowFileDialog()
    Dim dlgOpen As FileDialog
    Set dlgOpen = Application.FileDialog(msoFileDialogOpen)
    With dlgOpen
        .AllowMultiSelect = True
        ''Start in
        .InitialFileName = "Z:\docs\"
        .Show
    End With
End Sub

更多信息: http://msdn. microsoft.com/en-us/library/aa213120(v=office.11​​).aspx

这篇关于如何在MS Access中存储指向附件的链接?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！