Using VBA to store a Access report to a local C: drive that works for different computers

[puforee]

I have an Access Db on a server (a storage server not an application server). There are multiple users using the Db from time to time. In my Db I need to export reports in PDF to their C: drives - to a selected folder. If I code the export to save a file to "C:\Special" folder, as an example, will that work on all their computers, assuming they have a folder named Special? If not, how can I make it happen?

Thanks,

John

 

[dhookom]

You can always make a directory like:

Public Function MakeAFolder(strFolder As String)
    
    On Error GoTo ErrHandler
    MkDir strFolder
    Exit Function
ErrHandler:
    Select Case Err.Number
        Case 75
            'already exists so ignore
        Case Else
            MsgBox "Err: " & Err.Description
    End Select
End Function

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016