Freelance Project Requests info@CodeDocu.de Software Development in C# WPF Asp.Net Core Vba Excel Word SQL-Server EF Linq, UWP Net
#
Automatically adjust Access forms to the maximum monitor size Office-365/Access/Basics/vba-Code
Automatically adjust Access forms to the maximum monitor size
03.02.2020 5722
the following vba code example shows how to automatically customize Microsoft Access Database forms to the maximum width of the current monitor All controls such as text box or label elements are moved to the corresponding positions at run time and adjusted i

How To Hide the new Column in Microsoft Access Table Office-365/Access/Basics/Tables
How To Hide the new Column in Microsoft Access Table
04.12.2019 865
How to hide the [Add New Column] in Microsoft Access in the Table Design To do this in Menu->Options->Current Database The setting: Enable design changes for tables in datasheet view ->Turn off Then close and

MS Access: Connect tables to a new path Office-365/Access/Basics/Tables
MS Access: Connect tables to a new path
20.02.2018 1571
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 3892
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 2718
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 2117
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 10168
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 5295
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 2407
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 4401
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

Mobile

.

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