devxlogo

July 23, 1999

Scrollbars and 3-D Effects on Non-MDI Forms

Standard VB forms don’t support a scrollable client area. Normally, when one is needed, programmers resort to convoluted solutions such as filling the client area with a picture box, placing

Command Button Double-Click

Question: We have users who routinely double-click on the command buttons. What is the best way to ensure that the code is only fired once? Answer: One approach would be

Objects

Question: When you click on the right mouse button over a file name or folder, you get a menu which allows you to select Properties. Is there any way to

ADO Disconnected Recordsets

Question: I am designing a three tier architecture framework. For passing data from one tier to another, I am using ADO disconnected recordsets. For Reading, Updation and Deletion, I create

VB and Oracle: Use ADO or ODBC?

Question: What’s the consensus as to whether it is better to use the ADO native driver, or use the ADO ODBC wrapper with Oracle? Answer: Microsoft now provides a native

Loading Database Name at Runtime

Question: I have used several ADO data controls as well as one data environment designer in my app. This appears to “hardcode” the path to my database forcing me to

Building SQL Strings Dynamically

Question: What is the correct format to create a SQL string using embedded variables? I keep getting a message that says I have an “incomplete query clause”. I am trying

VB6 Text Box

Question: How do I get the TextBox to display automatically at the end of text instead of at the begining of the text? Answer: Set the SelStart property of the

Passing an ADO Connection Object

Question: I’ve made a VB ActiveX DLL and defined a class and some methods to perform some database operations. I pass an ADO connection by reference to this class from