MS Access

Posted in MS Access VBA

Decimal Truncation

In MS Access, there may be situations, more rarely, when you don’t want to round some numerical values…

Continuare...
Posted in MS Access VBA

Proper Text in MS Access

Excel has the default function Proper, which allows the ability to display only the first letter of a…

Continuare...
Posted in MS Access VBA

Calculating seniority up to a certain year

Let’s assume that knowing the date of employment, we would be interested in the seniority of employees (in…

Continuare...
Posted in MS Access VBA

Multiselect filtering in the form, using ListBox

Single Form To achieve the desire in the title it is required a table, a form and a…

Continuare...
Posted in MS Access VBA

Timed PopUp message in Ms Access

There are situations in which using certain actions need to display a message, but do not involve our…

Continuare...
Posted in MS Access VBA

Retrieving in a textbox, via VBA, a value calculated by an aggregate function

If it is necessary to display the result of a query that uses certain functions (SUM, AVERAGE, MIN,…

Continuare...