Here’s an easy method for making sure your users enter only numeric data, and only one decimal point. First, place two Public procedures in a standard module. You can use

When you’re editing a series of controls, you can multiselect them either by clicking while holding down the Control button or by “lassoing” them with the mouse, then enter the

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

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

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

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

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

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