Good Afternoon,
I have a simple database where after a form is completed, the user clicks the submit button and a PDF file is created, then sent to a folder on SharePoint. Everything works perfectly fine when the database is just on my desktop but I need to connect the database to SharePoint. When I link the tables to SharePoint, I no longer can click that submit button to have a PDF file created. It gives me an error message that says "The OutputTo action was cancelled", but doesn't provide any additional information regarding what the underlying cause is.
Any thoughts as to why this would happen?
I know it doesn't have anything to do with the file path of the folder because it works on my desktop when not connected to SharePoint just fine.
The code is below:
Private Sub SubmitButton_Click()
Dim NameOfFile As String
NameOfFile = "\\sharepoint.com@SSL\DavWWWRoot\sites\Reviews\" & Me![Processor Name] & "\" & Me![Processor Name] & "_" & Me![ID] & ".pdf"
Debug.Print NameOfFile
DoCmd.OutputTo acOutputForm, "Review Form", acFormatPDF, NameOfFile, False, , , acExportQualityScreen
End Sub
Thank you.
Cory