Access vba code: Print a form directly with printer selection 09.12.2019   2 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

Access error message: Could not delete from specified tables 07.12.2019   10 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   27 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   29 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   30 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   29 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   25 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

Excel: Replace text in a selected area 26.11.2019   38 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

Excel: Convert letters to Ascii numbers around 26.11.2019   27 Excel: Convert letters to Ascii numbers around Here you will find a code with which you can convert letters into numbers in Excel In the example, A becomes 1 , B->2, C->3 The vba code is for copying and an example file in the appendix

Excel function: find the position in a column or row 26.11.2019   33 Actually, the function comparison (search text; search area,1) But the formula always leads to a problem in vba Excel That's why I simply rewrote the function here with =get_First_Match(SearchText; search area) The function, the code is below for copying or as a download in the appendix file

Excel: Find text in a value 07.11.2019   49 Excel: Find text in a value the formula finds the text position in which a text or character occurs The difference is =SEARCH and =FIND in whether case is case sensitive =SEARCH("a"; B4) 1 No capitaliza

Excel: Count how often a value occurs 07.11.2019   41 With the formula = COUNTIF (B:B;" =" & B6)

Error CS0103: The name ApplicationData does not exist in the current context 01.11.2019   67 Error CS0103: The name ApplicationData does not exist in the current context Error message Name Value

Registration of the app failed. 0x80073CF3 01.11.2019   75 Registration of the app failed [0x80073CF3] Error message when creating the application: DEP0700: Registration ft he app failed [0x80073CF3] The Microsoft Programmer d WebCamonTop_2 2 22 0_x86__7ybgfjdkkdkmr package cannot be installed by Windows because it depends on a framework that was not found Set the Microsoft NET Native Framework Debug 1 6 framework, published by CN=Mi

Resize the photo and copy it to the clipboard 27.10.2019   77 The following Code loads a photo, resizes it, and then copies it to the cache Background: in the code, you want to load a photo in Word using the Word addin Before it is pasted into the Word document, the photo is resized at run time, and then saved to the Word clipboard for further processing

Change Excel Adress Z1S1 R1C1 row column to A1 25.10.2019   59 Excel -> Toggle column header from 1 2 3 4 5 to A B C In cell at the top left is: Z1S1 But I need the cell address: A1 File Options Reference type switching to File->Options->Formulas-> Z1S1 Reference Type : TurnOff After that, all column headers with A B C D E F Referred

Disable Button with Javascript on Sharepoint Buttons 24.10.2019   43 Create disable button on document You can adjust the button as follows Button disable in javascript let btn =

Expand Windows with a mobile phone or tab as a monitor 14.05.2019   388 How to use an Android phone smartphone or Android tablet as a monitor extension First, you have to install the app spacedesk (remote display) on the Android phone tab Then you have to install the free Spacedesk application on the Windows PC on the website spacedesk net

Words Control in Microsoft Word Dictation: Point New Line 07.05.2019   383 Characters and control words for Word dictation The following words can be used in Word diktat Point Come Question mark exclamation point Brace on, brace too Semicolon Colon

Series email with optional file attachment 27.01.2019   1594 corrected file version: 20190515 with optional attachements Series email with optional file attachment

E-mails automatically with Excel vSend based on a data list 26.01.2019   1800 E-mails automatically with Excel vSend based on a data list The following email file sends emails to a data list, which they simply have to insert into the prepared data sheet as values The email text is a template in the sheet: _ Text and here columns can be personalized as placeholders [X] as with series emails in every email

Excel Icons 12.01.2019   1518 Excel Icons A list of internal names for Microsoft Excel icons:

Code: Word Addin with photos resize and paste in Word 14.11.2018   607 Code: Word Addin with photos resize and paste in Word The following code example creates a Word Addin that inserts photos into a Word file at a specific location or table with a target The photos are scaled down in Windows and inserted into a new table behind the position target

How to Get the Word Template or a New Word Document in VSTO Addin 13.11.2018   681 Word Template in VSTO Addin How to determine the template of a Word document when launching a C # code in debug in Visual Studio Solution: You can only use the associated template with get_AttachedTemplate (); determine

Insert a line break at the end of a line and then insert text or a table 12.11.2018   616 Word: Insert a line break at the end of a line and then insert text or a table Task: At the end of a certain line o

Word Addin: Insert photos after a picture mark into a table 10.11.2018   840 Word Addin: Insert photos after a picture mark into a table This Word addin inserts after the Bookmark Imaging: a multi-column table or inserts photos into a predefined target table

Word: insert characters at the end of a line 10.11.2018   524 Word: insert characters at the end of a line This little code script inserts a break at the end of a sentence and then inserts an empty table In C #, according to vba

Solved: 0x800A03EC at Excel Pastespecial 03.11.2018   676 Solved: 0x800A03EC at Excel Pastespecial Error Description When running an Excel Copy and PasteSpecial application in an Excel Addin (VSTO Interop) an error message 0x800A03EC is generated &nb

Text input fields in Word with vba c # 02.11.2018   521 Text input fields in Word with vba c # This code example shows how to insert FormTextInput form fields in word Th