Free Code Snippets in C#, Net Framework, Office 365, ASP.Net,WPF, Visual Studio, SQL Server, Antivirus free
#
MS Access: Connect tables to a new path Office-365/Access/Basics/Tables
MS Access: Connect tables to a new path
20.02.2018 183
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 276
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 203
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 219
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 208
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 305
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 235
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 239
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 179
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

Access crash when closing a window. Office-365/Access/Basics/Forms
Access crash when closing a window.
01.02.2018 196
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)

VBA function: Convert numbering to number Office-365/Access/Basics/vba-Code
VBA function: Convert numbering to number
29.01.2018 235
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 vba: Create Numbering as default values Office-365/Access/Basics/vba-Code
Access vba: Create Numbering as default values
26.01.2018 224
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

Vba: Option Explicit Office-365/Access/Basics/vba-Code
Vba: Option Explicit
02.01.2018 251
Using Option Explicit If you program vba in Microsoft Office application, then you should always use the line in the vba code page Option Expl

Access: Run Cyclise timer event Office-365/Access/Basics/Forms
Access: Run Cyclise timer event
05.12.2017 235
A function in Microsoft Access repeatedly runs after a timer I want a function to be executed every second in my Microsoft Access form To do this, first enter a value in milliseconds in an Access Form -> Property Sheet

VBA: Option Explicit Office-365/Access/Basics/vba-Code
VBA: Option Explicit
16.02.2017 474
VBA: Option Explicit If you are programming in Microsoft MS Access or Excel, you should add a small line of code in the top line

MS Access: Display value from a table in a field Office-365/Access/Basics/Forms
MS Access: Display value from a table in a field
16.02.2017 389
MS Access: Display value from a table in a field I want to directly display a matching value in an MS Access form field Subfield-> Assets-> Data-> Control content Enter the formula: = DFirst ([TablesField], [Table], [Criterion])

MS Access: Reconnect Tables automatically to Data database-Container Office-365/Access/Basics/Tables
MS Access: Reconnect Tables automatically to Data database-Container
02.02.2017 761
MS Access: Tables automatically connect to data database Task: This example shows how to automatically connect tables to an Access data container in Microsoft Access Why Splitting and Connecting: In MS Access, the data is often separated from the frontend

MS Access Error message: You can not make a change to the primary key Office-365/Access/Basics/Tables
MS Access Error message: You can not make a change to the primary key
24.01.2017 557
MS Access Error message: You can not make a change to the primary key This table is the master table (table on the 1-page) of one or more relationships If you want to change and delete the primary key, first delete the relationships in the Relationships window

MS Access: Rebuild bad structures Office-365/Access/Basics/Tables
MS Access: Rebuild bad structures
24.01.2017 545
MS Access: Rebuild bad structures Anyone starting with databases often uses incorrect data structures at the beginning Basically, you have to pay attention to the fact that as much data as possible is to be kept granular, that is to say divided into small data units as far

MS Access: Filter in the form header area Office-365/Access/Basics/Forms
MS Access: Filter in the form header area
23.01.2017 567
Access: Filter in the form header area Structure of an Access input form Access form should be structured in such a way that selection and filter elements are in the so-called form head area and all fields into which data is entered and changed should be in the large cent

MS Access: record and navigation Office-365/Access/Basics/Forms
MS Access: record and navigation
23.01.2017 420
MS Access: record and navigation Record marker On the left bar of an Access form are a small character representing the current record For a single form with only one record, the record marker should be disabled Navigation buttons Belo

Access: Partitioning data tables into areas Office-365/Access/Basics/Naming
Access: Partitioning data tables into areas
23.01.2017 490
Access: Group data tables into areas If you work with data in a database, you should divide it into 3 areas 1) _ Motion data 2) Base master data 3) Sys system data Movement data: Motion data in a database proj

Access: Name Database Objects Correctly Office-365/Access/Basics
Access: Name Database Objects Correctly
23.01.2017 633
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

Wo findet man die Einstellungen für die Ribbonbar in Microsoft Access Office-365/Access/Basics
Wo findet man die Einstellungen für die Ribbonbar in Microsoft Access
24.03.2015 3384
Wo findet man die Einstellungen für die Ribbonbar in Microsoft Access Die Einstellungen zur einer eigenen Ribbonbar findet man in einer Systemtabelle Tabelle mit dem Namen USysRibbon Diese Tabelle ist ausgeblendet , weshalb man sie zur Entwicklu

Wo findet man die IRibbonUI Office-365/Access/Basics
Wo findet man die IRibbonUI
24.03.2015 1892
Wo findet man die IRibbonUI In meinem Projekt wird beim Kompilieren die IRibbonUI als Fehler erkannt Wo findet man die IRibbonUI objRibbon As IRibbonUI IRibbonUI Object

Wie erstellt man in Access eine Liste die sich während einer Filter-eingabe anpasst Office-365/Access/Basics
Wie erstellt man in Access eine Liste die sich während einer Filter-eingabe anpasst
24.03.2015 3359
Wie erstellt man in Access eine Liste die sich während einer Filtereingabe anpasst Ich möchte eine Liste verwenden, die die Ergebnisse automatisch filtert während ich Werte in einem Suche Feld eingebe Wenn das Filterfeld leer ist, soll die volle Lis

Wie blendet man in einem Access Formular den Formularkopf oder Fuß ein? Office-365/Access/Basics
Wie blendet man in einem Access Formular den Formularkopf oder Fuß ein?
23.03.2015 2528
Das hört sich einfacher als gedacht… irgendwo muß man doch die Eigenschaft finden zum An- oder Ausschalten der Die Anzeigebereiche in einem Access-Formular haben eine einfache Funktionslogik Der Formularkopf und Formularfuß wird angezeigt währe

Höhe automatisch einstellen Office-365/Access/Basics
Höhe automatisch einstellen
23.03.2015 3500
Wie erstellt man ein Element Control Rechteck, das immer so groß ist wie das Fenster Ich benötige ein Hintergrund-Element, das immer so groß ist wie das Fenster Hierzu muß man in den Form Open() Event die Height des Controls anpassen

Wie kann man die neue Spalte zum Hinzufügen klicken ausblenden Office-365/Access/Basics
Wie kann man die neue Spalte zum Hinzufügen klicken ausblenden
23.03.2015 3513
Wie kann man die neue Spalte "zum Hinzufügen klicken" ausblenden Problem: bei Microsoft Access wird bei neuen Tabellen immer hinter der letzten Spalte eine Neu-Spalte angezeigt, um eine zusätzliche Spalte automatisch zu erzeugen Wie blendet man diese Spalte aus, wenn man

Access Buttons in Farbe und Form gestalten Office-365/Access/Basics
Access Buttons in Farbe und Form gestalten
23.03.2015 1880
Farbe und Form von Buttons in Microsoft Access gestalten Gezeigt mit Access 2013, gilt für Access 2007, 2010, 2013 Hier eine kurze praktische Anleitung unter Youtube wie das Gestalten geht

Mobile

.

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