Navigate Up
Sign In
Supporters of Developer
Web

SharePoint How To: Write Access 2013 Custom Web App on Office 365

Item is currently unrated. Press SHIFT+ENTER to rate this item.1 star selected. Press SHIFT+ENTER to submit. Press TAB to increase rating. Press SHIFT+ESCAPE to leave rating submit mode.2 stars selected. Press SHIFT+ENTER to submit. Press TAB to increase rating. Press SHIFT+TAB to decrease rating. Press SHIFT+ESCAPE to leave rating submit mode.3 stars selected. Press SHIFT+ENTER to submit. Press TAB to increase rating. Press SHIFT+TAB to decrease rating. Press SHIFT+ESCAPE to leave rating submit mode.4 stars selected. Press SHIFT+ENTER to submit. Press TAB to increase rating. Press SHIFT+TAB to decrease rating. Press SHIFT+ESCAPE to leave rating submit mode.5 stars selected. Press SHIFT+ENTER to submit. Press SHIFT+TAB to decrease rating. Press SHIFT+ESCAPE to leave rating submit mode.

You may also be interested in: Find and Move Files from anywhere to SharePoint with Skybrary

 

Editor's note: Contributor Veena Sarda is a SharePoint Consultant at Tata Consultancy Services. Follow her @writerpurple

Step 1: Sign into Office 365 enterprise and get a free version of Office as well as SharePoint. I installed Access 2013 on my local machine and used SharePoint from Office 365 enterprise version. Create a team site on the cloud environment and use that URL in the Web Location text box.

2013-01-11-CustomWebApp-01.png

Step 2: Choose an existing template. In order to understand more details on how tables and forms are created. I have chosen the Project Management template. Then you can click on Add table. I have created a table called Estimation as shown below.

2013-01-11-CustomWebApp-02.png

The Data Types available are very restricted as shown below

2013-01-11-CustomWebApp-03.png

Also I did not find any option to change the Primary Keys. When you save the table you will see two forms automatically created for you. In my case Estimation Datasheet and Estimation List. Make sure your Navigations Pane is “On”.

2013-01-11-CustomWebApp-04.png

You will also notice that in the Projects List Form, a tab for Estimation is added automatically.

2013-01-11-CustomWebApp-05.png

Step 3: Open the Estimation List Form. We need to add code in this form. In my case I needed to add custom logic to fill in the Per Day Effort and Calculate the Item Effort. Chose the Component Drop Down. In the Actions button you will see the allowed actions for that control. The list is control specific. Click on After Update in this case.

2013-01-11-CustomWebApp-06.png

Step 4: Write your custom logic. When you click on the “After Update”, as in this case, the Macro Tools opens as below. It is painful to use this editor but currently there is no other choice.

2013-01-11-CustomWebApp-07.png

Similarly write code on other controls as required. You can use Expression builder in the case of calculated fields as shown below.

2013-01-11-CustomWebApp-08.png

Step 5: For the summation of items, you need to go to the Project List Form and click on the Estimation Tab as shown below. This will add a total effort at the form below.

2013-01-11-CustomWebApp-09.png

Step 6: Time to launch your app. Click on the “Launch App” button. If all goes well you will see a screen like below.

2013-01-11-CustomWebApp-10.png

Step 7: Once you add the Project and Estimation details you will see the following screen with an additional summation field as below.

2013-01-11-CustomWebApp-11.png

Hopefully with more examples and help material on Microsoft this journey becomes enjoyable.

References: http://msdn.microsoft.com/en-us/library/office/jj250134(v=office.15)

Categories: Office 365; dev

Comments

china wholesale

china wholesale

Posted 01-Jul-2013 by china wholesale
hyundai t7

hyundai t7 mid tablet

Free shipping android tablet pc and smartphone with high quality and cheap price. - http://www.trustedbuyonline.com

Posted 17-Jul-2013 by hyundai t7
LiFePO4 battery

Battery Pack Manufacturer

China leading manufacturer of high quality LiFePO4 battery,lithium battery,li-polymer battery,NIMH battery,NiCd battery, custom battery packs, battery chargers and OEM/ODM reliable power solutions.

<a href="http://www.ejbattery.com"> LiFePO4 battery</a>

Posted 08-Aug-2013 by LiFePO4 battery
Candly019

Thank you for sharing!

Thank you for sharing. Your post worth of reading. Waiting for new posts. buyincoins

Posted 29-Oct-2013 by Candly019
xcxbcxb

xvcc

Real independence is only discovered in selflessness, and in the situation of abortion, the mom is not totally able to be non selfish, and the child is not totally able to even stay according to its objective. Expecting that this may be a God-fearing individual who flows this opinion, I beg you--give wonder to your Dad in Paradise and convert from the viewpoint of loss of life. Paradise does not assess us Jesus basically wants us basically walking away! God thank you. cod pro guide to ghosts

Posted 23-Nov-2013 by xcxbcxb
jenny

jeneffer

Great article its very striking. You have beautifully presented your thought in this blog post. I found so many interesting things in this blog, excellent work. nice post and blog layout and guys here it is Trading Directory for Computer Software, Hardware and Peripherals Manufacturers, Gifts & Crafts Exporters, Consumer Electronic Goods & AppliancesRetailers, Telecommunications Distributors and Sports & Entertainment equipments ...… thankx

Posted 26-Nov-2013 by jenny
cxvbxcvb

vcxvxc

Following a fast examination, she went into strong surprise with no noticeable blood vessels stress levels. vancouver furnished apartments

Posted 01-Dec-2013 by cxvbxcvb

Notify me of comments to this article

E-mail:
   

Add Comment

Title:

 
Comment:
Email:

   


Name:

 
Url: