X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Listview Form Doesn't Display All Query Items Anymore, Access 2013 Web App    
post Jul 14 2017, 06:24 AM

Posts: 411
Joined: 25-November 14
From: Groningen, Netherlands

Hi folks,
Normally, the listView shows the first so many items and it retrieves more when you scroll down. For some reason in OnPremises SharePoint2016, it stops after an arbitrary amount of records and retrieves some more when you scroll down (but not always). The more simple the underlying query is, the better the ListView form works but the query itself always returns the correct dataset. We can tell by having the query result in a datasheet as well. It we use the filter control from a ListView, each existing record is always found. Even when it's not displayed in the ListView list part. In Ofice365 everything works okay.

Does anyone have similar experiences or perhaps even a solution?
Kind regards, Rob
Go to the top of the page
post Jul 16 2017, 04:40 PM

Posts: 411
Joined: 25-November 14
From: Groningen, Netherlands

It looks as if this is an old problem that has been solved on O365 SharePoint but not on On Premises SharePoint 2016. I found this in a google cache of (a not existing anymore) AWA-uservoice webpage.

Fix serious flaw in Access Web App LIST view
LIST view shows fewer items than actually exist. Below is the response I received back from Microsoft Partner Support who obviously have know idea what is going on so they have passed the buck to this forum.

I have seen this issue across various forums including our community (Post URL https://partnersupport.microsoft.com/en-us/...1-46f4ddec0477). It appears that the issue occurs widely but very sporadically. There should be a flaw in Access Web Apps. Hence I would like to suggest you go to the Access Web Apps uservoice site and report this issue to the Product Group via this channel:


Additionally, you may contact the Office 365 local support to double confirm this issue. It is a free support and you can get the support phone numbers from here.

Thanks for your understanding and patience. Sorry for the inconvenience.

Best Regards,
Jackie Xu
Microsoft Partner Support Community Technical Support Engineer
Microsoft Global Partner Services

• Hi Anonymous san
This is Yoshiki Tojo, from Tokyo, Japan.
I could not determine your issue. We could insert the field to List View from available list.
I have experienced no limitations. Do you have some limitations, on List view?
I think there are very little issues on List view, comparing with Data sheet view.
I'm sure Data sheet view development is difficult for product engineer.
However Jackie is an excellent staff of MS partner network.
If Jackie has recognized this as an issue, it will be true.
Pleas let me know your pointed out issue details, if you have enough time to report.
I'll try it.

Go to the top of the page
post Jul 16 2017, 05:43 PM

Posts: 411
Joined: 25-November 14
From: Groningen, Netherlands

Did some testing because I couldn't understand I didn't encounter this problem in 2012-2015. It doesn't occur if you have the indexing perfectly matched with the query (which of course I did back then :-). Now issues whatsoever with more than 10,000 records

The ListForm is just not overloading the database server if your query isn't indexed properly. I know now again why I loooove Access Web Apps :-).

Attached File(s)
Attached File  Knipsel.PNG ( 11.71K )Number of downloads: 0
Go to the top of the page

Custom Search
RSSSearch   Top   Lo-Fi    20th July 2017 - 09:49 AM