Self Confidence: the key of all Locks

In this age of competition a student has to be very intelligent right from his childhood. In addition to be good in his academics, he requires special skills to establish his identity in this vast unfamiliar land where he has to traverse along.

To endure this prolonged journey of life, one has to develop self-confidence from his infancy. There is a vast difference between confidence and self-confidence. The first lead to the victory on not always being right but also not getting fear to be wrong, and the second is the competence over the complex and dangerous deeds by winning self. Self- confidence is related to your self worth and your value. Confidence is a mental process that arises from considering the capacity, if a person or thing is capable of something. Self-confidence is having confidence in oneself considering a responsibility of commitment and result.

We can never predict what kind of life we are going to have or what circumstances can make us crippled. In order to overcome the unwanted hurdles of our life we need to develop strong self- confidence and clear vision. We should always rise with an appetite to know our inadequacies and zeal for problem solving. We are never born with confidence from our birth as it is well said, ?Rome was not built in one day?, and so is the confidence.

The very first step towards success is to stop obsessing about what others think of you. Avoid self-pity, or the pity and sympathy of others. Never allow others to make you feel inferior–they can only do so if you let them room for criticism. Who so ever had tried to do something different must have chased the hard road to toil and thus you can look more confident in long run. This will only be possible when we establish true self-confidence and must concentrate on small steps towards success and forget about the failures and the negatives in our life. So just chill yourself and sincerely target yourself towards destination and hold your head high and stand tall.

To build self confidence, we first need to be regular in our deeds and we should divide our tasks into small steps as in the story ?the hare and the tortoise? we all have seen how impossible mission was made possible by the tortoise; the steps were small but the theme was consistency.

The strongest single factor in prosperity of consciousness is self-evaluation: believing you can do it, believing you deserve it, believing you will get it. Self-confidence is the most important factor in our life. It can be multiplied by feeling good, taking responsibility and being accountable to failures. Today we all have made a veil around us and never try to look beyond it and unnecessarily pretend our self with false and negative images. We do generally show that we are over burdened with work and the rest are enjoying the gala days. We need to learn the acceptance of our duty and responsibility and rather than transferring it on the shoulder of others we start accepting to say, ?I am responsible ?.

The lamp of faith within us should always get the oil of consistency and there should be no dark clouds of disappointment. The major problem of our failure is that, we keep thinking what we have done is right and we don’t critically express ourselves, where we went wrong. If we really want to conquer diffidence, then we need to defeat greed, hatred and jealousy, as these evils never let us pursue right path in our life.

Everyone is born with strength and weaknesses. We can develop and excel our-self according to our environment and situation by sticking to our principles and we have to be generous enough to accept our failures positively and try to be adventurous enough to define our aim. Trust yourself, know yourself better than you think, stop thinking what is not with you and try chasing what is great in you that others don’t have. The day you start thinking so you’re moving towards creation of self-confidence.

If we look at some great men who achieved success in their life, it is their self-confidence, determination and consistency in their thoughts and achievements. A great man is great in himself and what is in him to be great is his self-confidence. Self ?confidence teaches us to dream and leads to attain the goal disregarding; the hurdles come across in our life.

Personalities like Mahatma Gandhi, Abraham Lincoln, Winston Churchill etc has great mission and it is their self-confidence helped to overcome the problems and attain what they wanted. However you are rich, intelligent and strong, without self-confident you will not cross the tunnel and perhaps you may stand where you stood.

Steps to master Self-Confidence.

?

Confidence, Locks, Self

Database data entry can be tedious at times. You can make your databases more user friendly if they have a way to select data to enter rather than typing in the same data over and over. Access provides a form control called a combo box to help with this task but it can lead to trouble. Also, if you find that the data is redundant, you will probably want to be able to sort on that field in the future for reporting. The combo box allows the user to select inputs from a preset location like a table, a list of values, or a preset query. This works well unless the option you want to enter is not in the preset data. Access will not let you put in a new value unless you set the Limit to List option to No. Then, users are allowed to put in any data without checks. This can be troublesome. The value of having the combo box can be quickly diminished if users are misspelling data as they enter it or using different data to mean the same thing. This is very easily seen as you can define the United States as US, USA, United States, United States of America all meaning the same thing. Subsequent reporting would be inaccurate with misspelled input and dissimilar input for the same field.

