help me please

[sweettama]

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

private sub cmd_search_click()
srch= inputbox(srch) ("enter Telephone number")
srch "Telephone=" + srch
msgbox(srch)
data1.recordset.findfirst srch
end sub
 

[Dököll]

You may need to add a reference...

[sweettama]

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

regards

[lotus18]

@Dököll
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]

@lotus18
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

[EYE4U]

I m sorry i didnt read the date :)