devxlogo

Tip Bank

VB5 – Is the Format Function Y2K Compliant

Question: I am using the format function to format a date entered by the user. My machine’s short date setting is mm/dd/yyyy. My OS is NT 4.0 Format(25/05/01,”Short Date”) gives

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

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

hWnd Attribute

Question: I have to make a programm to read DATA from a Card, the first function that I must call says: Function_name(hcaller As Long,…) This hcaller is an hWnd and

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

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

Network Installation of VB6

Question: I have the VB6 Enterprise Edition which is going to be the development tool. Is it possible to have a network installation of VB6, so that I can put

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

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