📃 User Notes/

NET: FolderPicker zum Auswählen eines Verzeichnisses

NET FolderPicker zum Auswählen eines Verzeichnisses In C einen Ordner auswählen Wie kann man in Windows 10 einen Verzeichnis Dialog erstellen zum Auswählen eines Ordner Windows FolderPicker Folder Dialog Notiz leider werden angeschlossene USB Laufwerke v

04.12.2020 (👁12)

UWP: Messagebox schreiben

UWP Messagebox schreiben Beispiel wie kann man eine Fehlermeldung in einer kleinen Message Dialog anzeigen Hierzu nimmt man einfach die MessageDialog Code Beispiel private async void myButton Click object sender RoutedEventArgs e await new MessageDi

04.12.2020 (👁8)

Blender Warnung: Object has non-uniform scale

Blender Warnung Object has non uniform scale Bearbeitungs Bereich Sculpting Die Meldung tritt auf wenn man auf Sculpt Mode wechselt und dann ein Objekt mit einer Brush wie Grab verändern möchte Problem Die Scale Faktoren in den XYZ Achsen sind versch

28.11.2020 (👁53)

Blender: Struktur feinmaschiger machen mit Remesh

Blender Struktur feinmaschiger machen in Sculpting Blender Menü Remesh Voxel Size 0 4m Remesh Danach ist die Struktur wesentlich eng maschiger Nach Remesh

28.11.2020 (👁60)

Blender: Apply Button fehlt

In der neuen Version von Blender wird der Apply Button nicht angezeigt Lösung Das Objekt markieren Object Mode wählen Modifier Menü Subdivision DropDown Icon Apply CTRL A Wenn man Apply klickt dann wird der grobe Körper in mehrere kleine Flächen übern

28.11.2020 (👁58)

Blender: Mirror übernehmen von einem Element

Bei Blender erstellt man erst ein Primäres Element und fügt diesem einen Mirror Punkt Objekt hinzu hier die Rechte Hand Mirror Bauch erstellt eine Kopie linke Hand Und dann übernimmt man die gleiche Mirror Einstellung auf andere Objekte hier alle Körpe

28.11.2020 (👁56)

Blender : Gruppieren und Selectable Option deaktivieren

Blender Gruppieren und Selectable Option deaktivieren Gruppieren von Objekten M Move to Collection Mit New Collection die Körper in eine neue Collection aufnehmen Dadurch werden die Objekte in einer Gruppe zusammgefasst Symbolleiste rechts oben Filter

28.11.2020 (👁51)

Blender: Stirn und Fläche an Körper markieren

Wenn man in Blender einen Teil Körper bearbeiten möchte der aus Stirnfläche und Umlaufflächen besteht dann kann man einfach die Ctrl Funktion verwenden Dadurch wird der nächstliegende Bereich zusätzlich markiert Hier Die Stirnfläche markieren und Ctrl

28.11.2020 (👁52)

Blender: Verlängerung in einer Achse bauen

Beispiel ein Anschluss Zylinder an einer Achse anbauen Schritt 1 mit TAB auf Edit Mode wechseln Schritt 2 mit 3 auf Flächen Modus in Edit Schritt 3 dann die Stirnfläche anklicken Schritt 4 E Extude S Scale Anschliessend kann man mit E Extrude die Fläc

28.11.2020 (👁60)

Blender: Mirror Achse ist falsch orientiert, richtig einstellen

Blender Mirror Achse anpassen Wenn man in Blender einen neuen Körper einfügt und diesen dreht dann stimmt oft beim AutoMirror die spiegelungsachse nicht mehr Behebung Achse einstellen in Edit Fenster Beispiel Neues Zylinder Objekt eingefügt und um 90 Gr

28.11.2020 (👁56)

Blender: neue Objekte Körper hinzufügen

Blender neue Objekte hinzufügen Hierzu in den Object Mode gehen und den Cursor 2 Symbol links an eine Stelle setzen wo das Objekt hin soll Dann Shift A und Mesh Cube Um einen Würfel hinzuzufügen Einen Zylinder fügt man mit Strg A Mesh Cylinder hinz

27.11.2020 (👁56)

