Member Avatar for bogdan1sucku

Hello,
I'm having a bit of a problem building a search form in my visual basic database.
I tried (LIKE @Column + '%') or ('*'). No use because its not showing me the text box in wich i can actually search.
I think i'm having this problem because i've imported the database from Access and the columns are not declared in Visual Basic.
Can i build a diffrent search form? ( Text box + button or smthg... )

I appreciate any kind of help!

Thank You,
Andres Bogdan.

  • 2 Contributors
  • 1 Reply
  • 80 Views
  • 15 Hours Discussion Span
  • Latest Post Latest Post by agrothe
Member Avatar for agrothe

Ok, first off, is the database connection working? What technology are you using for database connectivity? DAO or ADO?

You build your query by including a text box value in the query string and then send the query via recordset or command object to the database.

So if you have a text box called txtSearch,

dim qry as string
qry = "Select * from sometable WHERE somecolumn LIKE '%" & txtSearch & "%' ORDER BY somecolumn ASC;"

Pass that to your database to receive the information back...

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.