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

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

Question: How do you put different objects in a TabStrip? I can make it but once I add something to it in the preview area, it shows up on all

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

It is common to have online survey results posted via an ASP page. While for the most part it will work fine, you have to be careful when your results

If you are developing COM components that run under MTS (Microsoft Transaction Server) then during the development phase, you will notice that dangling interfaces are often present in your system

If your program has an Explorer shell-style interface, you probably want to supply the standard File | Properties dialog. Do this by using the ShellExecuteEx API function: Private Type SHELLEXECUTEINFO

A Recordset without a live connection to a database server is called a disconnected Recordset. You can create a disconnected Recordset using the CursorLocation Recordset object property. The CursorLocation property

Getting rid of unused Visual InterDev projects can be difficult if you try to do it the wrong way. If you go into the Web server’s file system and simply

You can programmatically set an item in a JComboBox when the item is not in the combo box’s item list using an editable JComboBox. An editable combo box acts like

Here is a simple way to improve performance with respect to recordset traversal of your MDAC (Microsoft Data Access Components) application. If you want to traverse the recordset then you

Question: I’ve inherited an Access database with embedded spaces in the column names. I use SQL with Visual Basic and want to select these columns and alias them so that

Question: I have a problem with Views. If I make this query: INSERT INTO ACHATSSELECT DISTINCT VINS_ACHAT.PRO, VINS_ACHAT.QtebouteilleFROM VINS_ACHAT then this is a good one. But if I want to

Question: I am trying to use data shaping to get a recordset back. I was using two stored procedures that took one parameter each, but now I need to pass

Question: I’m using SQL queries in Delphi 4 to access a database. Some of the field names in the database are either reserved keywords or invalid in some way (for

Question: I have a field called StartDateTime. In Microsoft Access it contained only a time. My code used to sort this field properly when outputting, so that morning events appeared

Question: Is it possible to return a number in a column, using a function, for each row in my result set? For example: “Select RowNum As Rw, Fname, Birth From

Question: If I don’t know the table names beforehand, how do I get the table names out of the database? Answer: Use this: SELECT NAME FROM SYSOBJECTS WHERE TYPE =

Question: I have two tables, “grade” and “assignment”: TABLE FIELDgrade grade (char i.e. A..F) low_range high rangei.e. ‘A’, 80, 100 ‘B’, 60, 80 etc.assignment s_ref assign_no grade (numeric i.e. 78)

Question: What is the function of the DECLARE keyword in an SQL program? I am aware you can DECLARE cursors in embedded SQL. Are there any other instances where DECLARE

The navigation bar controls that come with Visual InterDev 6 cause more than their share of problems for newcomers. The most frequent complaint is that the navigation bar doesn’t show

While debugging and running COM components under MTS (Microsoft Transaction Server), you may get automation errors, or time outs, or your transaction may abort. This may happen if you have

A previous tip, “Get a Hold of Swing Defaults,” shows how to obtain the default settings for Swing components. It is easy to change any default settings programmatically. For example,

Question: Can I retrieve data from a text file instead of querying an Access database? Answer: Yes, you can access a text file from an ASP page. Use the FileSystemObject

Question: I want to assign the result of a SQL statement to a multi-line text box, and I want to format the individual fields using the Format function. Can I

Question: I have made a databaseconnection to a dbase IV database in VisualInterdev (with global.asa). In the Data View window I can see the tables, but when I open a

Any time the behavior of your code depends on the Timer function you should take into account the (more or less) remote possibility that your code is executed just before

The following routine quickly check that a string contains a valid GUID. Of course, it doesn’t check that the GUID refers to a valid entity, but at least it lets

Both VB5 and VB6 include a hidden function, named VarPtr, that returns the address of a variable. Many advanced tricks and routines, on VB2TheMax or other site, use this function.