Freelance Project Requests info@CodeDocu.de Software Development in C# WPF Asp.Net Core Vba Excel Word SQL-Server EF Linq, UWP Net
#
Automatically adjust Access forms to the maximum monitor size Office-365/Access/Basics/vba-Code
Automatically adjust Access forms to the maximum monitor size
03.02.2020 106
the following vba code example shows how to automatically customize Microsoft Access Database forms to the maximum width of the current monitor All controls such as text box or label elements are moved to the corresponding positions at run time and adjusted i

Excel: Convert numbers, date and time to text Office-365/Excel/Code-vba-Makro
Excel: Convert numbers, date and time to text
14.01.2020 135
How to convert entire columns or ranges in Excel from numbers, date or time format to real text

Excel : Convert numbers to text Office-365/Excel/Formulas
Excel : Convert numbers to text
10.01.2020 116
The following example shows how to convert numbers to text in Microsoft Excel The problem is that SAP used to output numbers such as personnel numbers or accounts in Excel as text You could see it by the fact that the numbers were displayed left-aligned in Excel Since

ok Timestamp  Access Write conflict:  This record has been modified by another user since editing began Office-365/Access/Errors
ok Timestamp Access Write conflict: This record has been modified by another user since editing began
07.01.2020 143
ok Timestamp Access Error Message: Write conflict: This record has been modified by another user since editing began Error message

Excel: Calculate total statistical frequency number of texts Office-365/Excel/Templates/Calculations
Excel: Calculate total statistical frequency number of texts
07.01.2020 102
How can I determine the total number as the frequency of a value in Excel? How often does a value occur? Exceltrick: with the Shift+Ctrl+Enter key, a matrix function is entered in the formula entry as curly braces

Excel Formula: Calculation Performance of a Resistance at a Voltage Office-365/Excel/Templates/Calculations
Excel Formula: Calculation Performance of a Resistance at a Voltage
06.01.2020 99
Electric formulas Excel file as a download as a file Green fields are input fields

SharePoint Code: Get ListItem by Code Server/SharePoint/WebParts
SharePoint Code: Get ListItem by Code
17.12.2019 109
With the following React code you can find an item from a list in SharePoint and then evaluate it The underlying code is

Debugging with the Microsoft Browser in VS Code Server/SharePoint/WebParts
Debugging with the Microsoft Browser in VS Code
17.12.2019 186
Many SharePoint applications run in Citrix environments and customer corporate environments using Microsoft Internet Explorer MSIE or Microsoft Edge If you want to create, develop and debug reproducible test developments for SharePoint solutions at the c

Debugging von SharePoint in Visual Studio Code Server/SharePoint/WebParts
Debugging von SharePoint in Visual Studio Code
17.12.2019 117
In order to debug a SharePoint application or a SharePoint WebPart directly in VSCode, you have to use the launch json file in the Name: Hosted workbench the registration url: enter the SharePoint Workbench on the target server system the hosted workben

Error SharePoint Gulp Serve: Local modules not found in Server/SharePoint/Error
Error SharePoint Gulp Serve: Local modules not found in
16.12.2019 132
SharePoint: Local modules not found in when you create a new WebPart in SharePoint or get the code from the DevOps directory you cannot run gulp serve for debugging Error message for gulp serve

Publish Install SharePoint WebPart on Server Server/SharePoint/WebParts
Publish Install SharePoint WebPart on Server
16.12.2019 124
How to copy the locally developed code of a web part to the server ? è With the following script you can deploy a web part automatically to the server under VS Code, React

Enable JS-Link for WebParts in SharePoint Server/SharePoint/WebParts
Enable JS-Link for WebParts in SharePoint
16.12.2019 105
SharePoint: Enable Javascript the following commands allow you to enable embedding client scripts for web parts in SharePoint for a specific site As a result, the client scripts used under JS-Link are active on WebParts

Access Error: Data Type Conflict in Criteria Expression Office-365/Access/Errors
Access Error: Data Type Conflict in Criteria Expression
11.12.2019 161
Error message Data type conflict in criteria expression Errors in formula:

Access Error: #Number or Overflow Office-365/Access/Errors
Access Error: #Number or Overflow
11.12.2019 123
Access Error: #Zahl Error message: Simple Microsoft Access queries may cause the error to occur with the number or overflow Cause: The cause of the message is an incorrect formula If in a formula 0 is divided by a divider, this results in a mathemat

Access Solution: Query is corrupted, Runtime Error 3340 Office-365/Access/Errors
Access Solution: Query is corrupted, Runtime Error 3340
10.12.2019 209
This error will appear in late 2019 for some Microsoft Access databases The error occurs when a table is to be updated Display of the error in vba Vba Error: The error occurs when a table is updated directly

Access: Import and Read Excel file automatically Office-365/Access/vba/Code-Examples
Access: Import and Read Excel file automatically
09.12.2019 134
Access: Read Excel file automatically The following vba code example shows how to automatically import complete Excel files under Microsoft Access

Access vba  code: Print a form directly with printer selection Office-365/Access/vba/Code-Examples
Access vba code: Print a form directly with printer selection
09.12.2019 102
With this vba code you can print an Access form directly, where by the time the printer selection appears, but no preview view is displayed

Mobile

.

Contact for Jobs, Project Requests: raimund.popp@microsoft-programmierer.de