Blender: Ausbuchtung oder Einbuchtung erstellen

1 Turn on the processing with TAB first 2 then switch to surface mode with 3 3 then select the surfaces 4 Activate with I für Intrusion and pull backwards Damit kann man eine kleine Innenfläche erstellen 5 Und dann E für Extrusion Damit kann man

27.11.2020 (👁56)

Blender: Ausschnitt vertiefen und anpassen

1 Erst die Bearbeitung mit TAB einschalten 2 dann auf Flächen Modus umschalten mit 3 3 dann die Flächen selektieren 4 mit E Extrude aktivieren und nach hinten ziehen Und mit S Scale verkleinern damit ein Übergangsbereich entsteht

27.11.2020 (👁53)

Blender: Schnittebene einstellen

Blender Eine zusätzliche Schnittebene einfügen und Einstellen Unter Blender stellt man zusätzliche Ebenen als Loop Cut Ebenen ein Hierzu wird der Körper markiert und mit TAB auf Edit Mode umschalten und Dann mit CTRL R eine Schnittebene einfügen Die

27.11.2020 (👁55)

Blender: Automirror einschalten

Blender Automirror Mit der Blender Zusatz Funktion Automirror kann man automatisch die Gegenstände spiegeln beim Bearbeiten Das ist eine sehr gängige Praxis dass man symmetrische Aufbauten zunächst nur einseitig konstruiert Man spart sich dadurch die ma

27.11.2020 (👁51)

C# Beispiel Code zu Unity 2D Game

Einfacher Link zu den Code Script Dateien für Unity 2d Samples des Game Tutorials Im Unity 2D Kurs von BlackThornprod findet man die Code Dateien in GitHub Unter Github findet man die C Game Dateien für die Online Schulung zu Unity 2D https github com L

19.11.2020 (👁87)

Gelöst: Absender Email From einstellen in Outlook vba Makro

Gelöst Absender Email From einstellen in Outlook vba Wenn man versucht mit Vba Makro einen Absender in einer Email in Outlook einzustellen dann führt das meistens zu einem Fehler Bisher habe ich noch keine Lösung im Internet gefunden Hier ist die Lösung

16.11.2020 (👁140)

Fehlercode 450: Beim Verwender des Code: Email.Session.Accounts(sEmail_From)

Fehlercode 450 Beim Verwender des Code objEmail Session Accounts sEmail From Fehler 450 Description Falsche Anzahl an Argumenten oder ungültige Zuweisung zu einer Eigenschaft String modEmail Send Email to Address Lösung 1 entweder mit Acounts Item Email

16.11.2020 (👁135)

Serien Email aus einer Excel Liste mit Platzhaltern und Textvorlage in Word

Emails mit Excel senden Diese Excel Datei bietet eine Liste in welche man Email Adressen einfügen kann und diese dann automatisch an alle Teilnehmer mit Microsoft Outlook senden kann Der Text für die Email wird aus der beiliegenden Word Datei entnommen H

06.11.2020 (👁440)

Aus Excel ein Word Inhalt lesen

Vba Code Beispiel mit Excel ein Word Dokument lesen In Word Makro ist der Code Dim app Word As New Word Application Dim doc As Word Document Set doc app Word Documents Open sWord Filepath ReadOnly True Visible False doc Content Copy Dim cell As Rang

06.11.2020 (👁222)

Windows: Emojis mit Win+.

Windows Emojis mit Win Wenn man unter Windows Emojis in eine Anwendung schreiben möchte als Whatsapp Web Web Chrome Browser Office Anwendungen Word Excel Powerpoint und alle anderen Windows Apps dann muss man nur Windows Taste plus Punkt klicken und sch

06.11.2020 (👁151)

Word Vorlage zum Einfügen von Fotos

Word Vorlage zum Einfügen von Fotos Diese Word Vorlage macht folgendes Beim Klick auf den Button Fotos einfügen kann man Fotos vom lokalen Laufwerk auswählen und diese werden dann in den Vorlagen Block eingefügt Dabei wird in das Feld Filename die Datei

04.11.2020 (👁482)

Vba Code: Copy template area

