Solved

Access 2010/ sharepoint help..

Posted on 2011-09-05
10
232 Views
Last Modified: 2012-05-12
I working on adding a filter to a exsisting report in Access 2010 in a Sharepoint enviornment.  Whats the best way to go about adding this feature, since im under the impression sharepoint does not support code modifications.
0
Comment
Question by:IT_newbie01
  • 5
  • 3
10 Comments
 
LVL 18

Accepted Solution

by:
Richard Daneke earned 500 total points
Comment Utility
If you are trying to apply a filter to present the filtered data, Access can work with a Sharepoint list as a linked table (like it can with Excel, SQL, or other lists).   Here you can filter the data and export the list back to Sharepoint site.

or  any user can run the Access program to filter and work the data in a small Access program

or you can use Access 2010 to create a web-based Access environment to filter without having Access installed on each users' workstation.
0
 

Author Comment

by:IT_newbie01
Comment Utility

or you can use Access 2010 to create a web-based Access environment to filter without having Access installed on each users' workstation.

This is exactly the option i want to employ.  Do you have an example of how to do this??
0
 
LVL 18

Expert Comment

by:Richard Daneke
Comment Utility
You can create a web database from a template.
Here is an MS link:
http://office2010.microsoft.com/en-us/access-help/publishing-to-access-services-HA101862691.aspx

How well do you know your sharepoint environment?  Access  Web services have been available in the Sharepoint environment in 3.0, 2007 and 2010.   Which Sharepoint environment are you using?  Office365 Sharepoint includes the Access Web services.
0
 

Author Comment

by:IT_newbie01
Comment Utility


I'm using Access 2010 (from what i read Office 365 is just another name for this suite) and i know very little about the sharepoint enviornment.  I'm familiar with Access 03 but see 2010 has changed considerably!  Not to sound like a noob but i was looking for picture and heavy descriptive documentation.  
0
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 
LVL 45

Expert Comment

by:aikimark
Comment Utility
Access2010 and Office365 are two different animals
0
 

Author Comment

by:IT_newbie01
Comment Utility
Maybe this should be a new question: What's the best to publishing an Access report to the web that's filterable (drop-down list)??? I'm reading alot that suggest a lookup table.  Is creating a drop-down list even possible when dealing with Access  Web services???

THANKS IN ADVANCE!!!
0
 

Author Comment

by:IT_newbie01
Comment Utility
Ok, apologies i misread.  I'm using sharepoint 365.  
0
 
LVL 18

Expert Comment

by:Richard Daneke
Comment Utility
You should open a web template in Access 2010 and see if you can publish the sample database to your SharePoint site.  If you have Office365, the sharepoint includes Access Web services.

Since you have Office2010, another option is to save your list as an Excel table with autofilters.   This would permit your users to filter as necessary.  
0
 

Author Comment

by:IT_newbie01
Comment Utility

Ok, I actually only have Access 2010.  Are you suggesting not attempting to use Access/ Access Web services to create a filterable table????  But suggest using Excel table with auto-filters?? If so why?? What would be the disadvantages/ advantage??
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now