Tip Bank

DevX - Software Development Resource

ADO Provider Problem

Question: I created a program to help our sales department to keep track of their sale quotes. It uses a MDB database and I used the ADO components to gather

DevX - Software Development Resource

VB Class Module

Question: I have noticed that a termination event won’t be fired unless the class variable is out of scope, or I specifically set the class variable to Nothing (in earlier

DevX - Software Development Resource

COM in IIS

Question: After I compile my DLL in VB and run the component through IIS, I cannot recompile the DLL and I get a file locking error. I am using VB6

DevX - Software Development Resource

Cube Root Function

Question: Would you please tell me the code in Visual Basic for a cube root function on a basic calculator. Answer: It’s very simple, you just have to raise a

DevX - Software Development Resource

Control Focus

Question: When a control has focus, is there some way to determine which control had focus just before it? Answer: Nope, there isn’t any way to do that. But, I

DevX - Software Development Resource

Access 97 vs. 2000 Databases

Question: I have a program in VB6 using an Access 97 database. The code I use for all my procedures is as follows: Dim db as DatabaseSet db = DBEngine.Workspaces(0).OpenDatabase(“biblio.mdb”,

DevX - Software Development Resource

Accessing Online Databases

Question: I have been using Visual Basic to manipulate databases for some time now and I consider myself skilled at it. The next challenge presented is to establish a connection

DevX - Software Development Resource

Changing Label Caption of a Textbox

Question: I am an extreme newbie with VB. How do I change the caption of a label to the value of a textbox? Answer: Substitute the name of the Label

DevX - Software Development Resource

Image Storage in Access 97

Question: I have an Access 97 database with an OLE Type field containing bitmaps loaded with the LoadPicture() function. This works fine and the images turn up as “Bitmap Image”