Useful links for Access Services 2013 in SharePoint 2013

Intro to Access 2013

http://blogs.office.com/b/microsoft-access/archive/2012/07/20/introducing-access-2013-.aspx

SQL and Access 2013

http://blogs.office.com/b/microsoft-access/archive/2012/08/08/access-2013-and-sql-server.aspx

Configuring Access Services 2013 for SharePoint 2013

http://blogs.msdn.com/b/kaevans/archive/2012/08/30/configuring-access-services-2013-on-premises.aspx

Access Blog

http://blogs.office.com/b/microsoft-access/

Three part series. This is part 1.  Gives a good insight to internals of SharePoint.

http://accessexperts.net/blog/2011/06/15/sharepoint-and-access-how-do-they-fit-together/

Improving the Reach and Manageability of Microsoft Access 2010 Database Applications with Microsoft Access Services

http://www.microsoft.com/en-us/download/details.aspx?id=19061

Access 2013 desktop database reference

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

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

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

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

Access 2013 web app demo

http://blogs.office.com/b/microsoft-access/archive/2012/09/14/3-awesome-access-2013-web-apps-you-can-build-right-now.aspx

Moving and backing up your Access 2013 web apps

http://blogs.office.com/b/microsoft-access/archive/2012/09/27/moving-and-backing-up-your-access-2013-web-apps.aspx

Create HTML File Using Access 2013

http://www.c-sharpcorner.com/UploadFile/c25b6d/create-html-file-using-access-20133/

Import Lotus Notes Database into Access/SQL

http://stackoverflow.com/questions/3760598/import-lotus-notes-database-into-access-sql-what-about-documents

Lookup field dropdown position issue

I was trying to create a custom webpart that will display a form to submit data in a list. The list had few lookup fields.

Whenever, I click on that image it displays us with a drop-down containing all the values, but the funniest part is you can select a particular item either by double click or by selecting it once and clicking it else where on the page or by tabbing system of the keyboard. But I want it work like a normal drop-down selection in other words just with a single click and also the control should be closer to other controls from usability perspective.

To fix this issue. you need to set InDesign ="true";

 Ex.BaseFieldControl webControl = field.FieldRenderingControl;

webControl.ID = string.Format("ctrl_{0}_{1}", field.InternalName, pplCount);


webControl.FieldName = field.Title;

webControl.ItemContext = SPContext.GetContext(HttpContext.Current, lstReqData.DefaultView.ID, lstReqData.ID, lstReqData.ParentWeb);

webControl.RenderContext = SPContext.GetContext(HttpContext.Current, lstReqData.DefaultView.ID, lstReqData.ID, lstReqData.ParentWeb);

webControl.ControlMode = SPControlMode.New;

webControl.ListId = lstReqData.ID;

webControl.InDesign = true;

 If you are using form field you can set it by following changes in aspx page

<SharePoint:FormField runat="server" InDesign="true" ID="myFieldId" ControlMode="New" FieldName="myFieldName" />

Use Metadata Navigation in Wiki Pages (Sharepoint 2010)

If you want to use Metadata navigation tree in Wiki Page, you have to do the following:

• Activate Metadata Navigation and Filtering feature on site level

• Navigate to Library settings page of your “Pages” library and select Metadata navigation settings
• From “Configure Navigation Hierarchies” select “Wiki Categories” and click “Add” and “OK”

• Navigate to Pages library again

http://<Your Wiki Site Url>/Pages/Forms/AllItems.aspx

But when you click on any of the pages on the right panel, the navigation tree will disappear.

 

You have to change the master page or better to create and deploy a new one (via Sharepoint Designer or wsp)
You have to include a reference to MetadataNavTree control and put it in some placeholder (QuickLaunchNav) on the master page file.

• Put this markup in the beginning of the page

<%@ Register TagPrefix="wssuc" TagName="MetadataNavTree" src="~/_controltemplates/MetadataNavTree.ascx" %>

• Put this code in <asp:ContentPlaceHolder id="QuickLaunchNav" runat="server"> tag

<asp:ContentPlaceHolder id="QuickLaunchNav" runat="server">
<wssuc:MetadataNavTree id="mdnt" runat="server" />

The result is: