Search results

Hello, This sql query is very slow in runtime and takes a long time to return the result, because of the in operator inside query(because the second table includes more than 10000 records) i think i have to change it by using Join commands to increase the speed in runtime. but how do i rewrite...

i think probably it has a method in vba .....because it is must done in adding components including Dll(s) and ocx(s) in access forms.. had u any search for that before this? i think we must find a code sample easily. i help u in searching if u get no answers from Google.

problem solved. i think instead of using instr function we can use Like in DAO. because it is possible to use VBA Functions just inside access Query , Not from vb6's DAO commands. thanx guys

hi guys:) i don't know how should i use substr functions such as substr or instr in a dao sql query!!! for exampe: Select * from Table1 where instr(1,field1,'martin')>0 it doesn't work in vb6 dao(SP6) but it could run in access in one query:confused:.

hi imran i found a dll : ASPDF.dll in adobe reader v7. i used it to preview any pdf file in vb6. and it was free