Microsoft SharePoint

37K

Solutions

19K

Contributors

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.

Share tech news, updates, or what's on your mind.

Sign up to Post

I need to link to a SharePoint list from within Access and only retrieve the records for a particular view of the list.
It is not practical to pull down the entire list and then filter/SQL search within Access.
I want Access to only see the records in a particular view and only those columns in that view.

This is all working using Excel with a linked table and refresh all to update it from SharePoint I'd like to avoid the users
having to open a workbook at all  - just open access and the data is there (perhaps asking them if they want to refresh the data from SP)

I know to how directly link to a SharePoint list from Access - but that tries to bring down all records and all fields
(over 2000 records and 240 fields)  - not practical for end users.

I'm experienced in VBA, SharePoint, .. etc so a VBA solution is fine.
Environment:
Excel/Access 2016, SharePoint 2016, full control on the site w tons of workflows, JS, etc..
No infopath, No Access web apps, must work in FF and IE

so to summarize -
How to establish a link to a particular view of a SP list in access  - including refreshing etc
Specific examples, VBA code, ... sought
thanks
0
Amazon Web Services
LVL 12
Amazon Web Services

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

Hello All,
I have been searching for awhile for a SharePoint 2016 app that will convert Docx file to PDF. I have seem some scripts out there for converting using JavaScript, but none work. I have also seen some apps that will do the conversion but cost $1000s of dollars that I can't afford. I believe I can use Word automation services but I am out of my league when programing.

What I need is a way to bulk create PDF files from Word Document in a SharePoint 2016 document library. I hope to use a button to trigger the event.

Thank you,
Abe
0
Hi all, i have a customer migrating on sharepoint online.
He choose sharepoint online cause he hasn't enough resources on local ict site, and has a good promo about office 365 licenses.
My question is simple, sharepoint online has a network security module available?
i know is a strange requst (talking about cloud resources) but my customer has 10 different branch office, and we want to make available sharepoint online only for public ip of these 10 offices.
can i configure sharepoint online to accept connection only by 10 public ip (for local office) and by devices with a personal certificate (for mobile devices?)
really thanks
sorry for my english, ask me please for details
Mattia
0
Hi all,
I would like to know more about the SharePoint Cloud Hybrid Search Configuration. I am trying to configure cloud hybrid search between SharePoint 2016 On-Premises and SharePoint Online. There seems to be bit of confusion for me as I see that Azure Subscription is needed and looks for the Azure ID needs service admin privileges.  Can someone point me to more comprehensive article or steps to achieve this (other than MSDN or TechNet articles please). Thank you in advance.

Regards,
Kumar
0
Have to find a search engine for our intranet.  
We have  .NET and a small SharePoint server (2016 on premise) .  It maybe moving to the cloud next year.

Any key things I should look for?
Have no idea how long it takes to set something like this up or maintain.
Asked if there was a $$ limit.  They said no.

Any ideas or thoughts appreciated.  

JS
0
H we have i sharepoint appp - and a need to retire a DNS server. We have an entry in DNS we cant point to a new DC DNS server and we want to retire old dns server

Ok After digging a bit deeper into sharepoint we have found that its a custom app - please read:

https://docs.microsoft.com/en-us/SharePoint/administration/configure-an-environment-for-apps-for-sharepoint

Now the issue is in our zone apps.intranet.domain.com.au there is no wildcard CNAME entry - there are no entries at all other that the pointer to the name server.

so is it a matter of just deleting the zone - recreating on the new DNS Domain controller - and creating a CNAME wildcard - not sure how these sharepoint apps work - can a SharePoint person help?  thanks
0
I am trying to force a Edit Form Attachment link in SharePoint Online to open in a new tab/window. I have tried a number of solutions but none of them see to override the onclick attribute that is associated with that link,

Any suggestions to force a new window to open from my custom EditForm?

My most recent attempt was to try and wipe out any references to onclicks or mousedowns in this table:

<script type="text/javascript">
$("a").prop("onclick", null).off("click");
$("a").prop("mousedown", null)
$("a").attr("target","_blank");
</script>

Open in new window


This code didn't see to do anything meaningful. Maybe there is an easier way? Hide this link and create a new one dynamically using the href value from the SharePoint link?
 
