Free Code Snippets in C#, Net Framework, Office 365, ASP.Net,WPF, Visual Studio, SQL Server, Antivirus free
#
Addin: vba code Office-365/Excel/Add--in
Addin: vba code
07.09.2018 39
Excel vba code for the add-in Function of the code

Exel file with system addin as Template Office-365/Excel/Add--in
Exel file with system addin as Template
07.09.2018 40
This article discusses an Excel help tool that allows you to create simple Excel input forms The Excel file has green input fields, which should serve as input navigation as with the tax office All other areas are automatically locked by the Excel add-in

Excel Addin: Creating a Ribbonbar Buttons for a vba Excel Addin Office-365/Excel/VSTO-Addin
Excel Addin: Creating a Ribbonbar Buttons for a vba Excel Addin
06.09.2018 35
Excel Addin: Creating a Ribbonbar Buttons for a vba Excel Addin How to create a button in Excel's Ribbonbar from the vba code in an Excel Addin Task: For an existing Excel Addin, a button should be created, which is generally used in the toolbar or Ribbonbar of Exce

Remove custom toolbars Office-365/Excel/VSTO-Addin
Remove custom toolbars
06.09.2018 37
Remove custom toolbars How to remove the custom toolbars in VSTO Addins? Problem: If I create an addin for Excel in Visual Studio under Vsto Office, then in 2016 the new Ribbon will show the area "Custom Toolbars" in front of the actual Ribbonbar areas an old problem

Excel Template: Automatically send an e-mail for a specific entry in Excel Office-365/Excel/Code-vba-Makro
Excel Template: Automatically send an e-mail for a specific entry in Excel
05.09.2018 65
Excel Template: Automatically send an e-mail for a specific entry in Excel The following Excel document automatically sends an email when a specific value is entered in an input area If a value such as Test is entered in the input column B: B, then a standard email is

Excel vba: recognize an input in cells Office-365/Excel/Code-vba-Makro
Excel vba: recognize an input in cells
05.09.2018 38
Excel vba: recognize an input in cells How to monitor the input in an excel sheet when changing a cell in a specific area solution You can examine the Worksheet Change on Target Range in Excel

Photo documentaion in Word Office-365/Word/Macro/Import-Photos-into-Word
Photo documentaion in Word
27.08.2018 107
Word Template for Download Multithreaded Word template for creating a photo documentaion for fire protection, real estate, appraiser, appraiser In the first column is a sequence number un the photo name, in the second column is the photo All further col

Upload and view files with jQuery ajax, FileUpload, View the jsonResults Net-Framework/ASP_dot_Net-Core/jQuery
Upload and view files with jQuery ajax, FileUpload, View the jsonResults
17.03.2018 773
This example shows how to upload photos from the browser to a server and display the results The file upload takes place as ajax and the results are inserted as json with jQuery in HTML Upload photos and ads in HTML With the click on t

Send emails from Excel with Outlook Office-365/Excel/Templates/Emails
Send emails from Excel with Outlook
14.03.2018 899
This application shows how to send emails via Outlook automatically with Excel Example: The Excel file has a list of emails where you can set an X to the email addresses to which an automated email is to be sent out of Excel The sent emails are

C #: Check for Contains string without Case of Letters /
C #: Check for Contains string without Case of Letters
08.03.2018 245
C #: Check for Contains string without a large scale How do you check a C # string for a substring? The capitalization and lower case should not play a role here Solution: With IndexOf and the text comparison * IgnoreCase it is checked, whet

Word Automatic Photo Documentation Template 1 Column 2 Photos with Numbers Office-365/Word/Macro/Import-Photos-into-Word
Word Automatic Photo Documentation Template 1 Column 2 Photos with Numbers
28.02.2018 356
Word Automatic Photo Documentation Template This Word template creates a photo documentation The photos can be selected with a file dialog and then the photos are inserted with a width of 17 centimeters An invisible table is filled with 1 column and 2 photos per pa

Access: conversion of date into year-month-day Office-365/Access/Queries
Access: conversion of date into year-month-day
22.02.2018 279
How to split a date field into year-month-day? For a structured representation with a date-time field, it makes sense to divide the date into sections These can then be used more easily in evaluations and Excel editions

Access: Format Date as Short Date Office-365/Access/Queries
Access: Format Date as Short Date
22.02.2018 249
I want to convert a long date of the database from the original date to the time in the view to a pure date solution Formatting with "Short Date" dtSearch: Format ([dtResult]; "Short Date") In the q

Access: Filedialog in vba Office-365/Access/vba
Access: Filedialog in vba
21.02.2018 480
The following vba code shows how to create a file dialog in Microsoft Access and evaluate the selected files Filedialog in MS Access The file dialog will appear as shown here You can select files after opening and accept them with the

