Macro to save to SharePoint 365 site

KEKeogh

Registered User.
Local time
Today, 18:52
Joined
May 4, 2011
Messages
80
Hi all!

I'm circling back to an issue I was trying to get help with but nothing was quite working but since one guy is having trouble remembering the procedure and keeps losing things. I thought I would try again.

I have an Access 2013 database with tables, queries and forms and such on our company's Team Site on SharePoint in Office 365.

Right now when the users click on the link to the database, a copy is downloaded to their "My Documents" folder. Any changes that are made are only on the copy on their machine.

They have to remember to hit the yellow "Save to SharePoint Site" button that appears at the top of the database to get it saved on the SharePoint site.

If they X out of it without hitting that button and then open it from the site again then any changes are lost.

I've tried getting the App on the SharePoint site but that only brings in the tables and my people use forms and queries religiously.

Is there some way that I can code a button to automatically save to that SharePoint location? Or to bring up the File-Save As option?

For now I put a reminder message box up for anytime the database tries to close to hopefully force them to remember to click the yellow button.

Thank you for any help.
Kathie
 

Users who are viewing this thread

Back
Top Bottom