July 23, 1999

DevX - Software Development Resource

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

DevX - Software Development Resource

DateAdd Function Parameters

Question: While using the dateadd() function to add the given number to an existing year, it adds the days instead of years if we use the command in the following

DevX - Software Development Resource

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

DevX - Software Development Resource

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

DevX - Software Development Resource

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

DevX - Software Development Resource

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

DevX - Software Development Resource

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

DevX - Software Development Resource

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

DevX - Software Development Resource

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