Microsoft Office
Automatic rounding for a range of cells
If it is desired that, in a sheet, numerical values be formatted and displayed by rounding with a…
Proper Text in MS Access
Excel has the default function Proper, which allows the ability to display only the first letter of a…
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…
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…
Timed PopUp message in Ms Access
There are situations in which using certain actions need to display a message, but do not involve our…
Calculation of work experience, using the DATEDIF function
If an employee record is required, Excel can be used for automatic calculation using the DATEDIF function. Obs:…
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,…
Conditional Formatting Depending on the Condition of a Column
Conditional formatting adds in the analysis of data from a spreadsheet. To apply a conditional formatting rule on…