Access 2000 - Print queries in "design view"

[Red]

Wolud like to print queries and their join relations, without using the printscreen shortcut (eg. some queries don't fit in the "design view" window, without a pagedown ...)

Thanks

 

[Jeff Boyce]

Red

As far as I know, you can either printscreen the query, or select the SQL
representation and copy/paste the SQL statement. I don't know of any other
options, unless there's a third-party tool that does this.

 

[Jay Vinton]

Wolud like to print queries and their join relations, without using the printscreen

Hi Red,

Other than selecting the text and pasting it into Notepad, try this.

Sub Foo()

Dim qd As QueryDef

For Each qd in CurrentDB.QueryDefs

With qd

' You can write it to a text file, another table, etc.
' Add an If block to get more specific

Debug.Print .Name
Debug.Print .SQL
Debug.Print

End With

Next

Set qd = Nothing

End Sub

Hope that helps

Jay