Explore topic-wise InterviewSolutions in .

DoEvents command tell PROGRAM control to EXECUTE other commands, while EXECUTING LONG task.

DoEvents command tell program control to execute other commands, while executing long task.

AUTOMATICALLY REDRAW the OUTPUTS.

Automatically redraw the outputs.

a) ByRef -PASS the ADDRESS of variable not value
b) BYVAL - pass the value 

a) ByRef -pass the address of variable not value
b) ByVal - pass the value 

LET used to SET value for ORDINARY variable and Set used to set value for OBJECT variable.

Let used to set value for ordinary variable and Set used to set value for object variable.

a) Connection
b) Command
c) Recordset
d) FIELD

a) Connection
b) Command
c) Recordset
d) Field

a) LockPessimistic - Locks the row once after any EDITS occur.
b) LockOptimistic - Locks the row only when Update is called.
C) LockBatchOptimistic - ALLOWS Batch Updates.
d) LockReadOnly - READ only. Cannot ALTER the data.

a) LockPessimistic - Locks the row once after any edits occur.
b) LockOptimistic - Locks the row only when Update is called.
c) LockBatchOptimistic - Allows Batch Updates.
d) LockReadOnly - Read only. Cannot alter the data.

QUERY unload event occurs in a FIRST and then unload event occurs, in MDI form we can TRAC child form closing status by USING this event.

Query unload event occurs in a first and then unload event occurs, in MDI form we can trac child form closing status by using this event.

Processes COMMUNICATE with one ANOTHER through messages, using MICROSOFT’s Remote PROCEDURE Call (RPC) technology to pass information to one another.

Processes communicate with one another through messages, using Microsoft’s Remote Procedure Call (RPC) technology to pass information to one another.

Class is TEMPLATE from we can create OBJECTS, Objects are INSTANTIATE of a class. For example car is a class and MARUTI 800, Maruti ZEN are objects of car class.

Class is template from we can create objects, Objects are instantiate of a class. For example car is a class and Maruti 800, Maruti Zen are objects of car class.

A modal FORM has exclusive focus in that application until it is dismissed. Moduless form are not REQUIRED exclusive focus and it is default when we SHOW any form.

A modal form has exclusive focus in that application until it is dismissed. Moduless form are not required exclusive focus and it is default when we show any form.

Both are DISPLAY LIST of items, however in combo BOX user can EDIT the item.

Both are display list of items, however in combo box user can edit the item.

a) Table-type RECORDSET - Hold records from single table and can add, edit and delete.
b) Dynaset-type Recordset - Can hold editable records from MULTIPLE tables.
c) Snapshot-type Recordset - Hold read only records from multiple tables,
d) Forward-only-type Recordset - Hold read only records from multiple tables without cursor.
e) Dynamic-type Recordset -HOLDS editable records from multiple tables and CHANGES done by other user also VISIBLE.

a) Table-type Recordset - Hold records from single table and can add, edit and delete.
b) Dynaset-type Recordset - Can hold editable records from multiple tables.
c) Snapshot-type Recordset - Hold read only records from multiple tables,
d) Forward-only-type Recordset - Hold read only records from multiple tables without cursor.
e) Dynamic-type Recordset -Holds editable records from multiple tables and changes done by other user also visible.

CONNECT PROPERTY

Connect property

FUNCTION ALWAYS RETURN a value, wheras am METHOD MAY or may not return value.

Function always return a value, wheras am method may or may not return value.

The SIZING BEHAVIOR of the image control differs from that of the picture box. It has a STRETCH property while the picture box has an AutoSize property. Also picture box is a container control and SUPPORT most of the graphics method.

The sizing behavior of the image control differs from that of the picture box. It has a Stretch property while the picture box has an AutoSize property. Also picture box is a container control and support most of the graphics method.

An in-process component is implemented as a DLL CALLED ACTIVEX DLL, and runs in the same process space as its client app, enabling the most efficient communication between client and component. Each client app that uses the component starts a new instance of it.

An out of process component is implemented as an EXE called ActiveX EXE, and unlike a dll, runs in its own process space. As a result, exe’s are slower then dll’s because communications between client and component must be MARSHALLED across process BOUNDARIES. A single instance of an out of process component can service many clients.

An in-process component is implemented as a DLL called ActiveX DLL, and runs in the same process space as its client app, enabling the most efficient communication between client and component. Each client app that uses the component starts a new instance of it.

An out of process component is implemented as an EXE called ActiveX EXE, and unlike a dll, runs in its own process space. As a result, exe’s are slower then dll’s because communications between client and component must be marshalled across process boundaries. A single instance of an out of process component can service many clients.

Intrinsic controls - Default controls of VB6, These control are always available in VB6 Toolbox.

ActiveX controls - .These are extra controls which can be added into toolbox and this control having SEPARATE files (.OCX). Must be deployed SEPARATELY along with application in other system.

Intrinsic controls - Default controls of VB6, These control are always available in VB6 Toolbox.

ActiveX controls - .These are extra controls which can be added into toolbox and this control having separate files (.ocx). Must be deployed separately along with application in other system.

STANDARD EXE, ACTIVEX EXE, ActiveX DLL, ActiveX DOCUMENT, and ActiveX Control.

Standard EXE, ActiveX EXE, ActiveX DLL, ActiveX document, and ActiveX Control.

Microsoft FlexGrid (MSFlexGrid) CONTROL displays and operates on tabular data. It allows programmatically sort, merge, and format tables containing STRINGS and pictures. DBgrid is A spreadsheet-like bound control that displays a series of ROWS and COLUMNS representing RECORDS and fields from a ADO Recordset object.

