VBA Interview questions - Part 1 - Free latest PlacementPapers, Interview Questions ....

sai6606 · 09-12-08, 02:29 PM

1. ActiveX and Types of ActiveX Components in VB

2. audio waves through Visual basic

3. Constructors and distructors

4. Difference between a function and a subroutine, Dynaset and napshot, early and late binding, image and picture controls, Linked Object and Embedded Object, list box and combo box, List index and Tab index, modal and modules window, Object and Class, Query unload and unload in form, declaration and Instantiation an object?

5. Describe Database Connection pooling relative to MTS

6. Hello, I would like to do the following. If cell A1 contains "Hello" and if the focus is
Hello, I would like to do the following. If cell A1 contains "Hello" and if the focus is on A1 and if the Enter key is pressed, then the focus should go to B2 and a MsgBox should appear. I think this can be done with key events, something like OnKeyDown, but how do I tell it I want the event only be triggered by the Enter key? Thanks, Liglin

7. How can I call up oracle discoverer from Microsoft Excel, find a particular piece of data and transfer it into Excel -e.g. can I use a macro in Excel to call up discoverer

8. Controls which do not have events

9. How to set a shortcut key for label?

10. Default property of datacontrol

12. What is ADO, OLEDB & ODBC?

13. why we use DoEvents in VB6.0?

14. Define the scope of Public, Private, Friend procedures?

15. Name the four different cursor and locking types in ADO and describe them briefly

16. Advantages of disconnected record sets

17. Describe: In of Process vs. Out of Process component. Which is faster?

18. What does the Implements statement do?

19. Which property of textbox cannot be changed atruntime and what’s the maximum size of a textbo
Which property of textbox cannot be changed atruntime and what’s the maximum size of a textbox?

20. 1) You are creating a client application that calls ActiveX DLLs. Which of the following properties of the Err object provides the name of a component that sends an error back to the client application? a. Number b. Description c. CompName d. Component e. Source f. Text g. Desc h. None of the above2) If the Cancel Error Property of the CommonDialog Box is set to true then which of the following statement is true: a. A runtime error can result if the user clicks the cancel button b.
21. how can we upload to sql databse images using visual basic 6.0?

22. How does a DCOM component know where to instantiate itself?
23. Kind of components can be used as DCOM servers

24. VB and Object Oriented Programming

25. What are the ADO objects? Explain them.

26. What is OLE and DDE? Explain.

27. What types of data access have you used?

28. Under the ADO Command Object, what collection is responsible for input to stored procedures?

29. Which controls can not be placed in MDI?

30. How to set the custome paper size in Excel Object through VB?
31. What does Option Explicit refer to?

32. What are the different compatibility types when we create a COM component?

33. What methods are called from the ObjectContext object to inform MTS that the transaction was successful or unsuccessful?

34Hello,I have a VBA application with a DataGrid and was wondering if and how do I add controls (such as checkboxes) to the fields in the Grid?ThanksLeon

35. Name of the control used to call a windows application

sai6606 · 09-12-08, 02:31 PM

36. What was introduced to Visual Basic to allow the use of Callback Functions?

37. Type Library and what is its purpose?

38. What do ByVal and ByRef mean and which is the default?

39. Which Property is used to compress a image in image control?

40. Advantage of ActiveX Dll over Active Exe

41. 3 main differences between flexgrid control and dbgrid control

42. What is the difference between Msgbox Statement and MsgboxQ function?

43. To set the command button for ESC, Which property needs to be changed?

44. Which property of menu cannot be set at run time?

45. Benefit of wrapping database calls into MTS transactions

46. Which tool is used to configure the port range andprotocols for DCOM communications?

47. Which controls have refresh method, clear method

48. Can database schema be changed with DAO, RDO or ADO?

49. How to register a component?

50. What keyword is associated with raising system level events in VB?

51. Types of system controls, container objects, combo box

52. Thread pool and management of threads within a thread pool

53. Return value of callback function, the need of tabindex property

54Need of order method, no of controls in form, Property used to add a menu at runtime, Property used to count number of items in a combobox, resize a label control according to your caption.

55. How can you force new objects to be created on new threads?

56. How can objects on different threads communicate with one another?

57. Draw and explain Sequence Modal of DAO

58. Can you create a tabletype of recordset in Jet - connected ODBC database engine?

