If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
DAO REFERENCE
If theer was an award for asking the most questions but answering none..I
would win an award!!! What reference do I need to add in the referene library to use DAO style method of accessing record sets. Also, I using code from peoples help which is maybe a mixture of different types e.g. DAO ADO. Can both styles be referenced in the same database. |
#2
|
|||
|
|||
DAO REFERENCE
Sean,
I am not 100% sure, but I had to add a reference to the 'Microsoft DAO 3.6 Object Library' to get a lot of my code to work. Maybe that's what you're looking for. Nick "SEAN DI''''ANNO" wrote: If theer was an award for asking the most questions but answering none..I would win an award!!! What reference do I need to add in the referene library to use DAO style method of accessing record sets. Also, I using code from peoples help which is maybe a mixture of different types e.g. DAO ADO. Can both styles be referenced in the same database. |
#3
|
|||
|
|||
DAO REFERENCE
Tatakau wrote:
Sean, I am not 100% sure, but I had to add a reference to the 'Microsoft DAO 3.6 Object Library' to get a lot of my code to work. Maybe that's what you're looking for. Nick I agree -- in order to keep the namespace small and manageable (so you don't have to keep specifying which of several you're talking about), and probably also to improve computer performance, you need to explicitly add a reference to use DAOs. "SEAN DI''''ANNO" wrote: If theer was an award for asking the most questions but answering none..I would win an award!!! What reference do I need to add in the referene library to use DAO style method of accessing record sets. Also, I using code from peoples help which is maybe a mixture of different types e.g. DAO ADO. Can both styles be referenced in the same database. Yes, but if you need to use some name that happens to appear in both, you must specify which one you mean. So I suggest adding only the references that you need. And if you have overlapping functions (in the sense of "types of things you might want to do"), you might want to consider converting some of your code, as you have time, to use only one of the available libraries that perform that common function. -- Vincent Johns Please feel free to quote anything I say here. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Flexible Cell Reference | Brandt | General Discussion | 5 | June 2nd, 2005 10:23 PM |
reference cell value from fixed column with variable row | bob z | General Discussion | 0 | May 23rd, 2005 11:30 PM |
Array reference from current row to bottom of column | JM | Worksheet Functions | 0 | February 26th, 2004 01:09 PM |
Reference a workbook based on a cell reference | douga | Worksheet Functions | 1 | February 17th, 2004 06:21 AM |
Can an HLookup Array be a reference from another cell? | Matthew | Worksheet Functions | 2 | September 27th, 2003 03:14 PM |