Author: Ovidiu.S

I am quite passionate about this professional area as if I know something - no matter how little - I want to share it with others.
Posted in MS Excel VBA

The lowest and highest value simultaneously formatted

If we have several intervals where we want to highlight, through conditional formatting, the lowest and the highest…

Continuare...
Posted in MS Word VBA

Remove own styles at once

Sometimes, if we have to format various retrieved documents, we may realize that the phrase “better to redo…

Continuare...
Posted in Excel Utilities

Alternative to inline chart

If the values are less than 100, it is possible to create a graph in the cell, by…

Continuare...
Posted in Excel Utilities

Format Cells Tricks

Hide cell text with Format Cells Select the cells containing the text to be hidden In the Format…

Continuare...
Posted in MySQL Utilities

Simple trigger examples

Triggers have the role of launching a certain action, in a given context (INSERT, UPDATE or DELETE), before or after these actions.

Continuare...
Posted in MS Word VBA

Letter spacing button

To be able to use it in all Word files, you can work directly in the normal.dotm template….

Continuare...
Posted in MS Excel VBA

Worksheet dynamization

I appreciate some features that I have used in specific applications where, for example, the width of a…

Continuare...
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 JS Utilities

Extract username from the content of the e-mail address

If, in a registration form, it is desired to extract the username from the e-mail address, in order…

Continuare...
Posted in MySQL Utilities

Get values for numeric conditional top

Assuming that there is a need to display, out of a number of about 30 records: the first…

Continuare...