Microsoft FlexGrid (MSFlexGrid) control displays and operates on tabular data. It allows programmatically sort, merge, and format tables containing strings and pictures. DBgrid is A spreadsheet-like bound control that displays a series of rows and columns representing records and fields from a ADO Recordset object.

In-process COMPONENT is IMPLEMENTED as a DLL, and runs in the same process space as its client app, enabling the most efficient communication between client and component. An out of process component is implemented as an EXE, and unlike a dll, runs in its own process space. As a result, exe’s are SLOWER then dll’s because communications between client and component must be marshalled across process BOUNDARIES

In-process component is implemented as a DLL, and runs in the same process space as its client app, enabling the most efficient communication between client and component. An out of process component is implemented as an EXE, and unlike a dll, runs in its own process space. As a result, exe’s are slower then dll’s because communications between client and component must be marshalled across process boundaries

ALIGNMENT PROPERTY, TAB INDEX ETC

Alignment property, Tab Index etc

Caption

Caption

getrows

getrows

Clipboard.SetData and Clipboard.GetData

Clipboard.SetData and Clipboard.GetData

Option Base is to set the INDEX of the ARRAY to start from 0 or 1.Like option explicit.. declare “Option base 1″ at the top. now the array will start from Index By default the index starts from 0.

Option Base is to set the Index of the Array to start from 0 or 1.Like option explicit.. declare “Option base 1″ at the top. now the array will start from Index By default the index starts from 0.

PRIVATE Sub Command1_MouseDown(BUTTON As Integer, SHIFT As Integer, X As Single, Y As Single)
If Button = 2 Then
PopupMenu Menuname
End If
End Sub

Private Sub Command1_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
If Button = 2 Then
PopupMenu Menuname
End If
End Sub

AppActivate (”C:windowssystem32cmd.exe”) ‘ Appilcation caption
SendKeys (”SA”) ’For sending one string
SendKeys “% ep”, 1 ’ For sending CLIPBOARD data to DOS 

AppActivate (”C:windowssystem32cmd.exe”) ‘ Appilcation caption
SendKeys (”SA”) ’For sending one string
SendKeys “% ep”, 1 ’ For sending Clipboard data to Dos 

Early binding allows DEVELOPERS to interact with the object’s properties and methods during coding permits the compiler to check your code. Errors are CAUGHT at compile time. Early binding also RESULTS in faster code
Eg : Dim ex as new Excel.Application

LATE binding on the other hand permits defining generic objects which may be bound to different objectsyou could declare myControl as Control without KNOWING which control you will encounter. You could then query the Controls collection and determine which control you are working on using the TypeOf method and branch to the section of your code that provides for that type
Eg : Dim ex as Object

set ex =CreateObject(“Excel.Application”)

Early binding allows developers to interact with the object’s properties and methods during coding permits the compiler to check your code. Errors are caught at compile time. Early binding also results in faster code
Eg : Dim ex as new Excel.Application

Late binding on the other hand permits defining generic objects which may be bound to different objectsyou could declare myControl as Control without knowing which control you will encounter. You could then query the Controls collection and determine which control you are working on using the TypeOf method and branch to the section of your code that provides for that type
Eg : Dim ex as Object

set ex =CreateObject(“Excel.Application”)

CHECKBOX, comna, combo, list, picture, ADO CONTROL, Data,DATAGRID, Datareport,Dir list biox, filelistbox ETC.

Checkbox, comna, combo, list, picture, ADo control, Data,Datagrid, Datareport,Dir list biox, filelistbox etc.

Object LINKING and embedding, for using to other object classes like word, EXCEL , autocad OBJECTS in our own APPLICATIONS, only THING we have to add reference for these objects.

Object linking and embedding, for using to other object classes like word, excel , autocad objects in our own applications, only thing we have to add reference for these objects.

Cancel

Cancel

SHAPE, LINE CONTROLS

shape, line controls

Connection: Used to make a connection between your app and an external DATA source, ie, SQL server
Command: Used to BUILD QUERIES, including user-specific PARAMETERS, to access records from a data source
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.

Connection: Used to make a connection between your app and an external data source, ie, sql server
Command: Used to build queries, including user-specific parameters, to access records from a data source
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.

LockPessimistic: Locks the row once after any EDITS occur.
LockOptimistic: Locks the row only when Update is called.
LockBatchOptimistic: Allows BATCH Updates.
LockReadOnly: Read only. Can not alter the DATA.

LockPessimistic: Locks the row once after any edits occur.
LockOptimistic: Locks the row only when Update is called.
LockBatchOptimistic: Allows Batch Updates.
LockReadOnly: Read only. Can not alter the data.

FORWARD Only: Fastest, can only move forward in recordset.
Static: Can move to any RECORD in the recordset. DATA is static and never changes.
KeySet: Changes are detectable, records that are deleted by other users are unavailable, and records CREATED by other users are not detected
Dynamic: All changes are visible.

Forward Only: Fastest, can only move forward in recordset.
Static: Can move to any record in the recordset. Data is static and never changes.
KeySet: Changes are detectable, records that are deleted by other users are unavailable, and records created by other users are not detected
Dynamic: All changes are visible.

DIM OBJ as OBJ.CLASS
SET obj = NEW OBJ.CLASS
or
Set obj = CREATEOBJECT (“OBJ.CLASS”)

Dim obj as OBJ.CLASS
Set obj = New OBJ.CLASS
or
Set obj = CreateObject (“OBJ.CLASS”)

All VARIABLES MUST be DECLARED before use. Their TYPE is not REQUIRED.

All variables must be declared before use. Their type is not required.

COMPILING the COMPONENT, RUNNING REGSVR32 MyDLL.dll

Compiling the component, running REGSVR32 MyDLL.dll