Search results

  1. U

    Solved How do I open file store in SharePoint from Access using VBA

    I copied the Orderfolder to onedrive for test and it works. After the btnViewOrder visible , when click on it then it will open another form frmPDFview to open the pdf so on the frmPDFView, I place the code on FormOpen, below is the code: Private Sub Form_Open(cancel As Integer) Dim...
  2. U

    Solved How do I open file store in SharePoint from Access using VBA

    @Issac & the DBGuy. I did it, it seems working but the only problem is when I open try to open the PDF, it pop up an security notice "A potential security concern has been identified" . Is anyway I can turn it off and just open the pdf directly? Thanks bunch for both of your great advise!
  3. U

    Solved How do I open file store in SharePoint from Access using VBA

    So I copy the Z drive to the shoarepoint and use the same name then sync it to the file explorer, could I be leave the code as it? Can the "Dir" for the file explorer too? Thanks
  4. U

    Solved How do I open file store in SharePoint from Access using VBA

    What do you mean mapping a drive to the doc library and how? we going to move everything to the cloud instead network drive. I can sync the the whole Order Folder from SharePoint to the file Explorer but how do I called it in my code? I did test my existing code, if I removed the "Dir" then...
  5. U

    Solved How do I open file store in SharePoint from Access using VBA

    Hi, I have a Button named btnViewOrders in a frmOrder that is visible base on if there any document(s) associate with the OrderDate and OrderNo of the record. We used to saved those documents as PDF format in a network drive (Z drive). below is my code that works fine when the documents are...
  6. U

    Hello everyone!

    Thank you!
  7. U

    Hello everyone!

    I'm a new user on Access world. Nice to meet you all!
Back
Top Bottom