Freelance Project Requests info@CodeDocu.de Software Development in C# WPF Asp.Net Core Vba Excel Word SQL-Server EF Linq, UWP Net
#
Access: conversion of date into year-month-day Office-365/Access/Queries
Access: conversion of date into year-month-day
22.02.2018 392
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 340
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 646
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 490
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

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

Error Code 94: Invalid Use of Null Office-365/Access/Errors
Error Code 94: Invalid Use of Null
26.01.2018 750
This error occurs in Microsoft Office applications when in the vba code a variable has no value and should be transferred to another location In this example, if the variable varSTring was never used and therefore has the value zero, then it can not be appl

Access: Link texts with line breaks in Queries Office-365/Access/Queries
Access: Link texts with line breaks in Queries
23.01.2018 407
If you want to combine texts and fields in MS Access with a line break, then you have to insert the character for carriage return and line feed directly [Text1] & Chr(13) & Chr(10) & [Text2]

MS Access: export a query to Excel with Docmd.Output Office-365/Access/Access--Excel
MS Access: export a query to Excel with Docmd.Output
02.01.2018 1638
The example shows how to export an Access query to Excel The query contains current data from a table, which was filtered by a radio button For this you use the command Docmd OutputTo in Microsoft Access As

Send email from Excel and Access Office-365/Access/Controls
Send email from Excel and Access
22.11.2017 588
The example shows how to send an email directly in Microsoft Access, Excel or other MS Office programs Here you use the axEmail_Send component, which can send emails directly from the program The component is written in vb net Framework 4 6 and c

Access: Sending emails directly from the database Office-365/Access/Emails
Access: Sending emails directly from the database
10.10.2017 651
Included as Outlook Code example in vba Programming You can send emails directly into Microsoft Access databases All you need is an e-mail address, an e-mail subject and an e-mail For this, it is recommended to use

Export Access Table direct to Excel Office-365/Access/Access--Excel
Export Access Table direct to Excel
05.05.2017 693
This demo gives a table directly in Access to Excel Output large amounts of Access data to Excel using CopyFromRecordset? Task: • I want to output a large amount of data, about 3000 records directly to Excel In Access you can do this via TransferSpeadsheet, but I would lik

Access DB: Select record in subform Office-365/Access/vba
Access DB: Select record in subform
28.03.2017 946
How to set the current record in a MS Access data sheet as a subform to a specific position? Task: I want to set the data record in a subform to a specific position by using vba command

MS Access: Current user Office-365/Access/vba
MS Access: Current user
24.03.2017 781
How to determine the current user of the Microsoft Access database using vba code For this, there are 3 basic direct accesses with query of the Windows system When querying for information on Active Directory, it must also be activated See last code example) Lo

MS Access: Read and manage HTML document and elements with webbrowser Office-365/Access/Controls
MS Access: Read and manage HTML document and elements with webbrowser
14.02.2017 2648
MS Access: Read and manage HTML document and elements How to manage an HTML document in Microsoft Access? In Microsoft Access, you can include the Web browser Control in a form This allows you to navigate and read a web browser in the database to a web page

Access Error message: Missing reference to OWC10.DLL Office-365/Access/Errors
Access Error message: Missing reference to OWC10.DLL
13.02.2017 1122
Access Error message: Missing reference to OWC10 DLL Your Microsoft Access database or your project contains a missing or incorrect reference to the "OWC10 DLL" version 1 1 Applies to: Previous Microsoft Access databases with Internet Controls to publish databases

MS Access: Subquery Office-365/Access/Queries
MS Access: Subquery
06.02.2017 989
MS Access: Subquery A subquery is a query of data, whereby only the rows of a main query are accepted, in which an ID number of the main query also occurs in another table or query Sub-queries are quite complex and therefore have to be created partially in SQL as text direct

MS Access: Create a multiple query with multiple words Office-365/Access/Queries
MS Access: Create a multiple query with multiple words
03.02.2017 701
MS Access: Create a multiple query with multiple words How to create a query in Microsoft Access that filters any number of words The query should go through as one is accustomed by Google that every further word further restricts the existing filter So in princi

MS Access Error: The object does not contain the automation object Office-365/Access/Fehler
MS Access Error: The object does not contain the automation object
24.01.2017 2111
MS Access Error: The object does not contain the automation object When entering a new data record, the error is displayed: Error message: The LinkMasterFields property settings have caused this error: The object does not contain the automation object t

Access: Name Database Objects Correctly Office-365/Access/Basics
Access: Name Database Objects Correctly
23.01.2017 754
Access: database objects correctly If you work with databases, you should rightly name the objects of a database right from the beginning, so that the further development and expansion remain clear For this purpose, small abbreviations are used before the name of the object

