Hi All,
I'm sure i'm not the first to have this problem, although I have searched the forum and cant find anything similar so hoping someone can help out.
I'm not a whizz on Access and I set up a database, with some help a few years ago. This database has worked seamlessly for the past 2 years, however to keep up with the times my company is having to move to an online system, which is dropbox.
My current database produces reports which currently save to a folder on our server. the filepath is always the same, no matter who opens the database on any computer. (I hope you're still following me!...) the VB Script we use is below...
Private Sub Command125_Click()
Dim FileName As String
Dim FilePath As String
FileName = "Plot " & Me.Customer_Plot_No & " " & Me.Development & " Remedial works report"
FilePath = "\\bellserver\network shares\Customer Care\Remedial Reports" & FileName & ".pdf"
DoCmd.OutputTo acOutputReport, "Report1", acFormatPDF, FilePath
MsgBox "Report Saved Successfully", vbInformation, "save confirmed"
End Sub
As you can see from the above the filepath saves directly to our server.
Is it possible to save directly to our new dropbox folder? - When I change the filepath to "https://www.dropbox.com/work/Bell%20Team%20Folder/bell%20electrical/CUSTOMER%20CARE/Remedial%20Reports/Work Sheets/" & FileName & ".pdf"
I get an error and I believe this to be because it cant save to that filepath! (which I expected!)
The issue I have is that several different people in my company use this database on several different computers, generally at different times so I cant just change the filepath to the dropbox folder that's located on any one computer as it wouldn't save if someone opened on a different computer.
My question would be, is it possible to save directly to an online folder?
Or, would someone be able to write the script for me so that rather than just clicking the button and it saves, it would then open a dialogue box where the user could choose to save the file.
Your help would be appreciated!
Thanks