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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|