Upload a .pdf file to a Sharepoint Document Library using Access vba

Posted by Jim Shaffer on Stack Overflow See other posts from Stack Overflow or by Jim Shaffer
Published on 2010-05-06T13:14:40Z Indexed on 2010/05/06 13:18 UTC
Read the original article Hit count: 182

Filed under:

access-vba

|

sharepoint2007

|

sharepoint-api

Within an Access 2007 application, I'm creating a static report in .pdf format. I want to create it, then export the static report (not the data itself) to a Sharepoint Document Library. The intent is for it to be a public repository, no versioning. Each report will carry a unique name.

I'm a seasoned vba programmer, but using Sharepoint services is new to me. How do I go about doing this? Assume I can identify the file name and location after I've generated it, and I know the Sharepoint library URL, and have permissions. Where do I go from there?

© Stack Overflow or respective owner

Related posts about access-vba

T-SQL Equivalents for Microsoft Access VBA Functions

as seen on Internet.com - Search for 'Internet.com'
If you need to migrate your Access application to SQL Server, don't count on The SQL Server Upsize Wizard in Microsoft Access to automatically convert your VBA functions. If you want to push the complex query processing done by your Access queries to the back end, you'll have to rewrite them in T-SQL. >>> More
Access VBA sub with form as parameter doesn't alter the form

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a Microsoft Access 2003 file with various tables of data. Each table also has a duplicate of it, with the name '[original table name]_working'. Depending on the user's choices in the switchboard, the form the user choose to view must switch its recordsource table to the working table. I… >>> More
Achieve Rails-style migrations in MS Access VBA application

as seen on Stack Overflow - Search for 'Stack Overflow'
This is a simple way to do Rails-style migrations in a VBA application. Just add additional migrations like migration(name, sql_string, database) to run_migratons and call run_migrations somewhere in the beginning of your execution. Function migrate(signature As String, sql As String, dbs As DAO… >>> More
Using INSERT INTO and setting one field value - Access VBA

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I'm using INSERT INTO to copy rows of data from one table to another: INSERT INTO tblNewCustomers (CustomerID, [Last Name], [First Name]) SELECT CustomerID, [Last Name], [First Name] FROM tblOldCustomers How can I set one of the field values in tblNewCustomers for all of the new records that… >>> More
MS-Access VBA: form_error vs on error

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to set up error handling for a MS-Access application. The standard method to do this seems to be with an On Error statement in each subroutine/function. It seems simpler to me to use the Form_Error function to catch all the runtime errors in that form as opposed to an On Error statement… >>> More

Related posts about sharepoint2007

Copy Content from Sharepoint2007 to another Sharepoint2007

as seen on Server Fault - Search for 'Server Fault'
Hi There, I have a Sharepoint 2007 web farm installation with two site collections, one is a blank site and the other is a migrated Sharepoint 2003 site collection. I want to move some specific content from the migrated 2003 collection to the 2007 collection, however I also want to change the path… >>> More
SharePoint Server 2007 Stops Responding to External Requests

as seen on Server Fault - Search for 'Server Fault'
We have a SharePoint2007 server running on a Windows Server 2003 Box. The box itself is quite old but has not experienced any weird issues. Recently SharePoint has begun to show some strange behavior. One of the most annoying things is that once in a while, the sharepoint sever stops responding to… >>> More
Good bug tracking with Sharepoint?

as seen on Super User - Search for 'Super User'
At my place of work, it has been decided to move many processes to Sharepoint. I'm now looking into how Sharepoint can be used for bug tracking (à la Mantis, FogBugz etc. but within Sharepoint). Specifically, we're using a collaboration room and the solution must work inside that. I know that I can… >>> More
Sharepoint 2007: author.dll status code?

as seen on Server Fault - Search for 'Server Fault'
Is there a way to find any info using /_vti_bin/_vti_aut /author.dll status code? <html><head><title>vermeer RPC packet</title></head> <body> <p>method= <p>status= <ul> <li>status=393226 <li>osstatus=0 <li>msg=The form… >>> More
IE Tab 2 vs IE Tab Plus

as seen on Super User - Search for 'Super User'
I'm wonder what the differences are, especially as it pertains to SharePoint. Why should I pick one over the other or does it matter? Also are there any Linux browser solutions for SharePoint, besides Wine + IE 6. >>> More