Connecting Tech Pros Worldwide Forums | Help | Site Map

help me please

Newbie
 
Join Date: Oct 2008
Location: Bahrain
Posts: 5
#1: Dec 5 '08
hi,

i was wondering if anyone can help me solving a simple problem
i used comand button to search for data in access using the data control

Error

type missmatch

this is my code
Expand|Select|Wrap|Line Numbers
  1. private sub cmd_search_click()
  2. srch= inputbox(srch) ("enter Telephone number")
  3. srch "Telephone=" + srch
  4. msgbox(srch)
  5. data1.recordset.findfirst srch
  6. end sub
  7.  

Dököll's Avatar
Moderator
 
Join Date: Nov 2006
Location: Upstate NY - US
Posts: 2,268
#2: Dec 6 '08

re: help me please


You may need to add a reference...
Newbie
 
Join Date: Oct 2008
Location: Bahrain
Posts: 5
#3: Dec 6 '08

re: help me please


hi,
what do you mean with reference and where i shall add it?
thank you

regards
lotus18's Avatar
Site Addict
 
Join Date: Nov 2007
Location: Zamboanga City, Philippines
Posts: 860
#4: Dec 6 '08

re: help me please


Quote:

Originally Posted by Dököll View Post

You may need to add a reference...

I think adding a new reference is not necessary here because sweettama uses only a data control in vb6.

To sweettama, I doubt that your sample code posted here is working.



Rey Sean
Dököll's Avatar
Moderator
 
Join Date: Nov 2006
Location: Upstate NY - US
Posts: 2,268
#5: Dec 6 '08

re: help me please


Quote:

Originally Posted by lotus18 View Post

I think adding a new reference is not necessary here because sweettama uses only a data control in vb6.

To sweettama, I doubt that your sample code posted here is working.



Rey Sean

Thanks lotus18!

I get these a lot using access, usually leads to a reference... I reckon you're right though, thanks for coming to aid:-)

Dököll
Banned
 
Join Date: Oct 2008
Location: Lahore Pakistan
Posts: 82
#6: Mar 29 '09

re: help me please


I m sorry i didnt read the date :)
Reply