Why ? ADO Control vs. ADO Dim XXX as ADODB

So I'm doing well with the ADO connection, but I'm doing it by overkill so some part of it works.
Question is : Why am I drawing and configuring the properties of an ADO data control and THEN having to define it in code Dim As ADODatrabase etc. and THEN having to make a DataEnvironment (per ADO for Dummies book) just so all the commands work i.e.-Move, Absolute Position, Find, FindNext,etc.). Each of the above methods work fine EXCEPT for some of the methods mentioned. FIND seems not to work in any way I try.
NovoaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

NovoaAuthor Commented:
VB is difficult to me ONLY in this area ! Otherwise it's a piece of cake.

Can anyone recommend a class or site that can instruct me into the VB / HTML connection. Would like to write Internet ready stuff.
0
SicilianCommented:
Hi Novoa
   If you're using the ADO data control, you shouldn't have to dim anything. The ADO data control is fickle and I've found that filter and find don't work well together so that might be one of your problems.
   I myself have learned through trial and error so I don't know where would be a good place for you to look. I've been looking at the msdn help files. If you like, I'd be happy to send you a toy app that demonstrates the use of the ADO control. Just leave your email.

Sicilian
0
NovoaAuthor Commented:
My e-mail is manharly@GTE.net
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

dhwanilshahCommented:
can u tell me exactly what the problem is??
0
beregothCommented:
Yeah, I have to agree...we need more information.  Basically I have been of the philosophy for quite some time that I bind nothing and if you are also using the DE, the only thing you will need to dimension will be recordsets to get the content the DE can already supply.  If you can get away with it, the DE is a great solution to getting information, both via straight SQL and stored procedure constructs.

You don't need to use all these parts in tandem to accomplish what you need but in the long run, I strongly believe in using the DE to get the data or run the procedures and manually populate my controls.  And if you are successfully using the DE, you are 90% there.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
NovoaAuthor Commented:
Thank you all, unfortunately your suggestions work but (isn't there always) I'm still having problems. So it's back to the work around drawing board, but I'll muddle through it and have already done most by overkill (multiple methods) what's "supposed" to work does only some times, not enough (clients seem not to undersstand working sometimes ! Strange that !)
Anyway, thanks...
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Delphi

From novice to tech pro — start learning today.