Search error

[Ali Rizwan]

hi all,
I m using this code for searching with respect to Reg No:

ADODC1.Recordset.Find "Reg No = " & txtREG
 

But it is not searching
Thanx

[jrtox]

hi all,
I m using this code for searching with respect to Reg No:

ADODC1.Recordset.Find "Reg No = " & txtREG
 

But it is not searching
Thanx

Try This One:

Adodc1.CommandType = adCmdText
Adodc1.RecordSource = "SELECT * FROM TableName WHERE FieldName='" & txtREG.Text & "'"
adodc1.refresh

Regards
ervin

[Ali Rizwan]

Try This One:

Adodc1.CommandType = adCmdText
Adodc1.RecordSource = "SELECT * FROM TableName WHERE FieldName='" & txtREG.Text & "'"
adodc1.refresh

Regards
ervin

Thanxxxxxxxxxxxxxxxx Ervin
And this Thanx for answering my all questions at time.

[Ali Rizwan]

Try This One:

Adodc1.CommandType = adCmdText
Adodc1.RecordSource = "SELECT * FROM TableName WHERE FieldName='" & txtREG.Text & "'"
adodc1.refresh

Regards
ervin

Hello Ervin,
This code is doing nothing.
I have a database named Information
Table Name is Info
And i have to search about Name and Reg No both.
Please solve the problem
Thanx

[hariharanmca]

Hello Ervin,
This code is doing nothing.
I......Thanx

Try the below code.

    Adodc1.CommandType = adCmdUnknown
    Adodc1.RecordSource = "SELECT * FROM TableName WHERE strFieldName Like '" & txtREG.Text & "' or numberFieldName = " & val(txtREG.Text)
    Adodc1.Refresh
    Adodc1.Recordset.MoveFirst
    MsgBox " No. Record : " & Adodc1.Recordset.RecordCount

[Killer42]

I wouldn't bother with the Val() function, since you're placing it into a string anyway.

[hariharanmca]

That's sample for number field and string field (he is not clear with where clause). Not exactly to the search value..

The sample like below.

 Adodc1.RecordSource = "SELECT * FROM TableName WHERE strFieldName Like '" & txtStringValue.Text & "' or numberFieldName = " & val(txtNumericValue.Text)

[Ali Rizwan]

Thanks all of you for helping me a lot.
Thans again.

[Ali Rizwan]

Try the below code.

    Adodc1.CommandType = adCmdUnknown
    Adodc1.RecordSource = "SELECT * FROM TableName WHERE strFieldName Like '" & txtREG.Text & "' or numberFieldName = " & val(txtREG.Text)
    Adodc1.Refresh
    Adodc1.Recordset.MoveFirst
    MsgBox " No. Record : " & Adodc1.Recordset.RecordCount

Hello hari,
This code works but the problem is that after searching the record we can only see the searched record in the grid.
I want to see other records too.
Thanx

[hariharanmca]

Hello hari,
This code works but the problem is that after searching the record we can only see the searched record in the grid.
I want to see other records too.
Thanx

You want to search like

If you type 'A' then the recordset should select name starts with 'A'?
Can you explain properly?

[Ali Rizwan]

You want to search like

If you type 'A' then the recordset should select name starts with 'A'?
Can you explain properly?

Yeah this one and this too

Suppose i have following records in name field
ABC
ABD
BCD
BBG
XYZ

Now using your code i select ABC to search
Now the DataGrid only shows the record ABC but not ABD,BCD,BBG.XYZ
I want to show all of records.

Thanx

[hariharanmca]

Yeah this one and this too
................

Purpose of where clause is to select particular record then why you want to display all records?

[Ali Rizwan]

You want to search like

If you type 'A' then the recordset should select name starts with 'A'?
Can you explain properly?

Hello Hari,
One more problem occuring.
When i enter a Field name with a space then it show an error and does not search.
I have search for field Reg No it does not search.
Thanks

[Ali Rizwan]

Purpose of where clause is to select particular record then why you want to display all records?

I have labels too connected with same database which show only one record at a time.
When i search the required record shows in labels but i dont want to do the same thing to DGrid. i want to show all records here. But the required record will focused automatically when i searched.
Thanx

[hariharanmca]

Hello Hari,
One more problem occuring.

User Trim() function for the text box like...

Trim(txtStrValue.Text)

You have to explain what is that error?

[Ali Rizwan]

User Trim() function for the text box like...

Trim(txtStrValue.Text)

You have to explain what is that error?

Hello,

I have write this code

 
Dim es As Integer
es = SADD.txtTemp.Text
 
    ADATA.CommandType = adCmdUnknown
    ADATA.RecordSource = "SELECT * FROM info WHERE Reg No Like '" &    SADD.txtTemp.Text & "' "
    ADATA.Refresh
    ADATA.Recordset.MoveFirst
 
 

and the error is in

ADATA.RecordSource = "SELECT * FROM info WHERE Reg No Like '" &    SADD.txtTemp.Text & "' "

and error is
Syntax error (missing operator) in query expression 'Reg No Like '3"

Thanx

[hariharanmca]

Access versions will not allow space between field names Check that.

Reg No should be RegNo

[Ali Rizwan]

Access versions will not allow space between field names Check that.

Reg No should be RegNo

No i have office XP 2004 and i have many fields with spaces like Roll No etc and access doesnot give any error.
Thanks

[Killer42]

Spaces within (not "between", Hari) field names are not a problem for Access. But if you're building an SQL string, I believe they can cause confusion. Putting [square brackets] around the field name may help.

As the error message indicated, the SQL interpreter didn't know what to make of "Reg No" - it took "Reg" as the field name, and couldn't work out what sort of operation "No" was supposed to indicate.

[hariharanmca]

Okay I agree...................................!

[Killer42]

:) It's just lucky the field name wasn't something like "Reg Like" or we could have some real confusion.

[hariharanmca]

:) It's just lucky the field name wasn't something like "Reg Like" or we could have some real confusion.

That's why i always suggest to use "_" or dont use space betueen field name.
i.e

if i use NameLike it do not show error but it will show error to
Name like. and same as

This reserved words

• Description
• Password
• Name
• Day
• Month
• Year…etc.

[Ali Rizwan]

Hello,
Killer i have tried this too i put two braces around it but nothing done error still occur but now i have changed the field names to RegNo and RollNo.
But now another error occurs but it is not syntax i think its logical.
On some forms the code searches right but on some it does not.
Hari please help how can i debug this.
Thanx

[Killer42]

Killer i have tried this too i put two braces around it but nothing done error still occur but now i have changed the field names to RegNo and RollNo.

If removing the spaces made a difference, then the square brackets should have worked. It might vary depending on what database we're talking about. But you indicated this was Access. Generally, the simplest way to get a query right for Access is to create it in the Query Designer in Access, then copy the SQL that it generates. As long as you don't mind it inserting dozens of extra parentheses, that is.

But now another error occurs but it is not syntax i think its logical.
On some forms the code searches right but on some it does not.
Hari please help how can i debug this.

Well, what is different between the forms? And can you show us the new code? And please provide full details about the new error.

[Ali Rizwan]

Well, what is different between the forms? And can you show us the new code? And please provide full details about the new error.

Thanx killer i have found the error.
I have made som echanges to code but on some codes i forgot to made changes.
Bu now its working.
Yhanx a lot

[Killer42]

Ok. Glad to see you managed to resolve your problem.