devxlogo

The Latest

Putting More Controls on a Form

Question: If you are designing a program, but there is not enough room on a form even when it is maximized, what can you do? Answer: If you use a

Creating Long Delays

Question: I’ve been trying to create a simulator – it requires as close to real-time operation as possible. I have a couple of questions about timers.How do I activate a

Creating Huge Arrays with ReDim Keyword

Question: I am loading a file which is basically a list of numbers into an array. The array is declared as a string. I keep getting an “out of string

Source Control Tools

Question: We are developing a decent sized application in VB with a couple of programmers. We are looking for a way to have all of the programmers work on the

Selecting Visual Basic vs. Visual C++

Question: Where would you use Visual Basic over Visual C++? Answer: Well, personally, I’d almost always use VB over VC++ for a few reasons: Ease of use – it’s much

Embedding Double Quote Characters in Strings

Question: How can I include a double quote character in a string? I couldn’t find any masking characters like backslashin C. Answer: To include the double quote character within a

Global Variables Between Applications

Question: The VB4 help files state that Public Declarations in a General module are available to all forms andmodules in all applications. Is this true? I can’taccess such variables across

Installing Database Application

Question: I am having trouble using the setup wizard for a project I have created in Visual Basic. The problem is after I setup the program on another computer, the

Using the CancelError Property

Question: You said there’s an example in the VB help file on use of theCancelError = true property. Where is it? In my app, I can get VB to generatethe

Trapping Cancel Button

Question: In a simple loop on a form with a Cancel Button:DoHere I want to Check to see if a user pushed a cancel button(Cancel Property is set to true)(While

Closing a Database

Question: I have made a program to use a database, and will makea copy of this file to a disk. The problem is that Ican’t make a copy of the

Using Generic Objects

Question: I am using a subroutine which involves 2 list boxes in a pick box configuration. I take the literal boxname [Form.Control] and load it to a variable- BoxName. I

Saving Window Changes When Unloading

Question: How do you save the choices when changing forms and shutting down the program. Do I have to use a module to store the changes? Answer: If you have

Checking for Existence of a File

Question: How do you check to see if the name of a file you want to RENAME a file to already exists? Answer: Here is a great example of how

Using GROUP BY Clause

Question: I am writing a Lottery Simulator, I have a database which contains seven fields, each field of each record contains a number from 1 to 49. I am looking

Application Finding VBXs and DLLs

Question: I have created a VB executable file and now want to distribute it to users. I want this executable to reside on our network drive. The problem that I

Generating Special HTML Tags

Question: I am trying to use Print# statements to create an HTMLtext file and VB3 that I am using keeps interpreting the HTML characters as Data Types and operators saying

Binding to a Database

Question: Is it possible to bind a cell in a grid with a database field (as we can do for text boxes and some other controls)? Answer: In VB3, the

Creating Nested Queries

Question: My question is with regards to VB’s ability to handle complexSQL. I have the application I am developing set up in the followingway: I copy the SQL created into

Including Single Quotes in Queries

Question: How do you include a single quotation mark in a query?Example:“Select * From BATCH Where BATCH.NAME = ‘O’Connel’” Answer: Simply replace the single quote with two single quotes together.

Advantages/Disadvantages of Using Sub Main

Question: Can you please tell me when do you use Sub Main and the advantages of using it? Answer: In certain programs, initialization code has to run before any windows

Putting Controls on MDI Forms

Question: I have a project I am working on including an MDIform with a toolbar. I am wanting to put a combobox on the toolbar, but VB4 will not let

Data Controls and Open Connections

Question: I have five data controls on a form that access five tablesfrom the same database. I want to open the database just once.Does having five data controls mean that

Documentation

Question: How do I write a help file in Word 6, and then, how do I compile it? I can’t find any documentation on it. Answer: This is unfortunately not

Creating Public Methods vs. Using Show Directly

Question: The program I am writing has two menu items for displaying say, autoexec.bat and config.sys respectively. I would like to make it so thatthey only need to call a

Filling from Recordset

Question: How do I fill a combo box with the values from an Access 2.0query or table? I have the compatibility layer installed and everything works except I can’t figure

Compilation Requirements

Question: I know I need VB40032.DLL to run my visual basic programs,but I was wondering if it is possible to make a VB executablethat does not require VB40032.dll. Answer: VB40032.DLL

Creating INI Files

Question: How do I create INI files to meet the common microsoft standard? Answer: INI files can be created with Notepad, or any other plain text editor. Once the file

Detecting Row Selection in TrueGrid

Question: I have a database (Access) with 6 tables. I created a form for each table. I created an Apex True DBGrid for the database using the first table for