Results 1 to 3 of 3
  1. #1
    isobadd is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Nov 2017
    Posts
    2

    Documenter Anomaly

    In AC2010, I ran Documenter separately for each object in an application called SIMS (developed in AC2003) and then printed object each as a separate pdf. The Modules block was 74 pages; the Macros block was 125 pages; the Tables block was 2335 pages; the Queries block was 12,989 pages and the Forms block was only 1 page (empty except for header info). After clicking 'Select All' on the 'Forms' tab, I noticed that immediately after clicking 'Run' on the Forms documenter, there was a message of " You've entered an expression that has no value." Within 4-5 seconds, the report appeared as a one (1) page blank document with only the header information for 'Forms' no detail of any of the 100+ forms.
    Any thoughts as to the 'Forms' anomaly are greatly appreciated.
    Thx...Earl

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Just curious --- how many tables in the database to result in 2335 pages; Queries block was 12,989 pages??
    What are you going to/did you do with the output?

    Good luck with your project.

  3. #3
    isobadd is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Nov 2017
    Posts
    2

    Documenter Anaomaly

    Quote Originally Posted by orange View Post
    Just curious --- how many tables in the database to result in 2335 pages; Queries block was 12,989 pages??
    What are you going to/did you do with the output?

    Good luck with your project.
    Understanding first, I designed SIMS ("Security Information Management System") as a database to encompass all facets of a Corporate Security unit within a business entity, very similar to a small police department's needs. Second, there are 34 security related business functional 'modules' comprised within SIMS which I have been evolving in development since 2005. To answer your question directly, there are 308 tables and 1339 queries. All I'm trying to do at this point is document how many objects are in SIMS. Although I know there are 393 Forms, Documenter will not print them, as I described in my initial post.

    thx...

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Database Documenter
    By MrS in forum Access
    Replies: 7
    Last Post: 11-10-2017, 04:53 PM
  2. Create Database Documenter report using VBA
    By edp428 in forum Programming
    Replies: 2
    Last Post: 12-03-2014, 07:18 PM
  3. Date() anomaly
    By Al77 in forum Access
    Replies: 3
    Last Post: 02-15-2012, 04:09 AM
  4. Database Documenter - Queries
    By bf4man in forum Access
    Replies: 2
    Last Post: 08-26-2011, 04:17 PM
  5. Access 2010 Database Documenter
    By Julie417 in forum Access
    Replies: 1
    Last Post: 08-12-2011, 06:24 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums