p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   BOOK: Professional Access 2013 Programming (http://p2p.wrox.com/forumdisplay.php?f=747)
-   -   Filtered list view in Access Web App (http://p2p.wrox.com/showthread.php?t=99436)

DHJames604 March 31st, 2017 10:24 AM

Filtered list view in Access Web App
I created an MS Access web app on SharePoint online with links to the app pasted on different departments SharePoint page.

I want to display a filtered list based on where the the command is coming from. So if I'm in Dept A SharePoint site and I click on the App URL, it should display items related to Dept A.

GPGeorge April 2nd, 2017 01:55 PM

First, you should be aware that Microsoft has announced the termination of Access Web Apps. If you have an Office 365 account, you will not be able to create new AWAs after June of this year. All existing AWAs will be removed from Office 365 in April of 2018.

You have one year to identify an alternative and to begin migrating your existing AWAs to a different technology.

If you have an on-premises SharePoint site, support will continue for AWAs for approximately 5 years.


That said, for this current situation, you will have to create an internal table of users and departments. When someone logs in, you can use a Data Macro to lookup their username in that table to identify which department they are in. Then, set a localvar to that department and include it as a criteria in all queries that populate views which need to be filtered by department.


George Hepworth

edwards142 April 24th, 2018 06:25 AM

Export the list of linked tables from Access to Excel
Well dear I completely don’t understand what you are trying to ask. So please elaborate your problem.

But up to some extent I think you want to know about how to export the list of linked tables from Access to Excel. So, here I have given you the link of the helpful post.

Export a list of Linked Tables from access to Excel


GPGeorge April 24th, 2018 08:57 AM

To the moderators.

This post about exporting files is spam linking to a site selling Access products.

Moreover, it is irrelevant entirely to the subject of the discussion.

Please remove it.

All times are GMT -4. The time now is 11:33 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.