Tag: Microsoft

Database Design – How do I add a directory or multiple users to the Microsoft SQL Server permissions?

I have a front-end program in Visual Basic that uses SQL as the back-end. The only way to obtain permission to log in to the SQL server is to add each name or computer individually. This will take an eternity to update and wait. My question is, how do I do that at the group level? I have found 2 similar questions that essentially do the same and they can be found under the following 2 links:

https://stackoverflow.com/questions/5029014/how-to-add-active-directory-user-group-as-login-in-sql-server

Microsoft SQL Server v13 merges users from the Active Directory

My problem is that these do not work for me. I come to the end and when I click OK, nothing happens. Please refer to the picture I attached to the post.

Do I need to add the directories elsewhere before I can use the "Add" button, or am I missing something else?

Enter the image description here

Microsoft Teams Online and desktop apps display fewer folders and then nothing in the folders

Some time ago I created a Microsoft team and expanded it. As I try to share it with others, I find that there are problems with what has been synchronized from my desktop to what is displayed in the desktop app or online.

Through Windows Explorer, I can see that it has subfolders and files, but Team's online and desktop apps show fewer folders and then nothing in the folders

Enter the image description here

Microsoft Excel – Using Data Validation to List a Column

I have a workbook with a table containing headings with name and group. The name column is unique (no name is repeated), while the group column contains values ​​(such as G1, G2, G3, etc.) that are repeated.
I want to create two lists, the first one of which can select a group. In the second list, he can then select a name from this group.
Is that possible? I've tried to find a solution that works, but it seems that everyone needs to change the row values ​​in my group column to headers

Microsoft Excel – Nested IF statement, error with column with errors

I'm looking at data that has (1) a difference in dates in days and a product type (for this particular example, product type = F).

Currently my date column has this formula: 

= DATEDIF ([@[END]],[@[START]]"D")

Sometimes this data will return the error "#NUM" because the start date is before the end date (the type of data).

The formula I have a problem with is: 

= IF ([PRODUCTTYPE]= "F", IF ([@[Day Difference b/w StartandEnd]]> 100, "NO", "YES", "N / A")

Since the error #NUM is displayed in the "Date difference" column, these are inserted in the second formula in the "NO" container. I would like to be the result, if the date column had a # NUM error, then this formula would also be set as "N / A".

What is missing?

App Windows – Microsoft Office Professional Plus 2016 (x86-x64), Version 16.0.4738.1000, March 2019 | NulledTeam UnderGround

x86, x64 | Language: English, Greek | File size: 7.92 GB

Microsoft Office 2016 is the complete, cross-platform, multi-device solution for the modern workplace with intelligent tools for individuals, teams and businesses. It can open your applications and documents anywhere on multiple devices. Get the installed applications you know and trust – Word, Excel, PowerPoint, OneNote, Outlook, Publisher, Access. Always use the latest, fully installed versions of Word, Excel, PowerPoint, OneNote, Outlook, Publisher, and Access, and pick up your ideas based on how you work best – with a keyboard, pen, or touchscreen. Microsoft Office 2016 provides new security, compliance, and delivery capabilities that give organizations more control over sensitive data and the IT department's deployment and management. Here's a new version of Microsoft Office 2016 – Update one of the company's most important products, which is quite stable despite the status of the preview.
The

Microsoft Office 2016 shows very well how the approach to creating documents and working with them has changed today. Microsoft has extended the office presence to iPad and Android tablets. Improved Office experiences on the Mac, the iPhone and the Web. In addition, new apps have been added to the Office family with SWAY and Office Lens. Everything is designed to keep your work moving everywhere. While you've focused on optimizing Office for multiple platforms over the past year, make no mistake, Office on Windows Desktop is central to our strategy.

The Microsoft Office 2016 suite includes applications such as Word, Excel, PowerPoint, and Outlook. Office 2007, Office 2010, Office 365, or Office 2013 users can open documents that are created without additional measures. Customers using earlier versions of Office may need to download and install a compatibility package.

Package:
Microsoft Office Professional Plus 2016
Microsoft Access 2016
Microsoft Excel 2016
Microsoft InfoPath 2016
Microsoft OneDrive for Business in 2016
Microsoft OneNote 2016
Microsoft Outlook 2016
Microsoft PowerPoint 2016
Microsoft Publisher 2016
Skype for businesses in 2016
Microsoft Word 2016

What's new:
03.05.2019:

added:
access2016-kb4462192
chart2016-kb4461439
Excel2016-kb4462212
lync2016-kb4462190
mso2016-kb4462214
msodll302016-kb4462195
msodll99l2016-kb4462118
outexum2016-kb4032231
Ausblick2016-kb4462196
Powerpoint2016-kb4462191
project2016-kb4462198
word2016-kb4462193

Away:
access2016-kb4032257
chart2016-kb4092449
Excel2016-kb4462115
lync2016-kb4462114
mso2016-kb4462146
msodll302016-kb4461536
msodll99l2016-kb4461533
outexum2016-kb3191864
Ausblick2016-kb4462147
Powerpoint2016-kb4461599
project2016-kb4462134
word2016-kb4462145

START PAGE

English x86:

Greek x86:English x64:Greek x64:

Microsoft Excel – How is the formula displayed instead of the result?

I have a long list of values ​​that contain one division operation per cell. For example, I have 387/399 in a single cell (say in B2). I need Excel to recognize the result, but display the number as it is (with no equal sign before – just text). Are there such things? Or can another cell recognize its result and continue to calculate it from there? Example in C2: = B2 * 50

Many thanks for your help

Microsoft Word – Prevents removal of mergefields or bookmarks after merging data

In our organization we are preparing a series of documents with Word 2016. Data is merged or sometimes called a merge. In doing so, we insert some data from the Excel spreadsheet for data into a Word document. That works great.

Recently, however, our organization has acquired an electronic documentation system for easier document management.
Now the problem has arisen because the mentioned documentation system automatically assigns document numbers to each document and can even insert them into the document itself. However, this requires a predefined bookmark in the document to mark the location to which the document number data is to be written.
By default, because merging data removes all merge fields and bookmarks, we need to insert the required bookmarks into the document after merging the data.

So I'm wondering if it's possible to prevent the merging of data to remove certain bookmarks in the template.