To over come that problem, it would be handy to have code that asks the user to confirm a new entry into the table before they go ahead, just to make sure they entered what they meant to. This example shows you how to accomplish this with what I call a self learning combo box. Meaning, it learns new entries and adds them to the list of preset values, but requests a confirmation from the user if the entry is not already in the table. Use the following to create a simple form to demonstrate the self learning combo box and make it a feature you give your users in the future.

Create a new database and do the following steps:

Set references by adding the Microsoft DAO 3.6 Object Library to the current checked list. Do this by opening the VBA editor and clicking on Tools/References then checking the library from the list.

Create a table named contacts with these fields.

ConId as autonumber set as the primary key field

ConName as text

ConType as text

Fill in a line or two of test data before going on to the next step.

Design a very simple form for the example with one text box and two combo box controls on it.

Set the form?s data source to contacts

Set the control source for the text box as ConName and name it ConName on the Other Tab

Set the control source for the first combo box as ConType and name it xType

Set the Row Source to SELECT Contacts.ConType FROM Contacts GROUP BY Contacts.ConType;

Set the control source for the second combo box to ConType and name it Type

You can do this later if you want, but you can set the Format control for Visible to No for this combo box.

In Design View of the Form cut and copy in the following Form Code

Option Compare Database

Private Sub Type_NotInList(NewData As String, Response As Integer)

Me.Type.LimitToList = False

End Sub

Private Sub xType_AfterUpdate()

Dim Resp

MiSQL = “SELECT ConTypes.ConTypes FROM ConTypes WHERE (((ConTypes.ConTypes)=’” & xType & “‘));”

GetMiRSet ? calls the function GetMiRSet from a module

If MiRec.RecordCount = 0 Then

Resp = MsgBox(“The Type entered ‘” & xType & “‘ is not in list. Do you wish to add? Press OK or CANCEL..”, vbOKCancel, xType & ” Not On List”)

If Resp = 1 Then

MiSQL = “INSERT INTO ConTypes ( ConTypes ) SELECT ‘” & xType & “‘ AS x1;”

PutMiRSet ?calls the function PutMiRSet from a module

MiSQL = “SELECT ConTypes.ConTypes FROM ConTypes WHERE (((ConTypes.ConTypes)=’” & xType & “‘));”

GetMiRSet

Me.Type.Requery

Me.Type = MiRec!ConTypes

Form.Refresh

Else

xType = Null

End If

Else

Me.Type = MiRec!ConTypes

Form.Refresh

End If

End Sub

Now close the form and save it.

Next you will create a handy new module you can use in any database to save a little work.

This code is handy in Access because it makes it a little quicker to work with Recordsets by predefining command options ahead of time. Using this module you can simply call GetMiRSet when you want data from a table and PutMiRSet when you want to put data into a table with VBA. The required input for both functions is the SQL string defined as MiSQL. It is needed to define the data set you want to use in the format like the following:

MiSQL = “INSERT INTO ConTacts( ConType ) SELECT ‘” & xType & “‘ AS x1;”

You should see a line similar to this in the above list of commands.

Hint: Use the New Query function to create your SQL statements. After you have designed them in Design View, change to SQL view and you will see the SQL string. Copy this and place it into the VBA editor to save some time. You may have to make some modification to the SQL string you copy after you put it into your VBA code on the form. Like in our example, you can see where we are using the xType control name like a variable in the string. You can?t do this inside the string quotes so you have to concatenate two strings together with the & symbol. Also, in this sql string, xType is a string, so if you want to put it into the statement, like all strings, it has to be inside quotes. But, since the string is in a string, use single quotes. It will help to put a debug.print MiSQL statement after this line to see how Access is going to interpret the string.

Now create a New Module and put the following lines into it and save it under any name.

Option Compare Database

Option Explicit

