Microsoft Development





Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

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

Sign up to Post

See environment below

Need VBA running in either Access (preferred) or excel which will add/delete a user to a sharepoint group and also list all members of a group into a table or excel sheet.

I've tried the OData approach for getting all users but unsure how to get it working in Access.

Environment: SharePoint 2013 - onprem, full control only (no SCA), and no farm access (no powershell).

VBA examples sought - not C##, powershell, ...
OWASP Proactive Controls
LVL 13
OWASP Proactive Controls

Learn the most important control and control categories that every architect and developer should include in their projects.

I'm trying to use the MS Installer. The installer fails because the parameters for Short Cuts doesn't allow any assignment. I'm guessing that's  why it failed.

This video gives correct instructions up to shortcuts:

Deployment around the corner and I don't see what's wrong.  

Thank you for any insights you may give.
Can anyone recommend good classes for Azure, Powershell, AD, etc?  Focus on Azure.  
 Doesn't have to be online only.  
 Thanks in advance.
I have windows server 2016 with last update and windows 10 built 1809 with last update too.
I have an application that is work under remoteapp in windows2016 server . the application have option ctrl+tab to switch between application windows.
when I click ctrl+tab on windows 10 the windows is show and going back.
also when I minimized any windows I cant maximize from the maximized button else if I do a right click and select restore.
so how I can pass that ?
I have 2 very similar VB.NET applications.  They are both Windows Forms applications, and both have some "maximized" forms and some "windowed" forms.  They are deployed to Windows 7 PC's with monitors set at 1280x800 at 125%.  

One application  sizes properly -- All forms and controls in the app size "up" properly, and all fonts size up properly.  The second application seems to size up the fonts, but not the controls or the forms themselves.  There is a form in both apps sized 450 x 500 -- One displays larger than the other at 125%.  After switching the monitor to 100%, both those forms show at the same size.

These applications are created using VS 2017 "Community".   I have checked the properties of those two forms, and they are the same.   However, since I see the problem on all forms, I am assuming it is a setting at the application level, not the form level.   In both apps, the "Enable XP visual styles" is set the same, and that's the only setting I see that may be related to how forms are displayed.

This may or may not be a clue (and I have to verify it), but when running at 125% on a Windows 10 machine, both applications size properly.

Any ideas what setting I need to change to fix this?
Hi All,

I have a client that uses MS Dynamics NAV, I have never used it and have some knowledge of Databases.

My question is, is the underlying default database a relational database when you first buy the product or do you have to set it up from scratch,
The reason i am asking is because the client has a table with numerous entries in it all assigned to one key, we want to add another key to more clearly identify the data in that table and are being told be the vendor that this is not possible.

My understanding of relational databases, is that you should be able to do this, i will stand corrected on this.

How flexible is NAV as an application to change, if a business needs to change its process?, my client operates a simple warehouse with one item in and out, with some variances on that one item, but nothing complex

Error Publishing Template Set in HotDocs Server V11.0.1 from HotDocs Developer V11.2.4
Error message HotdocsError.jpgPublishing Errors.txt
(1) Error in '180830 Business Incentives and Tax Savings Review Services.docx': failed to copy a file to the publishing folder.

Any expertise in troubleshooting issues like this with HotDocs is appreciated.
When opening or creating a key in the Windows Registry using the WIN32 C API it is possible to specify the REGSAM as one of the arguments. This details the access rights to the key, but can also be used to set the "view", be it 32 bit or 64 bit. This is achieved by passing either KEY_WOW64_64KEY or KEY_WOW64_32KEY.

My question is this: given just a HKEY, is it possible to identify the original REGSAM value that was used to open that key? The program I am writing needs to be able to make this distinction and whilst I could "cache" the original REGSAM, it would be smarter and cleaner if there was a way (using WIN32 C API) to get these details.
CWinThread wont exit in Release mode but will in Debug mode visual studio 2017.

Here is what I am doing
CWinThread *ptrDecode = AfxGetThread();
CCriticalSection c_sDecode;
static UINT mDecode(void*);
ptrDecode = NULL;

