Category: Microsoft Office

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…

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…

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…

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…

Continuare...
Posted in MS Excel

Calculation of work experience, using the DATEDIF function

If an employee record is required, Excel can be used for automatic calculation using the…

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…

Continuare...
Posted in Microsoft Office MS Excel

Conditional Formatting Depending on the Condition of a Column

Conditional formatting adds in the analysis of data from a spreadsheet. To apply a conditional…

Continuare...