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

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

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

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

Question: How can I create dynamic controls, such as a textbox, without a basic control in the form ? Answer: In VB6 you can add new controls to the Controls

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

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,