Tip Bank

DevX - Software Development Resource

Searching Numerical Fields

Question: What it’s the correct SQl Statement to search an access database by a numeric field? I keep getting an invalid type error when I try to run the application.

DevX - Software Development Resource

Retrieving Binary Objects

Question: I am using VB together with Access. What I want to do is to include photo into my form. In Access table, I declare thisfield as an OLE field

DevX - Software Development Resource

Placing Windows on Screen

Question: I am trying to figure out exactly how to get mywindow to center itself no matter what the resolution of the screen is that it is beingdisplayed on is.

DevX - Software Development Resource

Copying a Directory Tree

Question: How do you copy entire directory structures with VB3, I’veread the -ONE- newsgroup article but it just lists them. Answer: Have you tried shelling to an XCOPY statement? It

DevX - Software Development Resource

Programmatically Clearing a Text Box

Question: I have a series of text boxes, any subset of which can be used for input of numerical data, followed by a command box to “compute” from that input

DevX - Software Development Resource

Opening MAK Files with VB 4.0

Question: In working with VB4 I find that if I double click on a project file (.mak or .vbj) the system always starts upVB4 in 16bit mode. I am wondering

DevX - Software Development Resource

Accessing Properties

Question: How do you access a Public Property in a class module from an in-project module? For example:In a new project create one class module; “Class1” and one bas module;

DevX - Software Development Resource

Changing RecordSource at Runtime

Question: At runtime, how do I change the query that I’m using with my data controls to be one a user selected? I don’t want to keep the same name