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 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 mathematical error Example: Formula: 0 100

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 monthly project hour write-down in Excel

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 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 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 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 Charts often appear too small Concerns:

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 connected tables Solution: You have to go under the query >properties Set the UNIQUE RECORDS -> setting to true

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_HASH_SHA256(C6) The encoded hash werte in a new cell output The example file is available for download in the blog

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") Error message Microsoft Visual Basic Runtime error '-

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 replacement term In the simple example, numbers are changed to new other numbers When using encryption, the use of hash functions can be used The random number is initialized once and then counted against numbers Wh

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 inserted, And pseudonyms are awarded for texts Here is an anonymized and pseudonymized table Apply ingthe Random function in a table or query

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 problems First test: Here you can check whether and which Office applications you have installed programs Simply go to Portal Office and check your account

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 reopen the database Then the new column becomes invisible for new tables

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 this on Windows->Start (right mouse button) on Info->System Settings->Environment Variables->Expand Environment Variables And the path Enter C:'Windows'System32' After all MS DOS system commands are detected directly in Windows Command Console

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 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 new text that will be replaced Note: the area to be changed must be highlighted in gray otherwise the searched range refers to either the worksheet or the entire excel document