View Full Version : Select query


martijn
02-03-2002, 11:23 PM
I want to select a query from a list of all queries in my database. How can I do this? Could someone help me?

Thanx

raskew
02-03-2002, 11:42 PM
Not sure where you're going with this, however, the following SQL in a query will bring up a listing of your exiting queries:

SELECT Name, Type
FROM MSysObjects
WHERE (((Type)=5) AND ((Left([Name],1))<>"~"));

martijn
02-03-2002, 11:45 PM
Thanx, that's what i needed!

martijn
02-04-2002, 12:01 AM
O ja,
What I want to do with it is this:
I have a form, I want to select a query with a combo box, and then I want to generate a MS-Word document of the selected query