Results 1 to 3 of 3
  1. #1
    paddymx is offline Advanced Beginner
    Windows 7 64bit Access 2003
    Join Date
    Jan 2012
    Posts
    44

    Table of contents question

    I have followed the instructions for making a table of contents as per http://support.microsoft.com/kb/131588 but it appears that a query is still running after I have run the code. If I try to view the table of contents table in design mode I get the error message that I can only open it as read only because a query or form is open. I have to close the DB and re open it to make any changes to the TOC tbl. Is there a way to "kill" whatever is running. It just doesn't seam right to have something running in the background that I can't see or find. Any ideas?...TNX

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows XP Access 2003
    Join Date
    Aug 2013
    Posts
    7,862
    Try adding
    toctable.close

    directly after
    toctable.update

    However, if you try to print the report more than once after opening the report, it may not work.

  3. #3
    paddymx is offline Advanced Beginner
    Windows 7 64bit Access 2003
    Join Date
    Jan 2012
    Posts
    44
    Thanks but I tried putting that on the close event of the TOC report but didn't help. Actually I added a function to my TOCMod :

    Function CloseTOC()
    TocTable.Close
    End Function

    and called that =CloseTOC() . Wouldn't that do the same thing except after all the "Updates" ? Or should I do it after each update in the source report or on its close event?

    EDIT: I added my function to the close event of the source report and that solved the problem. TOC still printed and the Table of Contents table let me open it in design mode. No problem re running the source report either.


    Thanks!

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

Similar Threads

  1. Table of Contents
    By Alex Motilal in forum Reports
    Replies: 1
    Last Post: 09-17-2012, 10:48 AM
  2. Replies: 5
    Last Post: 04-18-2012, 12:04 PM
  3. Lock table contents?
    By Jaymond Flurrie in forum Access
    Replies: 1
    Last Post: 01-03-2012, 12:24 PM
  4. Replies: 5
    Last Post: 12-08-2011, 10:52 AM
  5. Categorizing table contents
    By Alaa Wasfy in forum Database Design
    Replies: 1
    Last Post: 11-07-2011, 02:41 AM

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