Access: Evaluate and Show Values in the debugger Office-365/Access
Access: Evaluate and Show Values in the debugger
14.07.2016 1454
Access: Values in the debugger How can I display values of variables in debugger mode under Microsoft Access? Step 1: You go to the debug mode in a Microsoft Access database, if you press ALT-F11 on your keyboard to switch to the Visual Basic for applic

Access: Automatisierungsfehler -2147024894 Office-365/Access/vba
Access: Automatisierungsfehler -2147024894
03.02.2016 2116
Access: Automatisierungsfehler -2147024894 Betrifft: Microsoft Office, Access Excel Word Outlook Fehlermeldung : Error: Automatisierungsfehler Das System kann die angegebene Datei nicht finden Err Number = -2147024894 Der Fehler stellt sich in Mic

Access: Referenz zu SFTP Code Objekten Office-365/Access/vba
Access: Referenz zu SFTP Code Objekten
01.02.2016 1942
Access: Download sftp Files Referenz zu den Code-Beispielen für winSCP SFTP Programmierung in Office vba Sobald das Session Objekt erstellt ist kann man mit diesen Files downloaden und uploaden SFTP Session Objekt Download von Files

Access: SFTP using in MS Office vba Teil 2 Basic Office-365/Access/vba
Access: SFTP using in MS Office vba Teil 2 Basic
30.01.2016 1938
Access: SFTP using in MS Office vba Wenn man sftp in einer Microsoft Access oder Excel Anwendung einbinden möchte, dann muss man den Verweis in Visual Basic erstellen Hierzu muss man das Packet winscp576automation zip downloaden Diese erhält man im Lin

Access: SFTP Files downloaden, Teil 1 eigenständige Anwendung Office-365/Access/vba
Access: SFTP Files downloaden, Teil 1 eigenständige Anwendung
29.01.2016 3071
Access: SFTP Files downloaden, Teil 1 Ich benötige eine SFTP Verbindung zu einem SFTP Server in Microsoft Access Office 2016 um ein paar Dateien regelmäßig vom sftp Server zu holen und eine Rückmeldedatei hoch zuladen Leider geht der Zugriff mit Shell32 hierfür

Access: FTP auflisten, herunterladen und umbenennen Office-365/Access/vba
Access: FTP auflisten, herunterladen und umbenennen
29.01.2016 1718
Access: FTP List, Rename, Download In Microsoft Access Anwendungen kommt es immer wieder vor, dass man Dateien von einem entfernten FTP Server herunterladen muss um diese anschliessend In den Datenbestand zu integrieren Diese kleine Microsoft Access Demo zeigt wie man D

Access: FTP Funktionen verwenden Office-365/Access/vba
Access: FTP Funktionen verwenden
27.01.2016 1707
Access: FTP Zugriff Verwenden von FTP Funktionen in einer Microsoft Access Anwendung Ich benötige einen Zugriff auf einen FTP Server mit Microsoft Access und Office (Excel, Word) zum Austauschen von Dateien Leider gibt es kein integriertes Code-Modul oder Funktion in v

Access: Abfrage Parameter erstellen, eingeben und ausführen Office-365/Access/vba
Access: Abfrage Parameter erstellen, eingeben und ausführen
26.01.2016 4031
Access: Abfrage Parameter eingeben Ich möchte eine Abfrage ausführen, die nur bestimmte Daten verändert, abhängig von einem parameter-Wert, der bei der Ausführung eingegeben werden muss Solche Abfragen heißen Parameter Abfragen Man fügt

Access: Konstanten definieren Office-365/Access/vba
Access: Konstanten definieren
26.01.2016 1804
Access: Konstanten definieren Konstanten und Variablen, die für eine gesamte Code-Seite eines Formulars in Microsoft Access gelten und erreichbar sind, definiert man am Besten im oberen Bereich der Code-Seite Konstanten legt man einmalig mit Const an wie hier zu

Access: Laden einer Liste mit einzelnen Zeilen Office-365/Access/vba
Access: Laden einer Liste mit einzelnen Zeilen
21.01.2016 1799
Access: Laden einer Liste mit einzelnen Zeilen Access Liste mit einzelnen Werten laden: Listcontrols in Microsoft Access werden entweder datengebunden mit Tabellen geladen oder mit einzelnen Zeilen im Listmodus Hier wird gezeigt wie man ein Listen-Element im vba-Code

Access: Werte in Setting speichern und Lesen Office-365/Access/vba
Access: Werte in Setting speichern und Lesen
21.01.2016 1807
Access: Werte in Setting speichern und Lesen, Ini, Speicher Speichern von Werten in Setting In Microsoft Access kann man Werte für die Anwendung in den sogenannten Settings speichern Diese werden wie bei einer lokalen Ini-Datei auf dem aktuellen Computer gespe

Mobile

.

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