M martijn Registered User. Local time Today, 11:26 Joined May 13, 2002 Messages 11 Feb 4, 2002 #1 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
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
R raskew AWF VIP Local time Today, 05:26 Joined Jun 2, 2001 Messages 2,731 Feb 4, 2002 #2 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))<>"~"));
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))<>"~"));
M martijn Registered User. Local time Today, 11:26 Joined May 13, 2002 Messages 11 Feb 4, 2002 #3 Thanx, that's what i needed!
M martijn Registered User. Local time Today, 11:26 Joined May 13, 2002 Messages 11 Feb 4, 2002 #4 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
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
