Tip Bank

DevX - Software Development Resource

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,

DevX - Software Development Resource

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

DevX - Software Development Resource

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.

DevX - Software Development Resource

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

DevX - Software Development Resource

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

DevX - Software Development Resource

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

DevX - Software Development Resource

Exiting Program after Windows Close

Question: Just recently I noticed that if I close my app while it is minimized, the app seems to be left in memory and is still recognized by Windows as

DevX - Software Development Resource

Writing Data to Disk

Question: I have written a testing program that writes results to a grid.How do I write the grid to disk so that changes can be addedfrom testing session to testing

DevX - Software Development Resource

Finding Text in a Text Box

Question: I am looking for code or VBX that allows a user to use an inputbox to locate a word within a textbox. The textbox is connected to a Access