greymonkey
Technical User
Hi there,
i have some code:
dbs.querydefs.Delete "QryAddRegChild"
Set qdf = dbs.createquerydef("QryAddRegChild", SQLstring)
To delete the query and then create it again using a modified sql string. (SQLstring)
the trouble i am having is when the query doesn’t exist when it tries to delete it.
Dose any one know of some code to check to see if the query exist.
Also I need to get some data out of a query to form some criteria for running another query. if you know some code for that it would help out a lot.
Cheers,
GreyMonkey
:>
i have some code:
dbs.querydefs.Delete "QryAddRegChild"
Set qdf = dbs.createquerydef("QryAddRegChild", SQLstring)
To delete the query and then create it again using a modified sql string. (SQLstring)
the trouble i am having is when the query doesn’t exist when it tries to delete it.
Dose any one know of some code to check to see if the query exist.
Also I need to get some data out of a query to form some criteria for running another query. if you know some code for that it would help out a lot.
Cheers,
GreyMonkey
:>
