Well, u keep yourself far away from the Seek method !!! ???
Can u advice me what to use insted of the Seek method, u must be using more powerfull method.
Regards
>>Thank u Eric for u r reply.
>>
>>Eric, can u please help me in this problem am not able to solve it :
>>
>>My program crashes whenever I click the button, this button has a code to search for a data in the Access data file .mdb :
>>The code is :
>>.Seek Array(CStr(rstContract!ContractNo), CStr(strMonth), CStr(strYear)), adSeekFirstEQ
>>
>>The index file in the .mdb is :
>>Contractno (and have indexes 3 fields) field1, field2, field3
>>
>>Note:
>>The system crash stops when I change the code to the following, like searching only for one value (field):
>>.Seek Array(CStr(rstContract!ContractNo)), adSeekFirstEQ
>>
>>What I did:
>>- Reinstalled VB + SP4
>>- Reinstalled Access þ2000þþ
>>
>>All what I did, didn’t help, problem still exist?
>>
>>Any advice please
>
>I can't help on that one. I don't have Access 2000 installed on my computer and I keep myself far away from the Seek method!
<><><><><><><><><><><><><><><><><><><><>
<><> REMEMBER,,,,KNOWLEDGE IS POWER <><>
<><><><><><><><><><><><><><><><><><><><>