devxlogo

Tip Bank

Remove Unsightly Frame Gaps in Netscape

When you create an HTML frameset using the FRAMEBORDER=”0″ attribute, the frames look fine in Internet Explorer. However, there’s an unsightly white gap between non-white pages when you view the

Combobox and ADO Resultset

Question: After retrieving a resultset, using VB6, from SQL Server, I am easily able to populate a grid by setting the resultset to the grid (i.e. Set DataCombo1.DataSource = GetRs).

Linking a Listbox to a Database

Question: How can I put a column from my database into a listbox using VB 6.0? Answer: Here’s a quick way to load a listbox using ADO in VB 6.0.

Object Creation in VB

Question: I’ve read about what happens behind the scenes when VB creates an instance of a COM object. But, what exactly does happen when VB creates an instance of a

Split Function

Question: How is the data laid out in the array and how do you know the size of the array! Answer: Each string that results from the Split function is

Setting Daily Events

Question: I want to kick off a function once a day (for examle, at midnight). The timer seems a very inefficient way to do this. Is there any way of

Variant Naming Specification

Question: I know a recordset object should be named rstName, but don’t know all about variant naming specifications. I looked for it on MSDN for a long time, but couldn’t

Migration: Access to SQL Server

Question: I have written an application using VB6/Access. I use DAO. How easy is it to convert the application from Access to SQL Server? Should I make a lot of