Author Archives: Dan

If Word randomly crashes when opening SharePoint documents

I’ve been working on a PowerShell script that automates Microsoft Word to open all files in a SharePoint library, modify the header and other properties and then save it again. I ran the script against 4000 documents and everything went … Continue reading

Posted in Development, Tips | Tagged , , , , , , , , | Leave a comment

Excluding page templates in CAML queries

Typically, when requesting SharePoint pages we do not want to include templates, just normal pages. When saving a SharePoint page as a template, this is noted in a property called OData__SPSitePageFlags . With this information we can easily exclude templates by … Continue reading

Posted in Development, Tips | Tagged , , , | Leave a comment

Open a SharePoint list in classic experience if link is missing

The modern list experience in SharePoint is the default by now. But you can still revert to classic experience by clicking the link under the left navigation. But on communication sites the left nav is turned off by design. If … Continue reading

Posted in Tips | Tagged , , , , , | Leave a comment

Where is “Tenant Wide Extensions” list when using Site Collection App Catalogs?

A fairly new feature in SharePoint Online is the ability to have Site Collection App Catalogs. Neat. Even “Tenant Wide” application customizers work (though they are of course scoped to only the site collection). Creating a Site Collection App Catalog … Continue reading

Posted in Development, Tips | Tagged , | Leave a comment

What if there were no ad blockers?

Sometimes I browse the web without an ad blocker. It’s typically a horrible experience. I don’t understand how people stand it. I don’t watch TV any more, and a big part of this is that I can’t stand the ads. … Continue reading

Posted in Opinion & Thoughts | Tagged , , , | 3 Comments

Maximizing Hyper-V Windows (instead of full screen)

I recently started using Hyper-V after being used to VMware. I want my virtual machine windows maximized, but not full screen since I need to quickly move between the host and virtual machines. In VMware the maximize button will do … Continue reading

Posted in Tips | Tagged , , , , | 3 Comments

Transparent CSS borders with the inherited color

You can inherit CSS colors from parent elements using the  inherit  or  currentColor  keywords:

This works for border color too:

But suppose you’d want to have a semi-transparent color. When setting colors normally you would simply use  rgba()  to specify the … Continue reading

Posted in Development, Tips | Tagged , | 1 Comment

MS Teams fullscreen view?

Microsoft Teams does not have a “true” fullscreen mode. Even if you select both “focus” and “fullscreen” there is always a command bar left at the top. This can make it difficult read small text when people are sharing their … Continue reading

Posted in Tips | Tagged , | 2 Comments

Hacking DocX files to fix Quick Parts in Word Online

Microsoft Word documents can have Quick Parts connected to SharePoint fields, so that the value of the field is displayed inside the document. But Word Online (still) does not fully support this. It will display Quick Parts with a a … Continue reading

Posted in Development, Tips | Tagged , , , , , , | Leave a comment

Migrating data from Access to SQL Server

Suppose that you have a simple Microsoft Access database that you need to migrate to another database such as MS SQL Server. You model the tables and relationships in the new database, and now you need to export the actual … Continue reading

Posted in Development, Tutorials | Tagged , , , , , , | 1 Comment