The biggest difference between ADO and DAO is that ADO is threadable and DAO is not, which means that ADO is more scalable than DAO. You can use DAO to access a SQL backend database (I've done it a number of times), and I believe that it does work in Access 97 if you set the proper reference...
Sorry Bill,
I used Access 2k2 for the project but Access 2k file format. I have all 3, but of course, I use the latest if there's no reason not to. Frankly, I'm surprised by how many different listboxes are out there. I thought DLL's were supposed to take care of that kind of redundancy?
I just finished porting the project to VB6. The code ported fine except for the "Option Compare Database" statements and the Access Listbox controls. I had to replace the Listbox controls with the ListView Common Control to provide similar functionality. VB's native listboxes don't...
I just finished porting the project to VB6. The code ported fine except for the "Option Compare Database" statements and the Access Listbox controls. I had to replace the Listbox controls with the ListView Common Control to provide similar functionality. VB's native listboxes don't...
Ah, one thing I forgot to mention in the AboutThisProject module, the references. You'll need to have references to the following:
Microsoft DAO 3.6 Object Library
TypeLib Information (TLBINF32.dll)
Microsoft Scripting Runtime (scrrun.dll)
All should be in the System32 directory.
Ah, one thing I forgot to mention in the AboutThisProject module, the references. You'll need to have references to the following:
Microsoft DAO 3.6 Object Library
TypeLib Information (TLBINF32.dll)
Microsoft Scripting Runtime (scrrun.dll)
All should be in the System32 directory.
You can download the project from http://www.linkline.com/personal/tomlane/oopmvc%20release%20copy.mdb
It's a 700KB Access 2002 mdb. Check out the module named AboutThisProject for a description of which classes go with which sample. To run the bound, unbound, and OOP samples, just open the...
You can download the project from http://www.linkline.com/personal/tomlane/oopmvc%20release%20copy.mdb
It's a 700KB Access 2002 mdb. Check out the module named AboutThisProject for a description of which classes go with which sample. To run the bound, unbound, and OOP samples, just open the...
I've been doing an Access project recently, but my previous gig was with Java and it prompted me to explore using OOP techniques with Access, so while I was waiting for my client to get rolling, I developed a non-trivial example of OOP with Access. The example creates a UI for an administrator...
I've been doing an Access project recently, but my previous gig was with Java and it prompted me to explore using OOP techniques with Access, so while I was waiting for my client to get rolling, I developed a non-trivial example of OOP with Access. The example creates a UI for an administrator...
Thanks very much to all who answered. It turns out that Strongm pointed me to what I was looking for. His reply recommending the tlbinf32.dll and this article *Self-aware Data Wrapper Objects with VB* by Syd Egan http://www.vb2themax.com/HtmlDoc.asp?Table=Articles&ID=150
provided me with what...
Thanks, but no, I'm not trying to iterate through a collection. I am trying to iterate through the private members of a class. I am willing to manually create an array of members for each class. Thinking about this a bit more, maybe there is a way. What I originally wanted to do was to map a...
I've been investigating using object oriented programming techniques with VBA (please don't ask why) and ran into a number of problems; one I haven't solved yet: Is there a way to iterate through a class module's members? For example, let's say a create a class named person, that has an ID...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.