"CreateQueryDef" in Access2000 3

[Warrior]

Hello everyone,<br><br>When i try to declare a CreateQueryDef statement in VBA in Access2000, Access2000 seems not to recognize my statement.<br><br>When i stand on the createquerydef statement and type &quot;F1&quot; access2000 doesn't find the statement when i type the question in the help itself then he finds the statement with an example.<br><br>When i copy and paste the example of that &quot;CreateQueryDef&quot; statement in my VBA code and try to compile Access2000 even then doesn't recognice the statement as a &quot;legal&quot; Access2000 command.<br><br>Is there anyone who regognize this problem or who knows the answer to this problem<br><br>with regards,<br><br>Warrior

 

[DougP]

Well you stumbled accross reason number 24. Why I hate Access 2000<br><br>Becasue VBA is now a separate program in Access 2000 it does not recognize what used to be part of Access '97.<br>Like database commands<br>Duh what are we using Access 2000 for to draw pictures.<br>Anyway<br>in the VBA program click &quot;Tools&quot; menu then &quot;References&quot;<br><br>And Check these 5 items<br>You have to look down the list for them. Some of them may be already checked.<br><br>Visual Basic for Applications<br>Microsoft Access 9.0 Object Library<br>Microsoft DAO 3.6 Object Library<br>OLE AutoMation<br>Microsoft Visual Basic for Applications Extensibility 5.3<br><br><br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.