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 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

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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) 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 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 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 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 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 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: 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: