Hi EE Community,
New to the community and still pretty raw in Access. (I do have experience in Java/Android and Python, so I'm not completely clueless to all things!)
I have a standard Access Database saved on SharePoint. My organization uses SharePoint, but I only have standard access to areas particular to my department. (I cannot create or link a web based database to SharePoint with my access level.)
In my Access file, I have a form that saves its data to the table - locally - when I hit the submit button.
The ribbon below appears and if clicked, transfers the whole Access file to the SharePoint storage location, but only if that button is clicked. Otherwise it only saves a local copy.
Is there a way I can automate a network/SharePoint save location in code so the user doesn't have to remember to press that button?
Any SaveAs with a path designation would work. Thanks!