Hi guys,
I wonder if you can help? I am trying to create Query Definitions in VBA in Access 2002.
I'm using the book 'Begining Access 2002 VBA', which shows how to do this. On the example database included on a CD with the book, this is possible without problem. However, when I go to declare a variable of type 'QueryDef' in the Access 2002 databases we use at work, the variable type 'QueryDef' just isn't recognised, nor is it listed in the drop down menu you get when declaring a variable.
I was just wondering if anyone could give me any information on this? I really need to be able to create Query Definitions I'm afraid.
One thing that probably is worth mentioning is that the database included with the book utilises DAO, I'm not sure if the Databases we have at work utilise this or ADO. I'm not sure how to check this either to be honest.
If anyone could give me advise on either of these two thing that would be great.
Thanks very much indeed,
Dan.
I wonder if you can help? I am trying to create Query Definitions in VBA in Access 2002.
I'm using the book 'Begining Access 2002 VBA', which shows how to do this. On the example database included on a CD with the book, this is possible without problem. However, when I go to declare a variable of type 'QueryDef' in the Access 2002 databases we use at work, the variable type 'QueryDef' just isn't recognised, nor is it listed in the drop down menu you get when declaring a variable.
I was just wondering if anyone could give me any information on this? I really need to be able to create Query Definitions I'm afraid.
One thing that probably is worth mentioning is that the database included with the book utilises DAO, I'm not sure if the Databases we have at work utilise this or ADO. I'm not sure how to check this either to be honest.
If anyone could give me advise on either of these two thing that would be great.
Thanks very much indeed,
Dan.