Public MiSQL As String, Midb As Database, MiRec As DAO.Recordset, MiRec2 As DAO.Recordset

Public Function GetMiRSet()

Set Midb = CurrentDb()

Set MiRec = Midb.OpenRecordset(MiSQL, dbOpenDynaset)

End Function

Public Function GetMiRSet2()

Set Midb = CurrentDb()

Set MiRec2 = Midb.OpenRecordset(MiSQL, dbOpenDynaset)

End Function

Public Function PutMiRSet()

Dim Midb As Database ‘, MiRec As DAO.Recordset

Set Midb = CurrentDb()

Midb.Execute MiSQL

End Function

You are done. Go back to the form and give it a try. Enter a new value in the text box and then enter a new value in the first combo box and you should get a message box asking you to confirm the entry.

You can find a working example database at http://www.biomationsystems.com/AccessTips.htm

Access, Combo, Learning, Self

Security is a major concern for most people when selecting a self storage unit. Since you will not be on the premises to keep an eye on your belongings, you want to make sure the facility has enough security measures in place to deter any possible thieves or vandals. Controlled access self storage facilities greatly reduce the risk of break-ins by restricting the public’s access to the rental units. The drawback to using a controlled access storage rental instead of a self access rental is that you will also be restricted in your ability to open your storage unit.

Controlled access facilities generally use an access gate with a keypad to prevent unauthorized entry to the storage unit area. Access control systems can be integrated with the management software, sometimes referred to as accounting software. This integration allows for a single point of entry for customer information. When you “move in” the customer in the management software, the information is automatically transmitted to the access control system, setting the customer code and allowing access to the facility. If the customer becomes delinquent or past due, the management software automatically notifies the access control program and the guilty tenants are automatically locked out. This feature increases your opportunity to collect the past due rent, helping to prevent customer move-outs, especially after the office has closed.

Other common control systems include fingerprint readers or access cards given to renters, similar to the system used for hotel keys. These electronic forms of access control allow the facility manager to permit certain tenants to enter the property at different hours. This may be a popular option for business clients using the property for file storage. To request this after-hours access, you may be required to submit to more in-depth background check procedures.

For even more security, door alarms can also be installed on the door of each storage unit. One new option in door alarms is using an innovative latch and switch setup. This can be mounted on the door rail and will detect the latch as it passes by the switch. This provides a number of benefits over the traditional track mounted alarm. It is obviously more secure and harder to break into, but also will eliminate many of the common false alarms that are triggered with the standard model. The latch and switch alarms are also much easier to install and can be more economical for the storage facility owner when labor time is considered over all of the property’s rental units.

These individual alarms on the storage units can be used to protect customers from theft by other authorized renters at the facility. When a customer uses the keypad to enter the facility, their specific alarm is turned off or disarmed. When they leave the premises, the computer system would reset the alarm on the door of their storage unit. Individual door alarms prevent the unauthorized entry into specific storage units. This occurs when a legitimate customer enters their PIN on the access gate’s keypad. Then they loiter around the premises cutting locks on other people’s units and moving the selected items to their rented space. The door alarm on each unit would track the unauthorized entry and the opening and closing of the door, making it easy to locate the thief and identify them personally.

Controlled access storage may not be the best for you if you need to allow several family members to open your storage unit. Check with the facility manager as every storage company will have a different policy on who can have access to your stored items. Some facilities will allow any one who has your key and code to have access to your storage unit. Others have more strict procedures and may require advance notice if you are sending some one else to access your unit. You may even have to give written consent, and your representative may have to show identification before being allowed to enter your storage unit.

Most controlled access self storage facilities have some sort of camera surveillance setup. A video surveillance system can also go a long way in protecting your long-term storage rental unit. Even with an on-site residential manager, it is impossible to watch every area of the property at once. A good system of cameras can make it easy for the manager to scan the entire premises by glancing at a set of monitors. Video surveillance may also be a deterrent for potential crimes if its presence is announced by signs on premises.

Access, Advice, Between, Choosing, Controlled, Rental, Self, Storage