Freelance Project Requests info@CodeDocu.de Software Development in C# WPF Asp.Net Core Vba Excel Word SQL-Server EF Linq, UWP Net
#
Access Error: Data Type Conflict in Criteria Expression Office-365/Access/Errors
Access Error: Data Type Conflict in Criteria Expression
11.12.2019 1
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 1
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

Excel: Timesheet Calendar as Download Template Office-365/Excel/Templates/TimeSheet
Excel: Timesheet Calendar as Download Template
11.12.2019 1
Excel: Timesheet Calendar Write Calendar write-off template in projects As an Excel template If you have any questions or suggestions about vba: raimund popp@comline-se de The file is a simple template on how to perform the month

Access Solution: Query is corrupted, Runtime Error 3340 Office-365/Access/Errors
Access Solution: Query is corrupted, Runtime Error 3340
10.12.2019 20
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 10
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 7
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

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 19
, 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 11
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 38
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 34
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")

Excel : Anonymizing and pseudonymizing numbers Office-365/Excel/Templates
Excel : Anonymizing and pseudonymizing numbers
04.12.2019 14
With a simple vba function Download with Excel File as an example The following Excel file anonymizes data based on a unique random number Anonymization: Anonymization changes sensitive critical data to another non-easily derived new replacemen

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 32
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 31
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 26
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

Windows Path To Expand Environment Variables Others/Windows/CMD
Windows Path To Expand Environment Variables
01.12.2019 17
Enter C:'Windows'System32' Problem: If the basic Windows DOS commands like net are not recognized in the Command Shell, then you can extend the basic path in which all commands are searched first in the Windows System environment variable To do t

The name net was not used as the name of a cmdlet, function Others/Windows/CMD
The name net was not used as the name of a cmdlet, function
01.12.2019 16
Error message net : The name "net" was not used as the name of a cmdlet, function, script file, or executable Program detected

Excel: Replace text in a selected area Office-365/Excel/Tutorials
Excel: Replace text in a selected area
26.11.2019 41
Guide: I want to change text in the cells of a defined Excel range How do you do that? You mark the area in Excel Then Ctrl+H for the Search and Replace dialog In Find What: Enter the search text In Replace with: enter the n

Mobile

.

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