CodeDocu.com

#

Access vba sevGrid Queries Basics Naming Forms Tables vba Code Recordset Fehler Errors Controls web Browser Listcontrol Option Box Combo Box Basic Controls Image Control Access-Excel Emails Ribbonbar Excel Code vba Makro Formulas Templates Emails Pivot Chart VSTO Addin Powerquery Tutorials Add-in Office Office develop COM Controls OneDrive Cloud Programming setup cloud Other Software Outlook Visio Word vba Errors Tutorials Macro Import Photos into Word Templates Ribbonbar Addin Add-In

Office-365/Excel/Add--in Addin: vba code 07.09.2018 39 Excel vba code for the add-in Function of the code 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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)