This Word template does the following It copies the range table below template and pastes it to the area before the ID Vba Code 1 Find placeholder marker in words 2 Parent table as Search range 3 Range copy and paste Vba Code Example Option Explicit On

04.11.2020 (👁261)

Vba Code: Vorlage Bereich kopieren

Diese Word Vorlage macht folgendes Es wird der Tabellen Bereich unterhalb von Vorlage kopiert und an den Bereich vor der Kennung eingefügt Vba Code · Platzhalter Markierung suchen in Words · Übergeordnete Tabelle als Range suchen · Range copy und Paste V

04.11.2020 (👁292)

Vba Code: Platzhalter finden und ersetzen

Vba Code Platzhalter finden und ersetzen Der vba Code sucht einen Platzhalter Text im Word Document und ersetzt diesen durch einen anderen Text Gezeigt wird Durchlaufen aller Words in einem Word Dokument Den gefundendenen Text als Paragraph auswählen R

04.11.2020 (👁281)

Series email with optional file attachment

In the following Excel template regular e mails are sent via Outlook to all lines included in the following list Email attachments can be entered either at the top of the input via the button Select Manual in C5 In addition an individual appendix is t

27.01.2019 (👁2575)

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 e

26.01.2019 (👁4561)

WPF: Open Window at an position

How do you set a WPF Window so that it is placed directly at the position or place of the mouse when opening Solution To do this directly in the event Window Loaded adjust the top and left position this Top Mouse GetPosition null Y this Left Mouse

13.01.2019 (👁1464)

Excel Icons

Excel Icons A list of internal names for Microsoft Excel icons Directory C 2007 Office System Developer Resources 2007OfficeIconsGallery File Office2007IconsGallery xlsm Download from Microsoft You can download the compressed file here at Microsoft Dow

12.01.2019 (👁3050)

WPF: Drag Drop Expamle

WPF Drag Drop Beispiel The following C Code example shows the simple creation of a drag and drop function in WPF In this example a rectangular planning field WPF button is drawn into a planning calendar WPF Border With a WPF drag and drop operation any

12.01.2019 (👁3437)

WPF: Read SelectedItem from DataGrid with Dynamic As Anonymous Type

How to evaluate an Coloumn Value in a WPF DataGrid SelectedItem Task I want to read out the value of a column from a data Grid in WPF Unfortunately the evaluation of DataGrid SelectedItem results in a line from the Type Anonymous Type and if you convert

31.12.2018 (👁3824)

WPF: Elements too wide, edge Cut off

WPF Elements too wide edge Cut off Problem The input fields are not displayed correctly For at any reason the right edge is always cut off Solution Under XAML WPF you should take control Width 123 Set the width of an element over the stretch setting of

31.12.2018 (👁1535)

WPF: Selection enter open and well take over with Button Elements

WPF Selection enter open and well take over with Button Elements This example shows that we open a WPF element a selection as a window and a selection is made from it The selection then adds a button to the inside of the first caller Call pop up The w

29.12.2018 (👁2908)

Solved: System.InvalidCastException HResult=0x80004002

Solved System InvalidCastException HResult 0x80004002 Error message System InvalidCastException HResult 0x80004002 Message Das Objekt des Typs f AnonymousType6 6 System Int32 System String System String System String System String System String kann n

29.12.2018 (👁3177)

WPF: Combobox Selected Value

Task How to determine the selected Wert in WPF at a Combobox I would like to find out with a Combobox in WPF which number the selected item has The items in the Combobox were loaded via ComboBoxItem via content as display text and tag as value Solution

28.12.2018 (👁5111)

How to add a database functionally to a WPF application

If you already have a WPF application with a local database then you go in the Solution Explorer Add data model connection At Project Add New Item Add New Item Installed Visual C Data ADO NET Entity Data Model Although you only want to install Entity F

16.11.2018 (👁5382)

Code: Word Addin with photos resize and paste in Word

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 b

14.11.2018 (👁6849)

Code: Resize Photo with Windows, Resize

Code Resize Photo with Windows Resize Task A small easy Windows C code to downsize a photo or image to a smaller size Subject Windows Forms C Also works in NET Core code Resize format Bitmap source Bitmap new Bitmap input Image Path Image outImag

14.11.2018 (👁1494)

