ADODC Problem (It's making me nuts!!!)

Ok, I paste a Microsoft ADODC (with sp6) on a form, sets up all the connection, assigns a table, but when I run the program it is disabled at runtime , I paste another control on it's side, a native visual basic data control, I open the same database, and it runs fine. What the heck is going on here!!! I am literally going bonkers over this one. HELP!!! Is there a bug on the updates I installed (Visual studio service packs etc.)? I'm Using XP BTW. If anyone has any explanation please, I beg of you, for the love of God, help me!!!! Ahhhrrrrgggg!!!! I'ts making me nuts!!! Did I mention that it's driving me crazy!!?!?!? ok. bye.

Okay, as soon your head stops spinning and I'm done wiping off all the split pea soup off me hehe...

I'll give you a hint. go to the form load event and put ANY valid code in there and put a breakpoint on that line.

Run your project to the breakpoint

Open your locals window.
Click on me to expand
Click on the name of your control, perhaps it is ADODC1??? to expand that too
Scroll down to Recordset. What does it say?

NOTHING

now, how do we get a control, say in MS Access for instance, to get the latest data form a database ...

guess yet??? ....

(controlname).refresh

Add that line of code and then step that code and look again at the locals window. Ta Da. You have a recordset!!! Oh yeah, and you can see that the form will have an enabled control now once you finish stepping through the form load.

You can also type on-demand commands during debug by typing them into the immediate window. In otherwords you could test this theory by simply entering it into the immedate window exactly as it would appear in a line of code and it does the same thing.

This is a very valuable skill to have, to be able to browse objects and understand what you see, check locals, use the immediate window because ... it is what you will need every time you encounter a new library. (the files where the code for the controls come from).

Now put yer head back on

^_^

Well, What to say, um.......hhhmmmmm... How 'bout, Marry Me!!! Ok, that is way too much ,....... My face is now literally a prune from all the tears that has drowned the feelings of sorrow from the now obsolete problem that has plagued me since the dawn of last week. One cannot find the words to describe the feeling of release that you, a savior of saviors, the epitome of charity, that if one opens an encyclopedia and looks for the word "Devine Helper", your face would probably in it, Oh merciful woman of ever wondrous answers, you do not know the extent of your words, how it has touched and delivered me from certain demise. I, your humble servant, is now forever in your debt, ask anything, and you shall have it (except money and all the things that money can buy. )

Again, I thank you, and may the light of passion govern your every decision so that you may have the sight to see the others that may also need your help.

YOU are absolutely hysterical, it was a pleasure helping ...