devxlogo

Tip Bank

Varying Length Dynamically

Question: I know VB insists on a _constant_ for the array subscript. Has anyone found a way around this? I would like to set an array length equal to the

Using DISTINCT Clause

Question: I have a Access table and I want to pull from that table one of each type and place it into a combo box using SQL. How can I

Parsing Calculations Automatically

Question: A VB form displays select financial numbers from an Access DB. The user can build a calculation. If the arithmetic operation is stored as text in the DB, how

Creating a Password Box

Question: I am writing a Visual Basic application that will require the user to enter a password. I have a inputbox set up for the user to enter the password.

Switching Databases/DAO Levels

Question: How can I use Access 7.0 databases within my Visual Basic 4.0 Professional Application?Everytime I try to open such a database, I always get error messages. Answer: I’m guessing

Using User-defined Types Within Procedures

Question: This is a beginner’s question but in a smalldatabase application when I click on a commandbutton the code gives me the error message “Invalid Inside procedure” and highlights the

Locking Box Against Input

Question: I want to disable a text box without having its text dimmed. I know of one way, which is put the controlinto a picture box and disable the picture

Repairing a Corrupted File

Question: Not knowing that my hard disk was almost full, I tried to load a VB MAK file that I had created in VB3. When I did, a message said