Solved: Thread must be set to Single Thread Apartment (STA) mode

Problem When using the Clipboard clipboard in an Addin application for Word comes the message that the clipboard is not declared as STA thread Source code with error Currently in the program a reduced bitmap is created from a photo which should then be

14.11.2018 (👁3995)

Get the Word Template in VSTO Addin of a new Document

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 Unfortunately you can only open docume

13.11.2018 (👁2815)

WPF Datagrid: Values in Column are not displayed

WPF Datagrid Column is not displayed Problem If you load a DataGrid with a data source in WPF and there is a column in the header of the tables Point in the end then column will be displayed but the values will not be loaded Solution Since data binding

13.11.2018 (👁4356)

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 of text a line break should be inserted and then a table should be inserted Solution Word C vba sLine End sLine Start sText Length sLine Select app Selection Select app Selection EndKey sLine InsertAfter n r app Select

12.11.2018 (👁4317)

Resolved: Error message when installing Windows software, untrusted certificate

Problem When installing a Windows application the following message appears saying that custom functions can not be used because of a certificate Error message User defined functions can not be used in this application because the certificate that signe

12.11.2018 (👁3156)

Word Addin: Insert photos after a picture mark into a table

the download is under codedocu com This Word addin inserts after the Bookmark Imaging a multi column table or inserts photos into a predefined target table By clicking on the button in menu add ins insert photos an empty table is inserted behind the se

10.11.2018 (👁2601)

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 sLine InsertAfter r r sLine Select app Selection EndKey app Selection Select Range newRange app Selection Range app ScreenRefresh

10.11.2018 (👁2268)

Turn off annoying notifications in Windows 10

Turn off annoying notifications How to turn off in Windows 10 annoying notifications from Google Chrome web pages A Switch off via System Settings Notification and Actions In Cortana Enter notification Then in the form Windows 10 System Settings Noti

08.11.2018 (👁1366)

Edit data in SQL query

Edit records in SQL Management Studio Data queries in Microsoft SQL Server Management Studio can only open and edit the first 200 records With a trick you can edit more records Subject SQL Server Management Studio SSMS SQL Server SQL Query Query Edit Top

08.11.2018 (👁1941)

Start Power BI Desktop Tutorial

Start Power BI Desktop The Microsoft Power BI Desktop is an application for Windows 10 with which one can create evaluations of databases Various databases are connected via an interface and then graphic and tabular evaluations are created via the data T

08.11.2018 (👁3417)

Installation of .NET Core 2.1 on a web server

Problem If you upload a new web page with Asp Net Core 2 1 to a web server and try to start it then first an error message 502 5 appears on the web server HTTP Error 502 5 Process Failure In the logs log files of the Asp Net Core 2 1 application you w

07.11.2018 (👁6788)

Asp.Net Core 2.1 Error: Publish prints too many files

Problem If you output an Asp Net Core 2 1 Web application with Publish project files and all library runtime files will be output Subject Upgrade Windows 10 update and Visual Studio 2017 to 2018 Q3 Description Since last week the Windows 10 Update 2018

07.11.2018 (👁10596)

Asp.Net Razor: Query website URL path

Asp Net Razor Query website How to query in Asp Net when calling a page where you are Task I would like to call the website page Edit that some HTML sections such as advertising are not displayed The Asp Net MVC Core Website Edit is saved as View Edit

06.11.2018 (👁2647)

Solved: Project file is incomplete. Expected imports are missing. .Net Core 2 Project

Solved Project file is incomplete Expected imports are missing Net Core 2 Project When opening the Project Solution sln file with a core project Windows 10 reports a fatal error The project file will not load at all As such the project or the project f

06.11.2018 (👁4604)

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 error message System Runtime InteropServices COMException HResult 0x800A03EC Message Ausnahme von HRESULT 0

03.11.2018 (👁4967)

Text input fields in Word with vba c #

This code example shows how to insert FormTextInput form fields in word The insertion takes place in the example at runtime programmatically A new form field is created via Word Range FormFields Add added FormField field act Image Range FormFields Ad

02.11.2018 (👁2562)

Create input fields in Word. C#, ContentControl