Access: Find Icons ID for the Ribbonbar Office-365/Access/Ribbonbar
Access: Find Icons ID for the Ribbonbar
21.02.2018 340
Access: Find a list of all icons and buttons in the Ribbonbar How to find the internal ID terms for items in the Office Ribbonbar? It is always difficult to find the labels Ribbonbar items in Microsoft Office Access, if you want to create a custom menu bar

MS Access: Connect tables to a new path Office-365/Access/Basics/Tables
MS Access: Connect tables to a new path
20.02.2018 264
The following application uses Microsoft Access vba to bind the tables to an Access database to a new path It is often the case that you want to connect the tables of an Access frontend to the same path of a data file in the same directory For this you go t

Access: insert special characters in vba Office-365/Access/Basics/vba-Code
Access: insert special characters in vba
17.02.2018 454
Task I want to write a character on a button, which is not visible in Ascii These are the special characters of the Segoe UI MDL2 character set You can select and copy the characters directly in the special characters table and paste them directly into the t

Access: sorting a form set in vba Office-365/Access/Basics/Forms
Access: sorting a form set in vba
17.02.2018 298
The sorting in a form is set with Formular OrderBy The fields must be written in [square brackets] Square brackets in Ms Access mean field names of tables or recordsets Sometimes it should be optimal to set the formname also in brackets Form without s

Access: Copy Current Record to vba Office-365/Access/Basics/Recordset
Access: Copy Current Record to vba
17.02.2018 331
The following vba code transfers the current record with all fields in MS Access A copy of the record is created as a recordsetclone and then the individual fields are transferred directly to the copy in the code The advantage is that the field values can be adjust

Access: Delete record in form without message Office-365/Access/Basics/Forms
Access: Delete record in form without message
17.02.2018 297
How to delete a record in the open form in MS Access? Solution: The current Record record in an Acces form can be executed with a RunCommand Here to in vba the command

Access: Sort and Filter Recordset and Recordsetclone Office-365/Access/Basics/Recordset
Access: Sort and Filter Recordset and Recordsetclone
16.02.2018 436
This vba code example shows how to reorder a form in vba with a serial number When modifying the sort number lfdNr, a copy of the form's recordset is pulled in the background with vba code The copy is copied to a recordsetclone, sorted, and filter

Access: RecordsetClone Office-365/Access/Basics/Recordset
Access: RecordsetClone
16.02.2018 346
This example shows how to iterate through a recordsetclone of Access A recordsetclone in MS Access is a copy of the currently displayed records If you create a clone copy of the records, you do not have to reload them from the table This

Access: Open Form with OpenArgs Office-365/Access/Basics/Forms
Access: Open Form with OpenArgs
14.02.2018 405
Task: When opening a form, a value should be passed as start parameter Solution: Microsoft Access forms can be passed in parameters when opened The parameter is named OpenArgs in the vba parameters Set OpenArgs in VBA

Access: How to remove the tab tabs? Office-365/Access/Basics/Forms
Access: How to remove the tab tabs?
14.02.2018 246
Is there a way to remove or hide tabs in Microsoft Access? Solution: Under File-> Options-> Dialog: Access Options In the section: Current database Then-> Uncheck: Show Document Tabs Just switch off

Word Template: Attaching various photos and data from an Excel file Office-365/Word/Tutorials
Word Template: Attaching various photos and data from an Excel file
12.02.2018 286
Task: This template shows how to dynamically swap images and photos in Word and how to use data from an Excel file as a merge document It does not use the mail merge manager, but executes the functions in vba code Procedure: Th

Word no longer displays the top and bottom margins. Office-365/Word/Tutorials
Word no longer displays the top and bottom margins.
12.02.2018 247
The top and bottom margins are not displayed Solution: Microsoft Word in Office 365, Office 16: Under Menubar-> Ribbonbar-> Layout -> Margins or Format Page Setup-> Paper area Then below on prin

Access: load photos Office-365/Access/Controls/Image-Control
Access: load photos
07.02.2018 253
How to display photos and pictures in Microsoft Access database? To do this, you just have to insert an Access image control into the Access database and enter the path under Control content In vba at runtime

Access Error: This record has been modified by another user since editing began. Office-365/Access/Errors
Access Error: This record has been modified by another user since editing began.
06.02.2018 393
Access Error: This record has been modified by another user since editing began Error: This record has been modified by another user since editing began If you save the record, you will overwrite the other user's changes Copying your

Photo Template 4-Columns Office-365/Word/Macro/Import-Photos-into-Word
Photo Template 4-Columns
02.02.2018 329
With automatic file selection of multiple photos and auto-cropping to the appropriate width In addition, all photos are saved in a small thumbnail format, which makes the Word file manageable small Corrected: older versions of Word did not put the photo in th

Access crash when closing a window. Office-365/Access/Basics/Forms
Access crash when closing a window.
01.02.2018 271
My MS Access application crashes often at the customer, and always when an input window is closed and the page back to the overview Subject: Microsoft Access Office 365 Crash when closing the window (other tab)

Mobile

.

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