VB Forum / General / August 2006

I want to search for two words in a string of n words.
I run an SQL query for example:
SELECT * FROM Bio WHERE comments LIKE hobby AND comments LIKE fishing
The words hobby and fishing are two words in the memofield comments.

What is the most efficient (best) way to open an Access 2003 database using
VB.
Should I use Jet4.0, Microsoft Access DB Driver, other?  The database isn't
big...  maybe 20 tables and 500 to 1000 records in the main table.

I got it last night. The documentation seems to have been translated by
babelfish and it seems a bit clunky right now but there is something
interesting there. http://www.kbasic.com/
I'm still using VB6 and I'm certain it is still way ahead of kbasic but

I'm looking for a fast way to read in XML files in plain good old VB6..
And yes I know there is the MSXML object, but I can't use that since we
can't be sure all our customers have this object (or have the latest
which would be needed by our program).

XML NODE DEMO
-----------------------------
- <Match id="430680" leagueCode="8613" leagueSort="10"
startTime="18:30" status="Sched" type="1" visible="1"

I would like to know if it is possible to disable (or grayout) some items in
a combobox.
Mario

I am looking for a simple piece of code for stripping the XML tags from
a string. Here is a sample string:
<Top>mystring</Top>
I want te remove the tags and be left with this:

I have a program which uses both Access and SQL Server, when I use the
following code it works fine for access, however when it is SQL Server it
does not return a value
   If bOpenRecordset("SELECT * FROM [" & fcTableName & "] WHERE Reference =

I need to truncate values from the database and show in the grid.
if the value is 100.578
it should be formatted to 100.57 and display in the grid.
if i format like "####.##"

My situation is to format the columns in the grid.
tdbgGrid.coloumns(0).Numberformat="####.##"
For ex:
   If the column value is 100.578

I need to be able to dynamically add (or remove) checkboxes from a listbox at
runtime. I notice that the 'style' property which controls this is a
read-only property at runtime (this wont work: list1.style = 1)
Before I try to figure out the subclassing to achieve this, does ...

I have an MDIForm which then has child forms within it.  I was wondering if
it was possible, when maximizing the parent form that all child forms also
maximize within the parent. Is this possible?
Appreciate any help on this.

I have a stored procedure that contains two parameters.  Is it possible to
use a datagrid with a parameterized stored procedure?  
If so, does anyone have an example of how this is done?
Any help will be greatly appreciated!

I have a recordset of scores in a shooting sports competition and
before I display the results on my ASP page, I want to sort the
recordset by the total score for each individual. I'm trying to do
something like this:

I have a form which although has numerous controls the actual problem is
based around an image and a label
The image has the picture property set to an image, there is a label that
sits on top of it which is transparent.