Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2002
    Posts
    7

    Unanswered: Formatting VBA modules for printing

    Okay, folks...

    As a part of my documentation for a large Access97 project, I want to be able to print the class modules behind each report and form. I would like to start each procedure on a new page, and have the procedure name, print date, page number, and date of modification to appear at the top of each page. And I would like for this to happen with a minimum of manual intervention. (I don't want to have to copy and past each procedure into Word, and then format the headers and footers, etc. several hundred times.)

    Any suggestions?

    Thanks in advance!
    Kevin

  2. #2
    Join Date
    Sep 2002
    Location
    Coventry, Warwickshire, UK
    Posts
    74
    Try Tools | Analyze | Documenter
    Roger Hampson
    XI - ecs (UK) Ltd

  3. #3
    Join Date
    Mar 2002
    Posts
    7
    Unless I'm missing something important, it doesn't appear to print the modules which are bound to a form...

    I hope I'm wrong...

    Kevin

  4. #4
    Join Date
    Sep 2002
    Location
    Coventry, Warwickshire, UK
    Posts
    74
    There is an options button on the window which allows you to choose what you want to print, including the the code for a form.
    Roger Hampson
    XI - ecs (UK) Ltd

  5. #5
    Join Date
    Mar 2002
    Posts
    7
    Well DUH! I guess I WAS missing something important. "Code" = "Module"...

    Thanks, Roger, for allowing me to embarrass myself! ;-)

    I'd still like to be able to start each subroutine or function on a separate page, but this'll do for now. I'll try to code a routine to do separate pages in my spare time. If I can make it work, I'll share it...

    Kevin

  6. #6
    Join Date
    Sep 2002
    Location
    Coventry, Warwickshire, UK
    Posts
    74

    Smile

    Any time!
    Roger Hampson
    XI - ecs (UK) Ltd

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •