can't output or export my access report to sharepoint destination unc path using vba?

[BmoBeastFoSho]

My code is written in a button on a form. Trying to send the report up to sharepoint by using the following:
docmd.openReport acOutputReport,
"DailyReportPrint", acFormatPDF,
"\\mysharepointsite.net\testingsite\SitePages\ & ".pdf"
End sub

Any help would be greatly appreciated. I've been stuck on this for a few weeks. Sometimes i get the 2501 OutputTo cancelled error. No luck getting files up to my sharepoint destination path.

[lfpm062010]

Not sure if "OpenReport" is the right command.

[BmoBeastFoSho]

Not sure if "OpenReport" is the right command.

Private Sub Command89_Click()


Dim MyPath As String
Dim MyFiLeName As String
MyFilter = ""
MyPath = "\\mysharepointsite.net\testingsite\sitepages\"
MyFiLeName = "ReportNewer.pdf"

DoCmd.OpenReport "DailyReportPrint", acViewPreview
DoCmd.OutputTo acOutputReport, "DailyReportData", acFormatPDF, MyPath & MyFiLeName, False

DoCmd.Close acReport, "DailyReportPrint"
End Sub

[rpeare]

I thought VBA code couldn't be used in sharepoint, just embedded macros and the like.

But why are you trying to preview and export the file then close the file

DoCmd.OpenReport "DailyReportPrint", acViewPreview
DoCmd.OutputTo acOutputReport, "DailyReportData", acFormatPDF, MyPath & MyFiLeName, False
DoCmd.Close acReport, "DailyReportPrint"

This looks like you're opening it in print preview, then exporting it, then closing the file, which, theoretically would give you just the run time of the query on the export to view the report.

DoCmd.OutputTo acOutputReport, "DailyReportData", acFormatPDF, MyPath & MyFiLeName, False

This should be the only line you need