serch in tabel which have numeric column

in my tabe i have numeric  column type    it is number
when i use sql  Qerny

  sqlstr = "SELECT * FROM tbl WHERE  num  ='" & TextBox7.Text & "'" 

Open in new window

when i click button give my msg problem ("deffrent type)
it can complet serch

i use visal basic 2005  and accssess
ziayd2009Asked:
Who is Participating?
 
Carl TawnConnect With a Mentor Systems and Integration DeveloperCommented:
You need to lose the apostrophes:
sqlstr = "SELECT * FROM tbl WHERE num = " & TextBox7.Text

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.