void myfuction::startThread()
      if (ptrDecode == NULL) {
	  ptrDecode = AfxBeginThread(mDecode, this);
	  WaitForSingleObject(ptrDecode, INFINITE);

UINT /*WINAPI*/  mDecode(void* pParam)
	myfuction* pThis = (myfuction*)pParam;
	CSingleLock lock(&c_sDecode);

	while (1) {
               if (! {
				if (!theApp.RTSPChangeCam) // if == false break out of while loop
				cv::resize(RTSPframe, RTSPResize, cv::Size(RTSPWidth, RTSPHeight), 0, 0, INTER_LINEAR);
ptrDecode = NULL;
	theApp.KillDecoder = false;
	return 0;

void myfuction::OnDestroy()
	//## make sure nothing is being rendered ##//
	//## kill any RTSP Streams ##//
	theApp.RTSPChangeCam = false;
	while (ptrDecode != NULL) {} // wait until thread exits


Open in new window

In OnDestroy() function the while loop waits until ptrDecode == null after theApp.RTSPChangeCam is set to false this cause the while loop in the thread to break and set ptrDecode to null and the dialog then can safely exit this work fine in debug mode and my watch window is showing me that ptrDecode has been set to null but in Release mode ptrDecode dose gets set to null if I place a break point in the thread code but then is reset to not null (seems to get reloaded) when my bullet point hits ptrDecode in the OnDestroy() function, I do not know why this is being re initilized after its been set to null. At no point in my code dose the thread get called again and it only dose it in Release mode.
Is there a setting in my release properties I need to change any help would be great
Hi, so I have a Visual Studio 2010 solution that I'm trying to open.  The problem is two-fold:

1. I can't open the solution in VS 2010 because it keeps saying I need to install SQL SSDT for 2010.  Tried to find and install it with no luck.  Keeps prompting me for it even when I "think" I have it installed

2. I have VS 2013 also installed but that has SSDT installed for it (again, I believe).  The problem though is that it's saying the solution is under source control so it won't even open it.  How do I "break" the bindings of the source control?

I did not create the solution, it was from a third party.  Any and all help would be great, thanks!
Exploring SQL Server 2016: Fundamentals
LVL 13
Exploring SQL Server 2016: Fundamentals

Learn the fundamentals of Microsoft SQL Server, a relational database management system that stores and retrieves data when requested by other software applications.

SharePoint 2013 Workflow Process Task action always redirects to the Tasks List.  Who wants that and how can I choose an alternate URL?
Having bought a new machine (running Windows 10 professional) I Have installed the following:

MS Visual Studio 2017 community
MS SQLServer express 2017
Team Foundation Server express 2015

I find that I do the have the option in VS to "Connect to Team Foundation Server"

I have "Visual Studio Team Foundation Server" set as the Source-Control Plug-in.

I can see my server in Source Control Explorer but cannot add folders or items.

If I go into Team Explorer I can see GIT repos   (dunno how to use these) and I can sometimes add a solution to Source control whereby it is visible in Source Control Explorer temporarily.

How can I connect to TFS correctly in VS 2017 Community please?
A  RichTextBox is used to right justify numerals. This is the only reason to use it.

The content to save cannot be directly accessed. Looking on the web examples are found that are complex and difficult to understand. Not realizing that there is some "hoop-jumping" required to get its content, the control was selected. Does anyone know how to do this simply and if not is there any advice that will make retrieving content easier to understand?

Thank you for any advice you may offer.

Bob - NYC Department of Parks & Recreation
There is a section in an app that requires the user to type each of 5 items into a RichTextBox. Whenever a controls has focus, SelectAll is called highlight the numeral for quick edit.

--Tab event highlights on entry
--Focus event highlights

--Mouse events do not fired: MouseLeftButtonUp, MouseLeftButtonDown, MouseDown,  MouseUp, etc.

    Private Sub richtxtPerennialsCount_MouseLeftButtonUp(sender As Object, e As MouseButtonEventArgs) Handles richtxtPerennialsCount.MouseLeftButtonUp
    End Sub

Without these events when a controls is clicked the content is not highlighted.  What's needed is to highlighted so the content is deleted on first key press.

Any help is appreciated. Thank you.

Bob Cannis, NYC Department of Parks & Recreation
Horticulture Planting Counts
Published iOS app about 18 months ago using Xamarin Studio.  Now that its Visual Studio 2017, need to recreate Apple certificates and profiles and then use fastlane to install them on my Mac.  App builds fine and it runs on an iPhone attached to my Mac.  Looking for a consultant who can help me with this process.
I'm trying to get the Word Inking feature to start when opening a document.  I have tried the following code:


This throws an error on Document Open, running it from a macro and running it from the immediate window.

What am I missing?
Issue adding a local wsdl file for royal mail to visual stusio 2017 in c#.
Print screen f error attached. Invalid URI.
How do I get Visual Studio 2017 to validate <script> tags in source code with CORS attributes?

Okay, this is an annoyance rather than a life or death problem!  I am working on a website which uses externally hosted scripts in some of its pages.  The script tags have CORS attributes (integrity and crossorigin).  Visual Studio is validating the code against the HTML5 schema.  So Visual Studio is picking these up as warnings in its error list and underlining the code with green squiggly lines.

I know I can just ignore them, or turn validation off.  I'd prefer to have them recognised as valid markup.  Is there any way that I can do that?
InfoPath 2010 form submission is not saving to sharepoint 2010 site, and end user has no errors upon submission.  The .xml file does not get saved to sharepoint, how do you troubleshoot this?  I figured it was something like incorrect permissions to a site/library for the end user to save their files.  But I check an Identical user permission with someone that is able to submit and view their documents.  The user that does not work has identical permissions.  Its very strange, and there are no reported errors from the user...
Become a Microsoft Certified Solutions Expert
LVL 13
Become a Microsoft Certified Solutions Expert

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

Creating an SSIS app with VS 2015.  Finally have the pieces connected.  When I run it I receive the below error.

Failed to start project (Microsoft Visual Studio)


Error starting debugging. (Microsoft.DataTransformationServices.VsIntegration)

Program Location:

   at Microsoft.DataTransformationServices.Project.DataTransformationsPackageDebugger.LaunchVsDebugger(IVsDebugger iVsDebugger, DataTransformationsProjectConfigurationOptions options)
   at Microsoft.DataTransformationServices.Project.DataTransformationsPackageDebugger.ValidateAndRunDebugger(Int32 flags, IOutputWindow outputWindow, DataTransformationsProjectConfigurationOptions options)
   at Microsoft.DataTransformationServices.Project.DataTransformationsProjectDebugger.LaunchDtsPackage(Int32 launchOptions, ProjectItem startupProjItem, DataTransformationsProjectConfigurationOptions options)
   at Microsoft.DataTransformationServices.Project.DataTransformationsProjectDebugger.LaunchActivePackage(Int32 launchOptions)
   at Microsoft.DataTransformationServices.Project.DataTransformationsProjectDebugger.LaunchDtsPackage(Int32 launchOptions, DataTransformationsProjectConfigurationOptions options)
   at Microsoft.DataTransformationServices.Project.DataTransformationsProjectDebugger.Launch(Int32 launchOptions, DataTransformationsProjectConfigurationOptions options)


Unable to 

Open in new window

I'm able to pass the query parameter successfully to the field however when the item is saved the record is not being saved to the list. What's interesting is that if I manually override the passed value by typing into the field on the form and then clicking save, the record is saved to the list .

We have a working example of this on the same site for a different list that we created about a year ago and does not have this issue.

Original Code Provided when a new form was created for the list in SPD:
<SharePoint:FormField runat="server" id="ff1{$Pos}" ControlMode="New" FieldName="AttachmentsID" __designer:bind="{ddwrt:DataBind('i',concat('ff1',$Pos),'Value','ValueChanged','ID',ddwrt:EscapeDelims(string(@ID)),'@AttachmentsID')}"/>
<SharePoint:FieldDescription runat="server" id="ff1description{$Pos}" FieldName="AttachmentsID" ControlMode="New"/>

Removed the above code and replaced with the following:                                                            
<asp:TextBox runat="server" id="ff1{$Pos}" Name="FileName" Text="{$AttachmentsID}" Value="{@AttachmentsID}" __designer:bind="{ddwrt:DataBind('i',concat('ff1',$Pos),'Text','TextChanged','ID',ddwrt:EscapeDelims(string(@ID)),'@AttachmentsID')}" Width="100px" Height="20px" BorderWidth="0" />
I have just started to deploy and learn Microsoft Power Bi. I installed the BI gateway and able to get it connected in the portal.  My question is, how to i make a BI workspace that calls to that data?  DO i need the BI desktop app or can i not create that from the portal?

Anyone can advice how to modify below script to find few hundred nested groups?



Function Test-ADGroupMemberInfra  {
                Param ($User)

                Trap {Return "error"}
                $output= $User
                $output+= " * "
If (Get-ADUser -Filter "memberOf -RecursiveMatch '$((Get-ADGroup "CorpSvcs_IOE_Infra&VA").DistinguishedName)'" -SearchBase $((Get-ADUser $User).DistinguishedName)) {$output+= "True "} Else {$output+= "False "}


Test-ADGroupMemberInfra -User "jimmy05" >> d:\grp1.txt
SSRS Report Builder - Export to CSV issue; Double Quotes exist for each record.

We have a report that is scheduled to produce a CSV file.
This file is consumed by another application and requires specific formatting in order to successfully process the file.
The following entry has been configured within the 'rsreportserver.config' file:

<Extension Name="CSV (No Header)" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering">
                              <Name Language="en-AU"> CSV No Header</Name>

The file that is being generated from this contains double quotes at the start and end of each record (see below).
"180603,06/06/2018,AB,123,A,AB,123456789,-1234.56,Team Journal,21/05/2018 to 03/06/2018,12345,N,I,NA,TEAMJNL,123"

The output we need is shown below:
Dear Experts,

I have an website that uses identity 2.1 (I'm pretty sure > 2.0 anyways as near as I can tell). It is written in visual basic. I ran into a weird issue the other day where people were logging in and getting this viewstate error:

Validation of viewstate MAC failed. If this application is hosted by a Web Farm or cluster, ensure that <machineKey> configuration specifies the same validationKey and validation algorithm. AutoGenerate cannot be used in a cluster.

So I followed the advice I found in the microsoft article and added a machine key to the web.config file so that no matter what it (hopefully) shouldn't get that error again.

Once the machine key was changed to one that I set now we had issues with anyone with an already existant authorization cookie on their computer, they were unable to login. I believe it's because the machine key that I set no longer matched the one that was used in their cookie. I'm not entirely clear how, but apparently it's part of how it's encrypted. If they clear their cookies, all is well - then they could login.

So one bit of advice I found searching on the web sounded super simple and super-easy. They recommended that you have some sort of set key in your web.config, like a guid or something and then you add it to your cookie also. Then, when you load the cookie, you can check the key and if it doesn't match your server key, somehow you invalidate the cookie.

I basically spent all day trying to figure out …

Microsoft Development





Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.