A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Printing a query design?



 
 
Thread Tools Display Modes
  #1  
Old August 9th, 2004, 05:30 PM
JethroUK
external usenet poster
 
Posts: n/a
Default Printing a query design?

How do I print out a query design (as per design view)?


  #2  
Old August 9th, 2004, 06:52 PM
fredg
external usenet poster
 
Posts: n/a
Default Printing a query design?

On Mon, 9 Aug 2004 17:30:34 +0100, JethroUK wrote:

How do I print out a query design (as per design view)?


As far as I know, there is no direct way to print out either the Query
Grid or the Query SQL.

What you can do, if you wish to print out the Grid, is to open the
query in design view, click Shift + Print Screen.
The above copies the window to the clipboard.
Open a Word Document, or Create a new Access Report, or open any
Picture editor (MSPaint, etc.), and paste the clipboard into it. Now
you can print that.

To Print just the SQL, select the text, copy it to the Clipboard using
Ctrl + C, then paste it into a Word or Notepad document. Print that.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
  #3  
Old August 9th, 2004, 07:58 PM
JethroUK©
external usenet poster
 
Posts: n/a
Default Printing a query design?

I'm currently using screen prt method (it's Alt actually, not Shft) but it's
not ideal, just wondered whether there was a built-in method

thanx anyway - i shall look no further )


"fredg" wrote in message
. ..
On Mon, 9 Aug 2004 17:30:34 +0100, JethroUK wrote:

How do I print out a query design (as per design view)?


As far as I know, there is no direct way to print out either the Query
Grid or the Query SQL.

What you can do, if you wish to print out the Grid, is to open the
query in design view, click Shift + Print Screen.
The above copies the window to the clipboard.
Open a Word Document, or Create a new Access Report, or open any
Picture editor (MSPaint, etc.), and paste the clipboard into it. Now
you can print that.

To Print just the SQL, select the text, copy it to the Clipboard using
Ctrl + C, then paste it into a Word or Notepad document. Print that.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Display Parameter from Form on Report sara Setting Up & Running Reports 10 July 19th, 2004 04:54 PM
SELECT function in Query alexparks Running & Setting Up Queries 9 July 5th, 2004 11:31 AM
Stopping query when opening in design view Dkline Running & Setting Up Queries 1 June 16th, 2004 09:50 PM
access query design view - difficult to read dswick Running & Setting Up Queries 1 June 16th, 2004 06:03 PM
query field reference help -dch Running & Setting Up Queries 4 June 2nd, 2004 07:30 PM


All times are GMT +1. The time now is 07:41 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.