devxlogo

Tip Bank

Parsing String for E-Mail Address

Question: I semi-understand InStr, however, lets say I am trying to parse e-mail addresses and test for “@”. How do I find my way to the beginning and end of

Installable ISAM Errors

Question: I am trying to write an application which will provide the ability todynamically add or update tables in an Access .MDB database. Everything inthe application runs when I do

Breaking String into Bytes

Question: How can I convert a string with three individual bytes of data to different bytes? I am sending Data1,Data2,Data3 as String and I want to receive string and convert

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