прикрепить файл к записи

Private Sub FndFile_Click()
Me.Файл.SetFocus
Файл.Value = FindFile
End Sub

Option Explicit
Private Type OpenFilename
    lStructSize As Long
    hwndOwner As Long
    hInstance As Long
    lpstrFilter As String
    lpstrCustomFilter As String
    nMaxCustFilter As Long
    nFilterIndex As Long
    lpstrFile As String
    nMaxFile As Long
    lpstrFileTitle As String
    nMaxFileTitle As Long
    lpstrInitialDir As String
    lpstrTitle As String
    flags As Long
    nFileOffset As Integer
    nFileExtension As Integer
    lpstrDefExt As String
    lCustData As Long
    lpfnHook As Long
    lpTemplateName As String
End Type
Public Declare Function GetOpenFileName Lib "comdlg32.dll" Alias "GetOpenFileNameA" (pOpenfilename As OpenFilename) As Long
Public Function FindFile() As String
Dim OFName As OpenFilename
    OFName.lStructSize = Len(OFName)
    OFName.lpstrFilter = "Все файлы (*.*)" + Chr$(0) + "*.*"
    OFName.lpstrFile = Space$(254)
    OFName.nMaxFile = 255
    OFName.lpstrFileTitle = Space$(254)
    OFName.nMaxFileTitle = 255
    OFName.lpstrTitle = "Заголовок диалогового окна"
    OFName.flags = 0
    OFName.nFilterIndex = 0
    If GetOpenFileName(OFName) Then
        FindFile = OFName.lpstrFile
    End If
End Function

Sub getFileName()
    ' Äëÿ âûáîðà èìåíè ôàéëà
    ' èñïîëüçóåòñÿ ñòàíäàðòíîå îêíî îòêðûòèÿ ôàéëà Office.
    Dim fileName As String
    Dim result As Integer
    With Application.FileDialog(msoFileDialogFilePicker)
        .Title = "Âûáîð ôîòîãðàôèè"
        .Filters.Add "Âñå ôàéëû", "*.*"
        .Filters.Add "Ðèñóíêè", "*.bmp"
        .Filters.Add "JPEG", "*.jpg"
        .FilterIndex = 3
        .AllowMultiSelect = False
        .InitialFileName = "c:\"
        result = .Show
        If (result <> 0) Then
            fileName = Trim(.SelectedItems.Item(1))
            MsgBox fileName
        End If
    End With
End Sub