devxlogo

Tip Bank

Executing SQL Statements

Question: How do I perform INSERTS, UPDATES andDELETES on existing tables? I have looked up the help andin books but nothing seems to tell me exactly how to do it.

Removing Picture Property

Question: If I apply a picture to a Form’s Picture property, is there a way to clear it out at design time? (Rather than by using LoadPicture “” at run

Putting a Menu on the Right Side

Question: When designing a menu, how do I get an option (for examplehelp) – to appear on the RIGHT hand side of the menu bar. Answer: To position the Help

Opening a Word Document

Question: How can I open a Word document from my Visual Basic application? Answer: Use the following code sample to do it:Set wordbasic = CreateObject(“word.basic”)wordbasic.fileopen pathname$, 0, 1where:pathname$ is the

Accessing Financial Function Library

Question: I’m looking for help on using the VB 3.0 functions IRR, MIRR and NPV. When I try to use any of them I get Reference to undefined function or

Storing Pictures in a DLL

Question: I found a vbx which allows me to place icons or bitmapson a command button. How can I store these images in onefile and read them in like an

Saving Forms as Text vs. Binary

Question: This may seem a stupid question, but I cannot figure or find it out anywhere… I have been having trouble with the setup wizard saying that my forms have

Checking for NULL Values

Question: When you read a string from a character field in a snapshot/dynaset you can append a pair of double quotes to protect yourself from “Type mismatch” errors, if the

Finding the End of a Word

Question: I am new to VB and must learn it by yesterday! I am working with text strings and must figure out how to pull words from a line by