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

Using Me Object

Question: What is the different between using Me and FormActualName when accessing a form’s property or to pass the FRM to a subprogram.Is it ok to use ME all the

Creating Win95 Explorer-like Dialogs

Question: Are there common dialogs in Win95 like file open/save? I wish to put in my apps the ability to use long filenames which Win95 supports. Answer: Here is the

Opening and Reading a File

Question: Can you please send me the code to open a file using the common dialog box – not just the code to open the dialog box but to actually

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