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
>>Dear all,
>>
>>I want to know, What is the best way to make a “contract format” or a “receipt format” to be printed from the VB project.
>>
>>Shall I use the printing commands in VB to specify the printing position for each column, or it can be done thru a report generator like Crystal Reports.
>
>
>Reports are always better served by a report generator.
<><><><><><><><><><><><><><><><><><><><>
<><> REMEMBER,,,,KNOWLEDGE IS POWER <><>
<><><><><><><><><><><><><><><><><><><><>