<table border="0" cellpadding="0" cellspacing="0" id="idAttachmentsTable">
			<tbody><tr id="{96639D2F-BE46-4CE2-8C00-D35B1AC2384C}"><td class="ms-vb"><span dir="ltr"><a tabindex="1" onmousedown="return VerifyHref(this, event, '1', 'SharePoint.OpenDocuments.3', '1https://xxx.sharepoint.com/teams/lms_help/portaldev/_layouts/15/Doc.aspx?sourcedoc=/teams/lms_help/portaldev/Lists/Requests/Attachments/140/Italy_MAPS_2015.xlsx&amp;action=default&amp;mobileredirect=true');return false;" onclick="DispDocItemExWithServerRedirect(this, event, 'FALSE', 'FALSE', 'FALSE', 'SharePoint.OpenDocuments.3', '1', 

Open in new window

0
I'm looking for a detailed project plan to migrate from a hybrid SharePoint environment (SharePoint 2010 and SharePoint Online) to Office 365 SharePoint.  Anyone have a project plan sample or template for this type of migration?
0
Hi EE,

We are doing an in-place upgrade of a SharePoint 2010 SQL instance and we want to do some database integrity analysis post upgrade.

Since we have limited number of people to look check the database integrity post upgrade what would be the most important databases to review?

Any assistance is appreciated.

Thank you
0
Hello Everyone,

