devxlogo

Tip Bank

Loading Bitmaps

Question: I am having trouble transferring a bitmap that I loaded withthe LoadBitmap call from a resource to a picturebox. Howdo I do that? Answer: The LoadBitmap call returns you

Copying a Database

Question: What’s an easy way to make a copy of a currently open database? I’ve got open recordsets all over the place that I don’t want to close. Answer: Simply

ScaleWidth vs Width

Question: I am resizing my widows during runtime. I also want my dialogboxes to resize with the window. My program is doing thiscorrectly. But it is not resizing the command

Quote Syntax Error

Question: I’m trying to delete a set of records in a table attached to a data control by using an SQL statement like the following: MergeRec.Data1.Database.Execute “DELETE Patient Visit WHERE

Controlling Size of Form

Question: How do I control the size of a form? Answer: Either set it at design time, or use the Width, Height, Top, and Left properties to set the form

Generating SQL for List of Options

Question: This is the first time I visited your site, and its the best VB site I’ve been too! My question is, I’m writing a sql statement using Variables and

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

Deleting a Directory Tree

Question: I want to delete and entire directory tree. I do not knowhow big the directory is, how many sub-dirs that it has, etc.I am not using a form and

Dynamically Generating Variable Names

Question: I have a number of objects, say shapes, which I have named s1, s2 , s3, s4 , s5.I would like to refer to the shapes fillcolor property witha