Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > BOOK: Professional Access 2013 Programming
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Professional Access 2013 Programming
This is the forum to discuss the Wrox book Professional Access 2013 Programming by Teresa Hennig, Ben Clothier, George Hepworth, Dagi (Doug) Yudovich; ISBN: 978-1-118-53083-2
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional Access 2013 Programming section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old March 31st, 2017, 11:24 AM
Registered User
Points: 5, Level: 1
Points: 5, Level: 1 Points: 5, Level: 1 Points: 5, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2017
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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.
Reply With Quote
  #2 (permalink)  
Old April 2nd, 2017, 02:55 PM
Registered User
Points: 24, Level: 1
Points: 24, Level: 1 Points: 24, Level: 1 Points: 24, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2013
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.

http://https://techcommunity.microso...map/ba-p/57148

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.

HTH

George Hepworth
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Access 2013 web app and Email jbrown08322 BOOK: Professional Access 2013 Programming 5 September 14th, 2014 05:15 PM
Creating Excel file from Access Web App Suzanne Wade BOOK: Professional Access 2013 Programming 1 January 31st, 2014 11:15 PM
Using a list or combo that is filtered MiddleGround Excel VBA 0 June 7th, 2010 12:57 PM
Filtered Sharepoint list, not filtered in infopath wmrdude SharePoint Development 0 July 26th, 2006 06:09 AM
VB.Net + Web App. + Access Database SeemaChivate ADO.NET 6 July 7th, 2005 05:06 AM



All times are GMT -4. The time now is 05:53 AM.


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