The ADO objects are:
Connection: Used to make a connection between your app and an external data source, i.e., sql server. Command: Used to build queries, including user-specific parameters, to access records from a data source (which are returned in a Recordset) Recordset: Used to access records returned from an SQL query. With a recordset, you can navigate returned records. You can also add, modify or delete records.
MsgBox is a built in VB function which displays a Message Box and MsgBoxQ is a function defined by the user.
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.
Timer control can also be placed on MDI form.
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 web pages, automation applications, etc. Integrated development environment is not present for VB script.
Visual basic applications are very useful in automating your existing application. VB application is useful for developing already existing applications.
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 applications.
Select appropriate Question to view its more answers in this category of
Do you find any Answer incorrect or incomplete? Please e-mail us or
place your comment and mention the number of question or if you have correct answer then
open the appropriate question by clicking on question and then place your answer in comment
regarding particular question in this category "VBA (Visual Basic for Applications) Interview Questions and Answers" To ensure quality,
each change is checked by our team, before it enters the main website
database. If you desire so, the changes will be credited to your name.