Exporting my list of queries (1 Viewer)

[kleaves]

HI, I have a number of queris within my access database and I wish to export the list of queries. Is there any way in which I can do this? Or Am I going to have to retype the list in word? :-(

 

[KeithG]

Paste the below SQL into the query designer


SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Type)=5));


then export the query

 

[kleaves]

Keith

Thanks, for the quick response - thats exactly what I wanted.

Kleaves

 

[AccessJunkie]

You might also want to try my free CSD Tools Access add-in. It documents many areas of your database and you can export most reports directly to Word or Excel.

You can find the free add-in here:

http://home.bendbroadband.com/conradsystems/accessjunkie/csdtools.html

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

 

[boblarson]

AccessJunkie:

GREAT TOOL!!!! I'm impressed and thanks for providing it. It is highly appreciated.

 

[AccessJunkie]

Thanks for the feedback Bob!

I'm glad you found my CSD Tools useful.

BTW, you signed the agreement so you're one of US now!

<sinister laugh>


--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

 

[boblarson]

I've been an "Access Junkie" for years (love/hate relationship)

 

[johncallaghan]

I echo Boblarson's comments Great Tool!!

Thanks

John

 

[AccessJunkie]

I've been an "Access Junkie" for years (love/hate relationship)

Excellent, the Collective grows....


--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

 

[AccessJunkie]

I echo Boblarson's comments Great Tool!!

Thanks John!


--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com