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 » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Access 2000 Print Relationship Manager



 
 
Thread Tools Display Modes
  #1  
Old June 23rd, 2004, 04:39 PM
Red
external usenet poster
 
Posts: n/a
Default Access 2000 Print Relationship Manager

Hi
I'm trying to print some queries and respective relationships in Access 2000. I Know i can use the printscreen shortcut but I would rather print it directly from Access. I Know Access 97 had a file prels80.exe that could be installed and would permit to do the job. Does Access 2000 support this utility file? Or is possible to do it using other possibility? I've tried the Tools\Relationships but I couldn't understand/print nothing

Thanks
  #2  
Old June 23rd, 2004, 05:09 PM
Joan Wild
external usenet poster
 
Posts: n/a
Default Access 2000 Print Relationship Manager

When you open the Relationships window, you should find a 'Print
Relationships' item in the File menu - that will do the same as the utility
did in 97.

Red wrote:
Hi
I'm trying to print some queries and respective relationships in
Access 2000. I Know i can use the printscreen shortcut but I would
rather print it directly from Access. I Know Access 97 had a file
prels80.exe that could be installed and would permit to do the job.
Does Access 2000 support this utility file? Or is possible to do it
using other possibility? I've tried the Tools\Relationships but I
couldn't understand/print nothing

Thanks


--
Joan Wild
Microsoft Access MVP


  #3  
Old June 23rd, 2004, 05:39 PM
Red
external usenet poster
 
Posts: n/a
Default Access 2000 Print Relationship Manager

The problem with the Relationships window is that wnhen I open a query that have links with other queries or tables, it doesn't show those links. Am I doing something wrong?
Thanks



"Joan Wild" wrote:

When you open the Relationships window, you should find a 'Print
Relationships' item in the File menu - that will do the same as the utility
did in 97.

Red wrote:
Hi
I'm trying to print some queries and respective relationships in
Access 2000. I Know i can use the printscreen shortcut but I would
rather print it directly from Access. I Know Access 97 had a file
prels80.exe that could be installed and would permit to do the job.
Does Access 2000 support this utility file? Or is possible to do it
using other possibility? I've tried the Tools\Relationships but I
couldn't understand/print nothing

Thanks


--
Joan Wild
Microsoft Access MVP



  #4  
Old June 23rd, 2004, 11:01 PM
Joan Wild
external usenet poster
 
Posts: n/a
Default Access 2000 Print Relationship Manager

Have you actually defined relationships in the relationships window? If so,
any queries you create will use these by default.

Queries will not automatically create join lines between queries.

--
Joan Wild
Microsoft Access MVP

Red wrote:
The problem with the Relationships window is that wnhen I open a
query that have links with other queries or tables, it doesn't show
those links. Am I doing something wrong? Thanks



"Joan Wild" wrote:

When you open the Relationships window, you should find a 'Print
Relationships' item in the File menu - that will do the same as the
utility did in 97.

Red wrote:
Hi
I'm trying to print some queries and respective relationships in
Access 2000. I Know i can use the printscreen shortcut but I would
rather print it directly from Access. I Know Access 97 had a file
prels80.exe that could be installed and would permit to do the job.
Does Access 2000 support this utility file? Or is possible to do it
using other possibility? I've tried the Tools\Relationships but I
couldn't understand/print nothing

Thanks


--
Joan Wild
Microsoft Access MVP




  #5  
Old June 25th, 2004, 09:12 AM
david epsom dot com dot au
external usenet poster
 
Posts: n/a
Default Access 2000 Print Relationship Manager

Do you have the 'enable autojoin' option set (on the table/query
option page)?

(david)

"Red" wrote in message
...
The problem with the Relationships window is that wnhen I open a query

that have links with other queries or tables, it doesn't show those links.
Am I doing something wrong?
Thanks



"Joan Wild" wrote:

When you open the Relationships window, you should find a 'Print
Relationships' item in the File menu - that will do the same as the

utility
did in 97.

Red wrote:
Hi
I'm trying to print some queries and respective relationships in
Access 2000. I Know i can use the printscreen shortcut but I would
rather print it directly from Access. I Know Access 97 had a file
prels80.exe that could be installed and would permit to do the job.
Does Access 2000 support this utility file? Or is possible to do it
using other possibility? I've tried the Tools\Relationships but I
couldn't understand/print nothing

Thanks


--
Joan Wild
Microsoft Access MVP





 




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


All times are GMT +1. The time now is 05:17 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.