by admin | Jul 7, 2011 | Excel, Programming Notes
RIGHT returns the last character or characters in a text string, based on the number of characters you specify.
Syntax
RIGHT(text,num_chars)
Where:
Text is the text string containing the characters you want to extract. Num_chars specifies the number of characters you want RIGHT to extract.
Remarks
Num_chars must be greater than or equal to zero.
If num_chars is greater than the length of text, RIGHT returns all of text.
If num_chars is omitted, it is assumed to be 1.
Do It!
1. Open Excel Application
2. In Cell A1, type: Sale Price
3. In Cell B1, type: =RIGHT(A1,5)
4. Hit Enter and you should have a result as: Price
Explanation
With the above example, you extracted a String Value from Cell A1 to include all the 5 characters starting from right. Thus, from the whole string “Sale Price”, you get “Price”.
by admin | May 19, 2011 | Access, Programming Notes
Scenario (Applies to Access 2003, 2007 and 2010)
There are two open forms, frmEmployees and frmTransactions. frmEmployees and frmTransactions are bound to tblEmployees and tblTransactions. They have a common field which is EmployeeID.
Task
Filter a record from frmEmployee where EmployeeID correspond on the selected row in frmTransactions.
Approach
On the Click Event of TransactionDetail field in frmTransactions, put this code:
Private Sub TransactionDetail_Click()
’ Find the record that matches the control.
Dim rs As Object
Set rs = Forms!frmEmployees.Recordset.Clone
rs.FindFirst “[ID] = ” & Nz(Me.EmployeeID, 0)
If Not rs.EOF Then Forms!frmEmployees.Bookmark = rs.Bookmark
End Sub
by admin | Apr 18, 2011 | Excel, Programming Notes
The LEFT function is helpful if you want to return the first character or characters in a text string from the left, based on the number of characters you specify.
Syntax
LEFT(text,num_chars)
Text is the text string that contains the characters you want to extract.
Num_chars specifies the number of characters you want LEFT to extract.
Num_chars must be greater than or equal to zero.
If num_chars is greater than the length of text, LEFT returns all of text.
If num_chars is omitted, it is assumed to be 1.
Example 1:
Data in A1: Sale Price
Formula: =LEFT(A1,4)
Result: Sale
Example 2:
Data in A2: Sweden
Formula: =LEFT(A2)
Result: S
by admin | Mar 21, 2011 | My Point, Soft Skills
Look around! Have a quick survey on the people you know who are successful on their career as your respondents. Make a quantitative comparison on how many are those who finished college and those who did not. I am quite sure that we will come up with a similar findings. Most of the people who are successful are those who undergone formal education.
There was once a wealthy family I knew who had 5 children and I was amazed that not even one of them get into college. Yes, they have farms, real states and businesses. This may the reason that they were not interested to go to school for they have already what they want. They are so practical on their decisions but still I believe that they missed the important stage on their formal education quest.
Going to school is not an assurance of having a good paying jobs. It doesn’t even make promises to an individual to become rich or powerful. But one thing for sure, it helps develop one’s personality and molds an individual to become a better person. Education widens one’s horizons to discover his/her potentials. It makes everyone smarter on decision making by applying the theories, principles and experiences he/she learnt in schools. Nevertheless, Education is still the best investment so far that everyone need to consider.
I would say, that if I will leave a legacy to my kids, it should be their professions on their chosen fields. Once they will get it, I am confident that they can stand by their own with firmness that they could not be easily topple down on whatever challenges they will meet ahead.
by admin | Mar 16, 2011 | My Point, Soft Skills
If you lead to achieve a purpose, don’t blame anybody if you fail. Instead, blame yourself for you are the one accountable for your actions.
People around are your best resources to achieve your goal. They are there to support and not to pin you down. And, if there are times your decisions/actions have been influenced by them that resulted to failure, don’t blame them for they are not doing those decisions on your behalf.
You lead . . . and it goes with it the accountability that whatever the result ahead – either success or failure – you need to be prepared to receive either a commendation or a blame.
