Free Code Snippets in C#, Net Framework, Office 365, ASP.Net,WPF, Visual Studio, SQL Server, Antivirus free
#
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 67
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 71
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 56
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 74
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 84
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 83
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 109
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 78
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 80
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 93
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 82
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 100
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 91
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 108
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 103
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 101
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 80
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 104
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 104
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 109
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 106
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 121
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 113
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)

Setup OneDrive Office-365/OneDrive-Cloud/setup-cloud
Setup OneDrive
01.02.2018 107
How to change the settings of Microsoft Office -> OneDrive cloud storage? To do this, open the File Explorer and right-click on the OneDrive folder Then select OneDrive-> Settings Then under Account: Add accoun

VBA function: Convert numbering to number Office-365/Access/Basics/vba-Code
VBA function: Convert numbering to number
29.01.2018 100
This vba code function converts a numbering such as 1 a or 1 1 or 1-a into a number with decimal places Task: If you want to arrange a table with a logical sort, you quickly get to the problem that the sorting is wrong For example, sortin

Access: Conditional formatting when another number field is empty or zero Office-365/Access/Controls/Basic-Controls
Access: Conditional formatting when another number field is empty or zero
27.01.2018 104
Task: How to enter an expression for conditional formatting, so that an adjacent number field with empty, no input or zero the actual input cell is highlighted in color Solution: As a condition you have to enter (in German): Expr

Access: Conditional formatting Expression for adjacent fields Office-365/Access/Controls/Basic-Controls
Access: Conditional formatting Expression for adjacent fields
27.01.2018 98
Highlight the control element and in ribbon menu-> format-> conditional formatting Comparison condition to a number Dialog: Manager for Bedintern Formatting Rules Open this with Edit rule Then com

Access vba: Create Numbering as default values Office-365/Access/Basics/vba-Code
Access vba: Create Numbering as default values
26.01.2018 115
Access vba: Create updating default values Task: In an input field, the default values for new lines should automatically correspond to a counter or consecutive numbering Solution: In Vba the entered value is determine

Ms Access: Set default value in vba Office-365/Access/Controls/Basic-Controls
Ms Access: Set default value in vba
26.01.2018 121
How to set the default value for a field in Access with Vba Basic? Task: if you enter a value in a field, then automatically after the input the new default value for the column should correspond to the new value Solution:

MS Access: Automatic updating of a dropdown list Office-365/Access/Controls/Combo-Box
MS Access: Automatic updating of a dropdown list
26.01.2018 124
Question: How to update a list box or drop-down list in Microsoft Access There is no Requery or Reload as a function Solution: You have to load the RowSource of the control again with yourself Example:

Mobile

.

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