Got a quick question as we are planning to raise install DC 2016 and raise (once all DC 2008R2 gone) FFL/DFL to 2016.  
Which FFL/DFL does SharePoint 2013 support, i.e. can I raise the FFL/DFL from 2008R2 to 2016 without making a change to the existing SharePoint 2013 --> 15.0.4841.1000 server (2012R2)?
For example, we have Exchange 2013 CU14 Build 15.00.1236.003 and the only requirement to run under 2016 AD is SP1 which was released in version CU4 Build 15.00.0847.032 so based on this matrix (https://technet.microsoft.com/en-us/library/ff728623(v=exchg.150).aspx) we don't have to worry about updating Exchange (just for this reason) right now.
I am trying to find a similar matrix for SharePoint 2013.
Configuration database version: 15.0.4841.1000
Thanks again for any/all insights and suggestions.
0
10 Tips to Protect Your Business from Ransomware
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

We are using the SharePoint hub sites and want to be able to create a template for a Team site. How can we do this?
0
Unable to edit sharepoint documents on iPad -

I need to be able to access sharepoint documents from an ipad. The iPad can connect to our internal sharepoint server and can open up the sharepoint pages in the browser. The issue is that when you click/tap on the document you wish to edit it will open in the browser but you cannot edit it.
It will give you the error below: (received this in both safari and chrome)

"To open this workbook, your computer must have a version of Microsoft Excel installed and your web browser must support opening files directly from excel in the browser"

 the only workaround I have found is:

1. copy the URL to of the SharePoint site you want to be able open documents from
2. open the office application you want to be able to open SharePoint documents from e.g. excel , word
3. tap on 'Add a place' paste in the URL and then when prompted enter in your credentials

this is a very convoluted way of accessing and editing sharepoint documents so I need to know if there is a simpler way.

ipad model - MNV62B/A
version of OS : 11.4.1
0
What are these type of DNS entries - greyed out folder appears to be zone file I cant modify the DNS servers listed in them - says new DNS server is not authorative - and also there are no A host records in the zone - pic attached - its to do with a SharePoint carousel type app on our SharePoint intranet if that helps
Capture.JPG
0
Dear Experts,

When someone creates a group iwith permissions in Sharepoint and your not aloud to access that group, Is it perhaps possible to check who made that group?

Greetings,

Peter Kiers
0
I am in a need to get a calculated field that will accommodate the following:

If Opp Type = Extension Renewal or On Contract Growth AND If TnC Change = No AND If Fin Pro = Yes Then set value to Yes

I am using the following but it does not appear to be working: =IF(AND(OR([Opp Type]="Extension Renewal",[Opp Type]="On Contract Growth"),[TnC Change]="No",[Fin Pro]="Yes"),"Yes","No")
0
All,

I am creating a SharePoint Online request form. I have the layout of what is needed for this form.  Not having any experience on how to do this I need direction on where to start.  I believe that I already have Office 365 installed I just need first steps.
I have read on this and it seems that I will need the following:
1. Add the site (somewhat straight forward).
2. Create the Excel List with the fields for the data (somewhat straight forward).
3. Create the form - This I do not have any idea how to do or where to start.

There is alot of information out there, but I need to complete this task rather quickly.

If I could be provided with Youtube videos or other documents that get to the step by step that would be greatly appreciated.

Again, any help is greatly appreciated.
0
Dear Experts, I'm testing the Sharepoint 2016 on-premises, I tried to share the document like these screenshots but the user who was shared COULD NOT receive any notification email of this sharing. I was loggin as Sharepoint Admin and it has functional mailboxa account. How can  we fix it?

sp1.png
sp2.PNG
I also CANNOT share it with external user???

sp4.PNG
One more thing, I'd like to redirect the http: site to https: site in Sharepoint but I could not configure it. I tried 2 methods but they both did not work!

1. Add both http and https links in default zone of mapping site

2. Add redirect http in IIS management


 sp3.PNG
0
I need to set and verify SharePoint Online user profile properties using PowerShell. I am currently using the PNP module using Set-PNPUserProfileProperty and Get-PNPUserProfileProperty. My problem is validating properties whose visibility is set to "Only me". I can set such properties for any user using Set-PNPUserProfileProperty, but Get-PNPUserProfileProperty is not retrieving any of the "Only me" settings.

Is this a permissions issue? If so, what permissions need to be granted to the service account to allow it to see "Only me" user profile properties for all users?

Or is this a shortcoming of the PNP command (or the API is leverages)? If so, is there a different command or method or API that I can use to see these properties?
0
In a SharePoint list, I have fields that are hyperlinks to images stored in SharePoint as well.  I am using Microsoft Flow to format emails and want to see those images in the email (the images are essentially icon shapes).

When i look at the SharePoint list, they all display as correct images.  However, I can't seem to get that image to display properly in the HTML formatted email.

Let's say the field name is imagename.  If I use that name in the email, a text URL displays.  So I tried <img src="imagename"..> and i got an image alright, but it could not be displayed.  Is this possible a permissions error because of no access to SP or something in the HTML formatting, and how can I tell?

What is another way to accomplish this?
0
C++ 11 Fundamentals
LVL 12
C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

I am formatting HTML email within Microsoft Flow.  I have fields from a SharePoint list that are currency fields, but Flow doesn't support currency and the fields have float type.  I can easily get them to an integer which truncates the two decimals or to a string which displays way too many.

My question is how to do this using HMTL code?  CSS and java script look like they may work but I don't want to depend on recipients to have it set up properly/.  Ideally I want to round to two decimal places (optional for currency fields), then format in US$.  

One thought was to multiply the value by 100, convert to type integer, then use substring() to chop it up into whole number and decimal pieces, then concatenate with $ but that woudn't handle comma delimiters.  And I have about ten such fields to email, so it's a lot of Flow code if not HTML code to accomplish.

Hope you have some suggestions.
0
What is involved with RE-IP of Sharepoint 2013 on-premise?
0
Hi all,

The company I work for runs an on premise 2008 AD. We also have an Office 365 E3 license with user account information from the AD synced to O365 using Azure AD Connect service. We want to migrate our on premise file services to Sharepoint Online, but one requirement is that we are able to map the sites in Widows file explorer on the local workstations (either as a library or mapped network drive). Whilst we can map the sites as drives (by opening the site in IE and viewing in Explorer etc), it appears that the security association times out after a week. The only way we have found to re-establish the security association, is to repeat the afore mentioned steps of logging in via IE (far from ideal).

I’m aware that Microsoft have recently made changes so that the life time of security tokens for Sharepoint Online can now be extended (which will negate the need to re-authenticator every week), but I have seen conflicting information as to whether this can be achieved without an additional Azure AD license. Can anyone shed light on a solution, or point me to a well documented KB on how to extend the security tokens lifetime. At the moment, it’s delaying our adoption of Sharepoint Online (much to the irritation of my users).

Thanks,

Rob
0
I have Sharepoint 2013 with workflows2010
problem:
i have a list with attchments..i want to copie some items into a new list via workflow
i can't select the attchment field in Sharepoint Designer.
How to copie (or better a link) to the orign attachments into the new list?
0
Hi Experts

I have created some symbolic links to different SharePoint libraries using the DavWWWRoot paths. This works in terms of opening files, however once you modify that file it becomes unable to open. The same thing happens when a file is created. Is there a solution for this or an alternative?
0
Hi guys

I'm in the process of learning Sharepoint online. Along with that, I'm trying to set up a document management system for one of our departments. I've got membership to Pluralsight, but I find that the tutorials on there are not covering the content I am looking for.

I want to create an attractive dashboard, along with the ability for this department to upload content which then results in a table filled with details, like an Excel sheet that has columns. Above each of those columns will be a search column that when typed, will used jquery to filter the table in real-time as you type. Something like this:

https://sharepoint.stackexchange.com/questions/98599/search-box-above-every-column-of-list-in-sharepoint-2010

My point is, where do I start. Any decent tutorial sites that take you from the basics to the more complicated content?  Also, how long do you think it could take for something like this to be implemented with a beginner like myself?

Thanks for helping
Yashy
0

Microsoft SharePoint

37K

Solutions

19K

Contributors

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.