Datagrid,listbox,combobox,label,button have refresh methodand textbox has clear methodalmost all controls have refresh method Read More

MsgBox is a built in VB function which displays a Message Box and MsgBoxQ is a function defined by the user. Read More

MultiLine Property No limits Read More

Microsoft Visual basic has its host of problems one such being macros, Macros can be created which can create a havoc for a programmer with good intentions. Also the security issue rests in the hands of the user and not the programmer as such. A... Read More

A computer registry can be used to store configuration settings and application initialization. We can use Getsetting function to read registry settings and save settings function to write registry settings. Application name, section, key, setting,... Read More

VBA is licensed to Microsoft and this compatible with and only Microsoft products. Code written is compiled by an intermediate language called P-code and this is stored in hosting applications such as Excel, Word and Access. The intermediate code is... Read More

To register component use run command prompt type: c: regsvr32 nameofcomp Read More

1. Datagrid is Editable, flexgrid is Diplay only. 2. DBGrid allows full data binding while MSFlexGrid allows read-only binding 3. MSFlex grid is smaller and allows cell merging while Datagrid is larger and does not allow cell merging Read More

Type libraries are files that explicitly describe some or all of the contents of components. This includes information about the methods, properties, constants, and other members exposed by the component. Development tools such as Visual Basic make... Read More

If database calls are made within the context of a transaction, aborting the transaction will undo and changes that occur within that transaction. This removes the possibility of stranded or partial data. Read More

Visual basic is useful if you are planning to develop your programs from scratch. This language helps you in developing Active x controls, exe files, etc. Visual script is a powerful tool, through which you can create small scale applications on... Read More

Most of the visual basic applications are available on 32 bit Intel platforms. These applications also run on many of the windows software systems such as server 2003, XP, Vista, etc. Read More

Visual basic applications have very rich and flexible applications but there is one limitation when using pointer function. Windows API has limited support for function pointers because it has the ability to use but not the functional support to call... Read More

Data validation is an important concept in VBA. Application procedure and a custom dialog box can be used to correct input errors. You can assign an application procedure to the frame of a dialog box. Error message or custom dialog box can be... Read More

If you pass an argument by reference when calling a procedure, the procedure access to the actual variable in memory. As a result, the variable's value can be changed by the procedure. If you pass an argument by value when calling a procedure,... Read More

Option Explicit makes the declaration of Variables Mandatory Read More

The ADO objects are: ? Command ? Connection ? Error ? Field ? Parameter ? Property ? Record ? RecordSet ? Stream Read More

set cancel property to true Ex: button1.cancel = true Read More

Name property cannot set at run time Read More

strech Read More

VB do supports oops. Polymorphism - Yes , Encapsulation -Yes, Inheritance - NO Read More

Advantages of ActiveX Dll 1) An in-process component shares its client?s address space, so property and method calls don?t have to be marshaled. This results in much faster performance. Disadvantages of ActiveX Dll 1) If an unhandled error... Read More

OLE is the control used to call a windows application. Read More

when we initialize the form at that time if we want to set any variable's value then we can set it by defining in constructor. constructor 's name always same as class name.and destructor is used to recover memory occupied by any variable... Read More

Use KeyAscii and trap enter(32). Read More

DTPicker Read More

setabort and setcomplete Read More

No compatibility - creates new GUIDproject compatibility binary compatibility - maintains the references Read More

Cursor types:1. Forwardonly, 2. Static, 3. Keyset 4. Dyanmic Lock types : 1. lockpessimistic, 2. lockoptimistic,3. lockbatchoptimistic 4. lockreadonly Read More

Microsoft holds license for Visual basic applications and it has been developing that language. Visual basic applications have an embedded programming environment which assists programmers in developing custom solutions by using almost all features... Read More

COM add-ins are software program`s which are integrated into an application and they add already built in features to an existing application. They have common architecture across multiple applications which help in deploying applications much faster... Read More

Line explicit function makes the compiler to identify all the variables which are not specified by the dim statement. This command significantly reduces the problem of type errors. This is used extensively because VBA deals with information rich... Read More

The reasons which made Microsoft drop its support to VBA are as follows, Microsoft visual basic relies heavily on machine code which was written for Power PC architecture. Also it would take another two years for developing VBA support for its... Read More

Format functions can be used to format many of the expressions such as currency, time, date, percentages and numbers. These functions are much simpler to use in VBA. User defined date, numeric and string formats are present in many of the... Read More

Userforms should be used for complex user input. When an application input has non text as an input it is advisable to use Userforms rather than the input boxes. When you are using Userforms a user can give input any number of times which is not the... Read More

The chief use of VBA is to make use of its special function which helps in repeated actions. Goal seek function helps to reduce manual entry of the code each and every time. This solves the problem of repeated function entry by automating functions... Read More

Shell command present in VBA can be used to start the dialer present in windows operating system. Phone number can be used to connect to your modem. With the use of shell and sendkeys you can dial to your user. Shell starts windows application and... Read More

The Controls which do not have Align property can't be placed on MDI Form. E.g., Picturebox only has Align property in Standard Components of VB other controls dont have align property an hence can't be drawn on MDI Form. Read More

Visual basic can be used within almost all Microsoft products such as Map point, Visio, Auto cad, Word perfect, ArcGIS, word, excel, etc. With VBA you can control many functions such as host application, menus, toolbars, user interface, import and... Read More