How do you add an input field from the developer tools in Word at runtime The real form fields in Word from the Developer Tools area are of type ContentControl These differ from the pure TextInputFields in that you can format the input fields and adjust

02.11.2018 (👁3161)

Protect Word programmatically

Word protection program in vba protect Protect Word documents at runtime Here in vba C interop macro Protect document For protection you can reduce the input to input fields with WdProtectionType wdAllowOnlyFormFields string sPassword Settings1 Defa

02.11.2018 (👁3165)

Protected entry form in Word

How can you protect an input document as a form in Word Solution You can protect documents in Word by clicking Word Menu Developer Protect Document Input fields may already be protected against removal in the input field settings But then the form ca

02.11.2018 (👁1597)

Input form in Word

This entry shows how to create an input form in MS Word containing several input fields The input fields are highlighted in green and become active as soon as you click on a field The input fields are simple text fields drop down selection fields or mu

02.11.2018 (👁2647)

Word Addin: Load Excel file into WPF DataGrid

The following code guide shows how to quickly load data from an Excel file into a WPF DataGrid as an overview in a Word add in The trick is that a Windows WPF Control is very fast and modern The code files in C XAML and Winforms can be embedded in your

31.10.2018 (👁9789)

WPF in Office Vsts applications

This code example shows how to include WPF controls and forms in a Word Office Ribbonbar Menu application A VSTO Addin for Word is created and then a WPF User Control is inserted into the project By changing the entry UserControl to Window the WPF Contr

31.10.2018 (👁4696)

C #: Converting a 2D Object Array to 2D String Array

Task This code example in C shows how to transform a two dimensional object array into a 2 dimensional string array The array consists of rows and columns which result from the Excel Used Range in Interop Excel This shows in C On the left the objects a

30.10.2018 (👁1788)

Solved: Reading Excel is very slow

Problem Slow Excel When reading Excel files from Word or other applications via the COM Interop access the read out is very slow It seems that every single evaluation of value or text from a cell takes so long Especially when using C Interop Visual S

30.10.2018 (👁10654)

Detailed photo and video comparison between Samsung S7 and LG V30 +

Detailed photo and video comparison between Samsung S7 and LG V30 In this photo comparison I compared the two smartphone cameras from Samsung and LG in photos and video recordings especially on snapshots snapshots small movements low light All photos are

29.10.2018 (👁2295)

LG PC Suite

With the LG PC Suite you can manage photos and videos on the local PC Windows 10 and 7 as an album and share with the photos on a connected Android phone save create a backup Unfortunately in my opinion the software is already quite old PC directory lis

29.10.2018 (👁1405)

Installing the USB driver for LG Smartphones, LG Universal Mobile Drivers

Where to find the drivers for LG phones https www lg com us support software firmware drivers Problem If you have problems with the connection of LG phones on the USB port to Windows 10 and Windows 7 PCs then you have to install separately on the Wind

29.10.2018 (👁2108)

Word Addin: Adds customer data from Excel file to Word file

Function The article describes how a Word Excel Data Addin works and contains the download of the word addin as a zip file At runtime the add in exchanges data fields in a Word file with data in an Excel file So it works like a data selector for Word fo

26.10.2018 (👁7075)

Saving Settings in Office Addin VSTO

How to save data in an Office Addin Task I want to store user specific data from an input field in a Word add in As soon as the user changes in the input field the value should be changed in the input field next time Solution Use a settings file You ad

26.10.2018 (👁4036)

Word: Loop through all the words in a Word document

How to examine a Word document for individual words This code snippet searches each word individually in a Word document The trick you go through Word Document Words as Range objects Subject Code example for C VSTO @Loop Words foreach Range word in d

26.10.2018 (👁1514)

C # Error: The runtime binding can not be executed for a NULL reference.

Error message The runtime binding can not be performed on a NULL reference C Erroneous code Excel Range cell usedRange Cells 1 iColumn as Excel Range String sValue cell Value2 ToString In VSTO Addin Excel When going through Excel cells Solution

25.10.2018 (👁2143)

Excel file in Windows DataGrid, DataGridView load with C # VSTO

