PC Review


Reply
Thread Tools Rate Thread

creating new querydefs

 
 
Sasha
Guest
Posts: n/a
 
      4th Aug 2003
I"m trying to create some querydefs in VBA...
i have the references set to include the dao library

Dim R1 as dao.recordset
Dim Qry as dao.querydef
qry.name = blah
qry.SQL = "sql string"
currentdb.querydefs.append(qry)

set r1 = qry.openrecordset

I have gotten an assortment of errors, from "not
supported" to "object not set"


pls help!

thanks,
Sasha
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating QueryDefs in Access 2000 Del Microsoft Access VBA Modules 2 4th Jan 2008 11:05 PM
Querydefs =?Utf-8?B?Umlja1c=?= Microsoft Access Queries 2 26th Sep 2006 02:59 PM
QueryDefs ? =?Utf-8?B?TWFyaw==?= Microsoft Access Queries 1 18th Apr 2006 03:14 AM
QueryDefs - DAO vs ADO =?Utf-8?B?TFBT?= Microsoft Access VBA Modules 4 7th Feb 2006 07:46 PM
querydefs =?Utf-8?B?c2Vla2VyNTM=?= Microsoft Access Reports 1 1st Jun 2005 02:46 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:26 AM.