• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 306
  • Last Modified:

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.
0
Novoa
Asked:
Novoa
1 Solution
 
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 new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
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
 
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

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now