I did as instructed and Still get the error any sugestions??

I think that what he wants is a database with 2 tables: one with user name & one with details... and he wants the details to be automatically entered (by an input of some sort) in both tables correctly, when a new user is added...

You can use a variable instead of a value...

Just declare a variable, say quer as string, and let's say you would like to use the value typed in text box, Text1 and the field name is 'Name'. Use the following:

quer = "Name" &  "='" & Text1.text & "'"
data1.recordset.findnext(quer)

You can also use the LIKE connector as:

quer = "Name" & " LIKE '" & Text1.text & "*'"
data1.recordset.findnext(quer)

Quote:

You can also use the LIKE connector as:

quer = "Name" & " LIKE '" & Text1.text & "*'"
data1.recordset.findnext(quer)

In fact, you can use any valid SQL syntax. Search this site and you'll come up with at least one good article on SQL. Alternatively, Google for it or get a decent Database book. Any of the following are superb reads...

An Introduction To Database Systems - CJ Date (Date is the Database Guru).
Fundamentals Of Database Systems - Elmasri & Navathe
Database Principles, Programming And Performance -  O'Neil & O'Neil

Hi Louis,

Thanks for informing me about it. But it would be great if you could also provide with an example. I mean where do we write the Select * from... statement, in case I am accessing the database using the Jet engine and searching through the database using the Recordset.FindNext command.

Regards,
NJ

If I remember rightly, the parameter to FindNext should be a string, which takes the form of an SQL predicate (the bit after the WHERE keyword).

So, the SQL, "SELECT * FROM Animals WHERE Animals.Name = 'Fido'" becomes:

Code:

myRecordset.FindNext("Animals.Name = 'Fido'")

where myRecordset has previously been bound to the Animals table of your database. Using a statement similar to:

Code:

Set myRecordset = myDatabaseConnection.OpenRecordset("SELECT * FROM Animals")

Thanks for your help. Could you tell me how do I join two tables using recordset.findnext ?

Regards,
NJ

Quote:

Thanks for your help. Could you tell me how do I join two tables using recordset.findnext ?

You can't.

As I said, the string passed to FindNext is the SQL predicate. That's the bit after the WHERE clause. JOIN clauses come before the WHERE clause, so you can't do a JOIN with FindNext.

Do the JOIN when you open your recordset:

Code:

Set myRecordset = myDatabaseConnection.OpenRecordset("SELECT * FROM Animals JOIN People ON Animals.OwnerID = People.ID")

If you feel you need to brush up on your SQL, there's some good tutorials on the web. James Crowley has one for this very site. And there's a good tutorial  from w3schools.

        I really want to commend the effort of the managers of developer fusion, I have really benefitted alot from this site.

        It is only the good Lord that can reward you, please keep up the good work. You won't breakdown but you will breakthrough and break records.

                                                                                          BRAVO.

Post the highlighted statement from the debugger

Sorry My response to the issue at hand was overwritten when I pasted the last statement.

I found it; it was just a typo.

Who will guard the guards?
The Special Forces ie. Navy Seals, Rangers, Para-rescue, and the Green Berets.
You dont mess with them.

What? Where the heck did that come from?

This tutorial has been really good for helping me understand how to use access databases, which is really cool, but unfortunately I'm having a problem.

When writing the code for moddefaultdatabase I set rstpeople and rstanimals as RecordSet's as shown, but when I come to set them, as show lower down in the example, I can't. The actual problem occurs during run time (error code 13) and I'm told i have a type mismatch.

I've tried editing out the "set rstpeople ="/"rstanimals =" bits and just left the db.OpenRecordset(strSQL) and the program will compile past this point. I've also put an if staement in that will only run the offending code IF the db is actually an opened database, so I'm pretty certain the database is open to access.

I just can't set the recordset's to the any tables in the database.

Any ideas?

Ste

hi sir!

i hav read your article fully,i also read many articles on vb databases i understand it well yet i hav have a problem if you kindly help me.

i want to develop a vb application that will takes data as input ,interpret that data and then display that data in complex spreadsheat like Excel. would you kindly till me what i do with it.

thanks

Regards  Faisalwadood.      Email id: faisalwadood2002@yahoo.com