This code example shows how to read an Excel Worksheet in an Excel VSTO Addin and transfer it into a data grid under Windows Forms or WPF Subject Addin VSTO WinForms DataGridView C VSTO C Code Example By clicking on the Ribbonbar Button Read Excel t

25.10.2018 (👁4610)

Example: Read Excel sheet and cells in C #

Code Example in C VSTO Addin This example shows how to read and evaluate C Excel cells Excel Here all cells of an Excel sheet are read and displayed as a message C code Under the file Ribbon1 cs Ribbonbar example First you have to integrate the Office

25.10.2018 (👁2957)

Excel C # Solved: Value The double type can not be implicitly converted to string.

Subject Reading Excel cells with C on Cell Value Cell Value2 and FormulaLocal Problem Reading Excel cells does not make Value2 available and FormulaLocal generates an error Error code and message 1 Cell Value Reading an Excel cell in C with Value or Va

25.10.2018 (👁2687)

Load data grid in C #. Example here in WinForms, VSTO add-in

How to fill a data grid in Windows at runtime in C Shown is a Word Add in which should display data from Excel and allow a selection In a Word addin as Ribbonbar additional elements are usually added as a Windows Forms element A DataGrid is also initial

24.10.2018 (👁4494)

exponent High number in Excel

Hochzahl is the character The key for is located to the left of the 1 and is simply clicked and then a space Example 2 4 Giga heart is the frequency for mobile phones 2 4 10 high 9 2 4 10 9 2 4 10 9 2 400 000 000 B3 C3 D3 Show formulas With FORMELT

22.10.2018 (👁1094)

Word Addin: Subject: Word addin for inserting images into a table

As Word 10 App Word Ribbonbar add in COM Installation vstop via setup exe Installation zip setup exe Installation is via the zip file with a setup exe The setup exe installs the Word app so that the tab Add in is then visible under the Word menu bar R

22.10.2018 (👁2215)

Word vba error: Can not address individual rows in this collection because the table contains vertically linked cells.

System Runtime InteropServices COMException HResult 0x800A1767 Message Es können keine individuellen Reihen in dieser Sammlung adressiert werden weil die Tabelle vertikal verbundene Zellen enthält Source Cannot evaluate the exception source StackTrace

22.10.2018 (👁1527)

Excel template: Calculation of all-inclusive hourly rates for freelancers.

Excel template Calculation of all inclusive hourly rates for freelancers For freelancers the question is always what is the all inclusive hourly rate in city x or y You just have to know how high the home office hourly rate is With a HomeOffice remote h

17.10.2018 (👁1463)

Calculation Hourly Rates Externally to HomeOffice

Task How much does the all in hourly rate at the customer site and this the hourly rate to the home office Solution Calculate the cost of vehicle travel time nights per week and divide the amount by the remaining working time at the customer Subject E

17.10.2018 (👁1621)

PDF Text Reader for Excel Word Access

The following COM Control application can be integrated into MS Office programs to import PDF documents as text You have to integrate the COM Control into the vba macro code and can then receive the text content of a PDF file by single call and then tran

11.10.2018 (👁3499)

Create C# COM Control for Office

This description shows how to create a COM Control and then use it in Microsoft Office The COM Control is created in C in Visual Studio The description contains the base code in C for creating a COM control The COM Control is created in this example o

10.10.2018 (👁5263)

Read text from PDF using iTextSharp

Under C you can create a complete PDF reader with just a few lines of code For this you can integrate the Nuget Package iTextSharp small Windows program with iTextSharp in C and WPF C wpf PDF Textreader With iTextSharp In this example the PDF documen

10.10.2018 (👁6084)

Send serial emails with Excel

Description With the following Excel file you can send emails as serial emails The file is for small circulars or manageable quantities up to 1000 emails per action It goes through a simple email address list and an email is sent to each email address in

09.10.2018 (👁7813)

Excel File Dialog

The following Excel macro code in vba creates a file dialog for an Excel file Several files can be selected and adopted as text Download The code template is available for download under Codedocu de as Excel sample file or The vba code sample can be co

09.10.2018 (👁1625)

Word: read text files with vba macro

This code sample uses Microsoft Word to read files into the Word document using a vba macro The import file is opened as TextStream and read in line by line This vba code has the advantage that you can filter or customize special text lines or areas duri