09-12-08, 02:29 PM	#1 (permalink)
sai6606 Senior Member Join Date: Nov 2008 Posts: 311	VBA Interview questions - Part 1 1. ActiveX and Types of ActiveX Components in VB 2. audio waves through Visual basic 3. Constructors and distructors 4. Difference between a function and a subroutine, Dynaset and napshot, early and late binding, image and picture controls, Linked Object and Embedded Object, list box and combo box, List index and Tab index, modal and modules window, Object and Class, Query unload and unload in form, declaration and Instantiation an object? 5. Describe Database Connection pooling relative to MTS 6. Hello, I would like to do the following. If cell A1 contains "Hello" and if the focus is Hello, I would like to do the following. If cell A1 contains "Hello" and if the focus is on A1 and if the Enter key is pressed, then the focus should go to B2 and a MsgBox should appear. I think this can be done with key events, something like OnKeyDown, but how do I tell it I want the event only be triggered by the Enter key? Thanks, Liglin 7. How can I call up oracle discoverer from Microsoft Excel, find a particular piece of data and transfer it into Excel -e.g. can I use a macro in Excel to call up discoverer 8. Controls which do not have events 9. How to set a shortcut key for label? 10. Default property of datacontrol 12. What is ADO, OLEDB & ODBC? 13. why we use DoEvents in VB6.0? 14. Define the scope of Public, Private, Friend procedures? 15. Name the four different cursor and locking types in ADO and describe them briefly 16. Advantages of disconnected record sets 17. Describe: In of Process vs. Out of Process component. Which is faster? 18. What does the Implements statement do? 19. Which property of textbox cannot be changed atruntime and what’s the maximum size of a textbo Which property of textbox cannot be changed atruntime and what’s the maximum size of a textbox? 20. 1) You are creating a client application that calls ActiveX DLLs. Which of the following properties of the Err object provides the name of a component that sends an error back to the client application? a. Number b. Description c. CompName d. Component e. Source f. Text g. Desc h. None of the above2) If the Cancel Error Property of the CommonDialog Box is set to true then which of the following statement is true: a. A runtime error can result if the user clicks the cancel button b. 21. how can we upload to sql databse images using visual basic 6.0? 22. How does a DCOM component know where to instantiate itself? 23. Kind of components can be used as DCOM servers 24. VB and Object Oriented Programming 25. What are the ADO objects? Explain them. 26. What is OLE and DDE? Explain. 27. What types of data access have you used? 28. Under the ADO Command Object, what collection is responsible for input to stored procedures? 29. Which controls can not be placed in MDI? 30. How to set the custome paper size in Excel Object through VB? 31. What does Option Explicit refer to? 32. What are the different compatibility types when we create a COM component? 33. What methods are called from the ObjectContext object to inform MTS that the transaction was successful or unsuccessful? 34Hello,I have a VBA application with a DataGrid and was wondering if and how do I add controls (such as checkboxes) to the fields in the Grid?ThanksLeon 35. Name of the control used to call a windows application __________________ Sai Prepaid Mobile Recharge Online - Airtel, Vodafone, Idea, BSNL Cellone, Reliance Mobile, Tata Indicom.

09-12-08, 02:31 PM	#2 (permalink)
sai6606 Senior Member Join Date: Nov 2008 Posts: 311	VBA Interview questions - Part 2 36. What was introduced to Visual Basic to allow the use of Callback Functions? 37. Type Library and what is its purpose? 38. What do ByVal and ByRef mean and which is the default? 39. Which Property is used to compress a image in image control? 40. Advantage of ActiveX Dll over Active Exe 41. 3 main differences between flexgrid control and dbgrid control 42. What is the difference between Msgbox Statement and MsgboxQ function? 43. To set the command button for ESC, Which property needs to be changed? 44. Which property of menu cannot be set at run time? 45. Benefit of wrapping database calls into MTS transactions 46. Which tool is used to configure the port range andprotocols for DCOM communications? 47. Which controls have refresh method, clear method 48. Can database schema be changed with DAO, RDO or ADO? 49. How to register a component? 50. What keyword is associated with raising system level events in VB? 51. Types of system controls, container objects, combo box 52. Thread pool and management of threads within a thread pool 53. Return value of callback function, the need of tabindex property 54Need of order method, no of controls in form, Property used to add a menu at runtime, Property used to count number of items in a combobox, resize a label control according to your caption. 55. How can you force new objects to be created on new threads? 56. How can objects on different threads communicate with one another? 57. Draw and explain Sequence Modal of DAO 58. Can you create a tabletype of recordset in Jet - connected ODBC database engine? __________________ Sai Prepaid Mobile Recharge Online - Airtel, Vodafone, Idea, BSNL Cellone, Reliance Mobile, Tata Indicom.