Hello, Thank you for this VERY VERY 
helpful piece 
of code!!
I think 
you're doing a very great job of 
helping out the folks
who are new to 
database programming in visual 
basic
and i commend you :)
i was 
just wondering though,
could you 
(whenever you have the chance), make a 
step-by-step
tutorial (perhaps?) on 
how to build a database application 
from scratch?
that implements the 
following features:
fast search 
through the database, insert, delete, 
update, edit?
Thanks! :)
and VERY 
VERY great job!
Ian

Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:
 

The code looks good, from the little 
experience I have with databases, 
however the database file you included 
seems to be corrupted or perhaps 
incorrect.  I am not sure which.  I am 
going to try downloading it again 
though.  Thanks for the upload.  It's 
very cool how your helping out a lot of 
people with databases.

Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:
 

First i would like to say thanks for 
your help & time
?? about this 
line
SQLText = "SELECT * FROM 
DBWords WHERE Left(dbWord," & 
Len(reqText) & ")='" & reqText & 
"';"
can you expline a bit more of 
what it is doing
i think i can under 
stand it up to about here
SQLText = 
"SELECT * FROM DBWords WHERE 
Left(dbWord," & Len
	thanks 
		oc

Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:
 

i wanna more examples

Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:
 

Great, someone who can help on the 
creating databases within VB. Thanks. 
It's just what I've been looking for, 
but can you please explain
SQLText = 
"SELECT * FROM DBWords WHERE 
Left(dbWord," & Len(reqText) & 
")='" 
& reqText & "';"
thanks again.

Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:
 

This code is soooo great!!
Just what 
i have been looking for for a LONG 
time!
When do you post your next 
example?

Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:
 

just like to say thanks for your email 
Suat it helped, still not to sure about 
the last bit of the line.

Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:
 

The code looks good but I have some 
mild criticism.  In the declaration 
section of the module the variables 
DBMain and RecSet are declared as 
Global.  I have a pet peeve about your 
incosistent use of the Microsoft Naming 
convention which would require your 
global variables to be prefaced with 
"g" and your forms to start with "frm", 
but for the sake of this tutorial it is 
acceptable.  However do you think 
creating database connections globally 
without closing them right after use is 
the best method?  I'd like to see some 
debate about this.  I personally try to 
open, exucute and close database 
connections all in one function.  My 
thinking was that database connections 
are limited.

Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:
 

Interesting DB code If Programming were 
Music ....Youd be a Hendrix of code

Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:
 

thank you for your good idea ,i need 
examples visual basic database with sql 
and add remove or other commadnd ,can 
you help me for my project ? ..

Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:
 

SELECT * FROM EmployeeTable ......
* 
being all the rows in the record set 
otherwise say you only want first 
names.... SELECT FName FROM 
EmployeeTable 
Get it now?
ARRiVE

Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:
 

My thoughts on the database connections 
issue...
I think that keeping the 
connection open will improve 
performance. I also think that 
connections to a database only become 
an issue in medium size and up 
multi-user apps or when you are dealing 
with a database back-end that has 
connection licences (SQL Server, 
Oracle, ...).
That's my 2 cents  :)

Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:
 

I saw that this is great like us 
(beginners) even the advances 
Programmers cause every one has 
different style and thinking. I want 
you to be my mentor in Database 
Programming. I want to dedicate my 
carrer in this field. How can I contact 
you aside from here.
Thank 
you.
eugene

Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:
 

Great stuff!
However, I think the 
following line should be changed for 
speed
From:
    'SQLText = "SELECT 
* FROM DBWords WHERE Left(dbWord," & 
Len(reqText) & ")='" & reqText & 
"';"
To:
    SQLText = "SELECT * 
FROM DBWords WHERE dbWord like '" & 
reqText & "*';"
In a case of a real 
dictionary where you have many words, 
using left would be very costly. The 
reason is that when you use left, the 
query returns all rows and the the JET 
engine filters out the unneeded ones. 
When you use LIKE, the query will nver 
return the unneeded rows.
If I am 
wrong please let me know.
Once 
again, Thanks for the code.

Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:
 

Thanks for help

Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:
 

Does any one know if there are going to 
be more codes from this man
GREAT CODE 
DUDE
but I am searching after a code 
to delete,rename, etc.
Pleas help

Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:
 

Suat:
I am new to VB, so thi 
question may be very basic.  If I have 
created forms in Access, how do I call 
these forms from a VB database to be 
printed?  In other words, from a 
"print" button on a VB form, I would 
like to have all forms or certain forms 
be printed.  I hope you can help.

Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:
 

I have tried numerously to input this 
SQL statement into my own code, as well 
as to look its parameters up in various 
sources.
However I keep getting a 
Error: 3061 Too Few Parameters. 
Expected 1 error.
What is it and 
what can I do to fix it...
Thanks!

Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:
 

Hello,
Its very inspiring to have a 
code like this one. And read a TONS of 
comments or feedback too.
By the way 
if  you have enough time can i asked to 
email me the explanation of this 
part:
SQLText = 
"SELECT * FROM 
DBWords WHERE 
Left(dbWord," & 
Len(reqText) & 
")='" 
& reqText & 
"';"
Once again thanks

Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:
 

I need a VB database code which deals 
with more than 1 table (MS Access) 
without using data control (direct 
codeing). Please if any body know help 
me at lashkari@idirect.ca  Thank you. 

Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:
 

i am running windows NT4sp6 and 
VB5sp3
i tried your code to create a 
database and keep getting the error  
"Active X component can't create 
object" when it trys to createdatabase. 
I have referenced 
Micrisoft ActiveX 
Data Objects 2.0 Library     
and
Microsoft DAO 3.51 Object 
Library
I hope you can help as your 
programme
layout looks very 
good
thanks 
eamonn

Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:
 

Hi again,
I was realy away for this 
long time so i couldnot see your 
feedbacks. First of all, thank you very 
much everyone for all kind of 
idea.
Eugene Almanon : my email 
address is smozgur@hotmail.com.
Sam : 
Yes, you are right and i just want to 
use natural code not statements but i 
think that i changed it. Anyway, you 
are definetely right about LIKE 
operator. 
AmNeStY : Thanks. Contact 
with me. I am trying to plan to create 
a web site like a Database 
Tutorial.
Siphon : There is a way to 
use objects in Access within Visual 
Basic. If you see this message please 
contact with me.

Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:
 

Robert : Your code plly has a string 
syntax error. It is really easy to 
recover. Tell me if you still have 
problem, please with your 
SQLtxt.
Benjie : It is just filtering 
records for the characters which user 
typed. If user type "sm" then it looks 
for if there is a word begin with "sm", 
also if user type "smo" then it will 
look for "smo". Thats all. And you can 
also use Like operator like Sam said 
above.
Eamonn : Please let me know 
about your code.
Ok, i think nobody 
will turn this page :) but thanks for 
feedback and Enjoy Database Programming!

Keep the Planet clean! If this comment was disrespectful, please report it:
Reason: