[AccessD] Ot - Print Full table descriptions as in relationship

Marty

Thank you I appreciate your help. They both look very interesting and
useful.  I downloaded and copied both.  Now I just have to figure out
how I can get them to work. First on Access2k then Acc2003. 

Have you used the one from Allen Brownes?  I set up the module and tried
use both in the intermediate window and a form but I can not get it to
complete.  The tables are linked from Oracle and it times out.  I need
to find where I can set the ODBC time out to 6000 for it to run - so far
no luck.

SO I tried to set up a form with the command button as described in the
documentation  but keep getting errors. Do you have an example of the
code for the form?

Thanks again for you help - have a great weekend

**************************************************
* Patricia O'Connor
* Associate Computer Programmer Analyst
* OTDA - BDMA
* (W) mailto:Patricia.O'Connor at otda.state.ny.us
* (w) mailto:aa1160 at nysemail.state.ny.us
**************************************************
 

> 
--------------------------------------------------------
This e-mail, including any attachments, may be confidential, privileged or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy or otherwise use this e-mail or its attachments.  Please notify the sender immediately by reply e-mail and delete the e-mail from your system. 


-----Original Message-----

> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> MartyConnelly
> Sent: Friday, July 21, 2006 02:24 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Ot - Print Full table descriptions as 
> in relationship
> 
> 
> You may have to use this to make multiple views of relationships
> 
> http://www.lebans.com/saverelationshipview.htm
> 
>  From Allen Brownes notes
> One more suggestion: if you have a large database with too 
> many tables to fit on screen,  Stephen Lebans has a utility 
> to save multiple relationship views,  and load them again 
> later. With this extended printout combined with his multiple 
> relationships view, you will be able to stay on top of your database.
> 
> Relationship Report with extended field information If you 
> need to print field info as well
> 
> http://allenbrowne.com/AppRelReport.html
> 
> O'Connor, Patricia (OTDA) wrote:
> 
> >Someone in my office wants to print several tables like they 
> appear in 
> >the relationships. The problem is that a few are big and end 
> up with a 
> >scroll bar so the entire table doesn't get printed. Is there 
> a way to 
> >get it to totally print?
> >
> >Is there another way besides dataflow diagram or if not do 
> you know of 
> >a freeware DFD that would be easy to use?
> >
> >I would probably use oracle Pl/sql DESC then copy the result 
> to excel, 
> >word, or powerpoint.  BTW I can't use DESC via the Access 
> passthru. Is 
> >there a special way to get this
> >
> >Thanks
> >**************************************************
> >* Patricia O'Connor
> >* Associate Computer Programmer Analyst
> >* OTDA - BDMA
> >* (W) mailto:Patricia.O'Connor at otda.state.ny.us
> >* (w) mailto:aa1160 at nysemail.state.ny.us
> >**************************************************
> >--------------------------------------------------------
> >This e-mail, including any attachments, may be confidential, 
> privileged or otherwise legally protected. It is intended 
> only for the addressee. If you received this e-mail in error 
> or from someone who was not authorized to send it to you, do 
> not disseminate, copy or otherwise use this e-mail or its 
> attachments.  Please notify the sender immediately by reply 
> e-mail and delete the e-mail from your system.
> >  
> >
> 
> --
> Marty Connelly
> Victoria, B.C.
> Canada
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>