08.10.2018 (👁3830)

Align Android TextView with Table

This post shows how to align display elements in a cell to center in a table in a table If you first create a table in Android then the view elements within a cell are always displayed oriented only to the left side The reason for this is that an embedd

05.10.2018 (👁2155)

Android: Draw tables lines

How to create lines in a spreadsheet in Android Creating a spreadsheet in Android simply does not draw borders Tables in Android Tables in Android consist of a TableLayout and TableRows All cells are designed by the interior layout design In this cod

05.10.2018 (👁2444)

Android java: Code area // region - // endregion

How to create a code area in Android Solution With region code endregion Closed region area Region Color Picker Opened region end region area region Region Color Picker region Color Picker public void load Color Picker load Color Picker init Colors fr

04.10.2018 (👁1887)

Android RecyclerView: complete code sample

The Android RecyclerView is the successor of ListView as a list display item in Android Java To display a RecyclerView in an Android Activity page insert the RecycleView tag into the Activity xml and then create an adapter to load the RecyclerView eleme

02.10.2018 (👁3837)

Automatically create form letters from Excel with filter

This example shows how to create form letters in Word with little effort from Excel The raw address data are stored in Excel The data is filtered via a small Pivot and key then the filtered form letters are created Code vba Subject Excel Pivot Word Mail

02.10.2018 (👁4428)

Complete Tutorial: Android SQLite Database

02.10.2018 (👁1439)

Complete Tutorial: Android SQLite Database

02.10.2018 (👁1403)

SQLite Database in Android : Complede Code Example

SQLite example Contains the complete code for a SQLite application in Android Java The code example creates a SQLite database at runtime appends records modifies records deletes records and retrieves a complete list from a table The data will be display

02.10.2018 (👁8576)

Sqlite: change values of a recordset

Sqlite change values How can you change a record in SQLite In SQLite as with all SQL databases a record is changed using the UPDATE statement In the process a record is changed with UPDATE table SET target field new value In databases it is best to al

01.10.2018 (👁2777)

SQLite: Get new ID after Insert Add Command

SQLite new ID at Insert Add How do you get the new ID when inserting a record in SQLite Solution The return value of a Sqlite Insert statement always automatically returns the new ID of a table if there is an integer autoimcrement column In case of an e

01.10.2018 (👁3710)

Resolved: The command "adb" is either misspelled or could not be found.

Problem On Android Studio in Windows 10 the error message comes when using the Android Studio Terminal That the command adb can not be found Solution You have to enter the path to adb exe in the Windows 10 environment variables Error message in termina

28.09.2018 (👁3036)

Evaluate SQLite on Android App

How to view the tables and data of a SQLite database in an Android app at debug runtime You can follow the instructions below 1 Expand the project code in the file Gradle 2 Redirect terminal port 3 Output on Browser SQLLite tables 1 Android Gradle

28.09.2018 (👁3531)

Android: Create a simple color picker

Android simple color picker How to Create a Simple Color Picker in Android App I need a small color palette or selection of colors for an app which I can choose For this you can create a simple color picker Solution You store a string array of color val

28.09.2018 (👁2668)

Android: Create an input field with width and background at runtime

How can you create an input field at runtime in which the background is color coded and the width is set Solution Over for the background creates a drawable style This drawable is then assigned with EditView setBackground drawablename For the width you

27.09.2018 (👁2104)

Word: Form letter from pivot table

How to create a form letter in Word that contains the data from an Excel Pivot table Task customer I have a list of addresses that I have in Excel For easier filtering I changed the data to a pivot table Now I would like to create serial letters from th

27.09.2018 (👁2425)

Android Toolbar Show and hide

Show hide toolbar The toolbar can be turned on and off via the visibility attribute Unfortunately there is no expand hide button public void btnToolbar onClick View view btnToolbar onClick show or hide toolbar get toolbar Toolbar toolbar findView

26.09.2018 (👁2084)

Views:		Count
Self	20%	0
Your Content	60%	0

Users by Links		0
u¹*(Content+Views)	10%	0

Follow-Follower		0
s²*(Income)	5%	0

	Count
Followers	0