query SQL: search in database reccord that contains specific letter

Hello!
I have a database for medical devices on access! A search userform allows you to select the field you want to search and enter the value of the field you want to search!

With this code I am able to seach for the device but I have to write the entire value correctly to search for the device

Please Login or Register  to view this content.

I want for example, if I want to search for all neuromonitor, to write just "neuro" in the texbox and the query shows me all reccords in the column that contain "neuro"
I'm trying this but it's not working!

Please Login or Register  to view this content.

Any idea?

Thank you for your help!

Thank you for your answer! I tried this code it's not working!

Originally Posted by Norie

How does it not work?

If the query finds nothing that matchs in the database it shows a messagebox and with this code it shows me the messagebox so it finds nothing!!

have you tried using * instead of % depending on the way you're connecting to the database, it could be either

And i'm sure in my search that i have the device in the database!

i check if nothing is found with:

Please Login or Register  to view this content.

I doubt that line of code does what you think it does, you should be checking the recordset's EOF property:

Please Login or Register  to view this content.

@Norie Yes, that's true, but could I thought it could be DAO - so thought it might be worth checking

This is my code if it can helps you!

Please Login or Register  to view this content.

Drop the square brackets, it's searching for them:

Please Login or Register  to view this content.

Originally Posted by Norie

Try this.

Please Login or Register  to view this content.

With this code I have an error on this line :

Please Login or Register  to view this content.

It says: non valid argument

Sorry Norie, I'll keep my neb out

Originally Posted by Norie

Sebastien

I've noticed that for some reason you still have square brackets in the criteria term, they shouldn't be there, the code I posted removed them from the first code you posted.

That could be the reason no records are returned, pretty sure there would be any values with [ or ] in the field.

So try removing those brackets.

Please Login or Register  to view this content.

You're right! It works with your code!! Thanks! I'll retry on several search and see if it works well!!

Everything works well on my laptop (32 bits version) but when I copied the files on the company's computer (64 bits) there was an error message telling me that I need to update the code to 64 bits version and the following paragraph was in red color:

Please Login or Register  to view this content.

Do anyone know how to update the code? Im trying to read some article about compatibility between 32 bits and 64 bits..

Originally Posted by Norie

Sebastien

Is that code anything to do with the code in this post?

If it isn't perhaps it might be an idea to start a new thread.

Yes you're right, I'll mark this one as solved and start another one!

Originally Posted by Norie

Sebastien

Is that code anything to do with the code in this post?

If it isn't perhaps it might be an idea to start a new thread.

Yes you're right, I'll mark this one as solved and start another one!