Awards
Join OfficeTipsAndMethods

Have some suggestions to share with the world?

Join OfficeTipsAndMethods and share your insight in a Comment. You must be a member to comment and all comments are moderated before being published. Membership is free and we would never share your personal information with anyone.

Become an OTM Member

Log In

YouTube Video Channel
OfficeFix
Article Categories

Posts Tagged ‘Web App’

Web Enabling your Application

Access 2010 now allows you to easily publish your application to the Web for sharing with other users. This process has been simplified by using Microsoft’s SharePoint Online, part of the Office 365 suite, as no local placement of a SharePoint server is needed. When you share the app with others, all they need is a Web browser to work in your Database Application.

Publishing your Application

One of the common uses of Data Macros is to validate data being entered into a record. The following example will stop the creation of a record in the Asset table if the user is trying to add a warranty value if they have not entered an Aquired Date.

Procedure: Publishing your Application

1. Open the Database Application to be published.

2. Select the Backstage View ribbon tab.

3. Click the Save & Publish option and then Publish to Access Server.

image

4. Enter the full address of your online SharePoint server. Enter the credentials to the SharePoint site, and click the Publish to Access Services button.

image

If successful and Access can publish to the given site, the Web Browser will open and display your published site – distribute the URL to users who need to access the Application via the Web.

This article was written by Nick Williams. Nick is one of the Access course tutors at Acuity Training, a hands-on IT training company with offices in central London & Guildford UK.

Professional Access 2013 Programming–Just Released

imageWritten by a team of MVPs most of whom are also members of UtterAccess.com, Wiley have just released what promises to be an essential and major resource for Access developers.

Judging by many on-line discussions that I have read in the past few months, Access 2013 includes significant enhancements, especially related to Cloud based applications.

Congratulations are definitely in order for the core authoring team, Teresa Hennig, Ben Clothier, George Hepworth, Doug Yudovich, and to the technical editors and contributors, Glen Kruger, Jack Leach, Jerry Dennison, Leo (theDBguy™), Patrick Wood, Peter Doering , Tom van Stiphout, Scott Barker.