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 113
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 to text Office-365/Excel/Formulas
Excel : Convert numbers to text
10.01.2020 120
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 147
ok Timestamp Access Error Message: Write conflict: This record has been modified by another user since editing began Error message

Include SharePoint Lists in MS Access Server/SharePoint/Tools
Include SharePoint Lists in MS Access
18.12.2019 130
Include SharePoint Lists in MS Access Under Microsoft Access, you can directly bind SharePoint lists from SharePoint Online and the on-Premise Framework as bound datalists After that you can edit the data directly here How to include SharePoint lists in

Debugging with the Microsoft Browser in VS Code Server/SharePoint/WebParts
Debugging with the Microsoft Browser in VS Code
17.12.2019 200
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

Error SharePoint Gulp Serve: Local modules not found in Server/SharePoint/Error
Error SharePoint Gulp Serve: Local modules not found in
16.12.2019 136
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

Enable JS-Link for WebParts in SharePoint Server/SharePoint/WebParts
Enable JS-Link for WebParts in SharePoint
16.12.2019 108
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: #Number or Overflow Office-365/Access/Errors
Access Error: #Number or Overflow
11.12.2019 129
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 215
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 141
Access: Read Excel file automatically The following vba code example shows how to automatically import complete Excel files under Microsoft Access

Resolved: Correct scaling of Office programs in Windows 10 Others/Windows/Windows-10/Windows-10-Problems
Resolved: Correct scaling of Office programs in Windows 10
08.12.2019 121
, Access, Excel For Microsoft Office applications, charts or graphs on Office 365 may appear too small or blurred if screen scaling is set too large For example, the monitor has been changed from 100% to 125% or 150% under Resolution, then Microsoft Graphics and Chart

Access error message: Could not delete from specified tables Office-365/Access/Fehler
Access error message: Could not delete from specified tables
07.12.2019 118
Error message when running a data delete query Could not delete from specified tables The error comes with Microsoft Access queries when trying to delete data from connect

Excel : Encoding values with HASH functions SHA256 Office-365/Excel/Templates
Excel : Encoding values with HASH functions SHA256
04.12.2019 420
Applies to Microsoft Excel, Access Word Outlook PowerPoint, Secure Encryption The following file encodes text with the SHA256 hash into encrypted values To do this, the appended code is inserted into vba macro You can use the Excel function to =get

Resolved: Excel vba Run-time error -2146232576 (80131700) Automation error Office-365/Access/Errors
Resolved: Excel vba Run-time error -2146232576 (80131700) Automation error
04.12.2019 233
When using hash functions in Microsoft applications, vba Macro Code displays the error shown as soon as you get to the line: Set Encoder = CreateObject("System Text UTF8Encoding")

Anonymizing and pseudonymizing data with Acess or Excel Office-365/Access/vba/Code-Examples
Anonymizing and pseudonymizing data with Acess or Excel
04.12.2019 136
In Microsoft Access, Random, Anonymous, Pseudonym, Easy conversion to functions ID number without hash in vba In the following demo database, important data is anonymized and pseudonymized This means that for important numbers, non-traceable other numbers are ins

Issue: Microsoft Office programs are not recognized in File Explorer Office-365/Access/Fehler
Issue: Microsoft Office programs are not recognized in File Explorer
04.12.2019 131
On my new computer, the Microsoft Access programs or files are not recognized This means that all files ending in accdb will not be recognized Although the program Microsoft Access itself exists in Windows Start and in the Taskbar and starts without any p

How To Hide the new Column in Microsoft Access Table Office-365/Access/Basics/Tables
How To Hide the new Column in Microsoft Access Table
04.12.2019 115
How to hide the [Add New Column] in Microsoft Access in the Table Design To do this in Menu->Options->Current Database The setting: Enable design changes for tables in datasheet view ->Turn off Then close and

Mobile

.

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