search

hi thr!!
well you pls try it and in case you still face some problem you r more than welcome to ask.
if you need a working example for that you can c that while you use MSDN.
if you have MSDN installed on your machine you can open that and can c how the indexed search works.
that is very very beautiful, robust and userfriendly work for search.
again if you get some problems pls let me know, I'll be happy to assist you.
I've implemented that in few of my projects.

In one of my post to your reply i think i was harsh enough to annoy not only you but some other members also. Pls dont mind that and believe me, my intentions were not to harass you in any case nor to show that you dont know anything or so... what i intended was if you r having a feeling of getting the perfect solutions from the forum, then pls change your attitude as this will be harmful for you in future thats all.
still if you feel bad for that i appoligize, if i have hurt you in any case.
again you r most welcome to put your doubts and problems forward to get solns, as we too improve with every solutions we provide.

Take Care

HI pranay,

sorry if i have replied wrongly......
I think let us leave this topic.

please tell me that....i have dout that if we open the recorset and connection in form load, then whether we have to close there itself or no need to close?


Thank u

sowmya s

hey sowmya s,
you r most welcome to ask anytime when ever you feel like trapped.
it will be my pleasure to assist you in anyof your such works. pls feel free to ask any doubts or problem you r facing with your project.

Take Care!!

hi,
thank u...........

I have one form by name employee and i have connected to database thru ADODB,in form load.............and recordset is opened and not closed in form load

now i want to know whether if i want in other event like changeeventin same form then i have to open recordset again or not........for ex:rs.open "select empid from employee",con

please clear this doubt

thank u..

great!!
now lets come to point!!
well when you r using a connection throughout the form you need not close that all the time else you will have to reopen that again and again but you should close the recordsets all the time you open it else it may lead to the error.

pls write back if you need some more clarifications.

hi thr,
if you r not using the recordset in formload then pls do not open it there,
you can declare and open the recordset in the event where you need any information or data interaction from database.
pls close the recordset and set it to nothing when you no longer needs that.

if it confuses you drop me a code and i will let you know how to do that.

to be clear,
if you r using one recordset in an event say addnew_click and not closing it and again in some other event you want to use the same recordset say in save_click then if the recordset is not closed it will give an error provided you have fired addnew_click prior to save_click.
Hope it will give you a clearer picture.

HI
ok..thank u.


what this error means

OPERATION IS NOT ALLOWED WHEN OBJECT IS OPEN


Actually i opened recordset of dependent in load form and not closed.......
And now iam opening recorset employee in change event.........
it is giving error as above

what will be my mistake?

help

thank u

well that is due to some recordset is open.
close the recordset when you have finished doing a task with that.
and c it will work then.
actually when you have some object already open but not closed how will you open it again.
to avoid such situations you can also do one thing like check the status of the recordset before opening.
in your second event you can write :
if rs.state= adstateopen then rs.close
and after this you can write your other query with same recordset.
this statement will check the status of the recordset (rs) and if found open it will close that explicitly before other rs.open gets called.

Hope It Helps!!
Take Care.