devxlogo

Tip Bank

Using 3.0 Files in 4.0

Question: How do I upgrade my version 3.0 files to version 4.0? Answer: If you open your 3.0 project in any variant of VB 4.0, it will ask you if

Creating a Help File for an Excel Document

Question: I am trying to include a button in an Excel worksheet that will allow the user to click in to receive help infilling out the spreadsheet form properly. However,

Concatenation Functions

Question: I am using the ‘Execute’ to run an SQL statement.The sql is Microsoft SQL. The SQL is to ‘INSERT into table …SELECT …FROM TABLES…’. The select portion of the

Communication Between Forms

Question: I have two forms. There is a combo box on Form1 and a list box on Form2. Form1 has functions to add and delete names from the combo box.

Using Global Variables

Question: I have visual basic 2.0 Hopefully not for long. If I make a button that does a funtion like this. n = n + 1 print nit gives me

Manipulating Strings

Question: I don’t know how to access individual characters in a string.ie. accessing single elements in an array of characters.Each time I try I keep getting Type mismatch. Answer: You

Using Global Variables as Counters

Question: I am trying to put a counter in my program which will keep track of how many times a command button is pressed.I know it is simple but I

Controlling Size of Form

Question: How do I control the size of a form? Answer: Either set it at design time, or use the Width, Height, Top, and Left properties to set the form

Generating SQL for List of Options

Question: This is the first time I visited your site, and its the best VB site I’ve been too! My question is, I’m writing a sql statement using Variables and