Microsoft KB Archive/888636

= Documenter does not display the DELETE query in Microsoft Access =

Article ID: 888636

Article Last Modified on 12/27/2006

-

APPLIES TO


 * Microsoft Office Access 2007
 * Microsoft Office Access 2003
 * Microsoft Access 2002 Standard Edition
 * Microsoft Access 2000 Standard Edition

-



Moderate: Requires basic macro, coding, and interoperability skills. This article applies only to a Microsoft Access database (.mdb).



SYMPTOMS
When you use Documenter in Microsoft Access, the DELETE query does not appear for a selection in the Documenter dialog box.



WORKAROUND
To work around this problem, you can use one of the following methods. The method that you use depends on the version of Access that is installed on your computer. === Method 1

Access 2000 ===

In Access 2000, you can run a code sample that is similar to the following code sample. You want to do this to document your queries. The following code sample determines the type of query. The following code sample prints the name of the query and the type of query. The following are possible types of queries:
 * SELECT
 * APPEND
 * UNION
 * DELETE
 * CROSSTAB

To run the code sample, follow these steps:  Start Access 2000. Open the database that you want to document. On the Insert menu, click Module.  Put the following code sample in the module that you created in step 2.

Note The following code requires a reference to Microsoft DAO 3.6 Object Library. To add the reference, on the Tools menu in the Visual Basic Editor, click References. Sub printQueries

Dim dbs As Database, qdf As QueryDef ' Return the reference to the current database. Set dbs = CurrentDb ' Update the QueryDefs collection. dbs.QueryDefs.Refresh For Each qdf In dbs.QueryDefs If Left(qdf.Name, 1) <> &quot;~&quot; Then Debug.Print qdf.Name & &quot;: &quot; Select Case qdf.Type  ' Evaluate the type of query. Case 0   ' 0 = Select query. Debug.Print &quot;    Select query&quot; Case 16  ' 16 = Crosstab query Debug.Print &quot;    Crosstab query&quot; Case 32  ' 32 = Delete query. Debug.Print &quot;    Delete query&quot; Case 64  ' 64 = Append query Debug.Print &quot;    Append query&quot; Case 128 ' 128 = Union query Debug.Print &quot;    Union query&quot; Case Else   ' Other values Debug.Print &quot;    Other type of query: Type is: &quot; & qdf.Type End Select '           Debug.Print qdf.Type End If           Next qdf Set dbs = Nothing

End Sub  On the View menu, click Immediate Window. On the Run menu, click Run Sub/UserForm.

Note In the Immediate window, the name of the query and the type of query appear.

=== Method 2

Access 2002 and Office Access 2003 ===

In Access 2002 and in Office Access 2003, you can show hidden objects. You want to show hidden objects to make the DELETE query appear in the Documenter dialog box. To do this, follow these steps:
 * 1) Start Access 2002 or Office Access 2003. Open the database that you want to document.
 * 2) On the Tools menu, click Options, and then click the View tab.
 * 3) On the View tab, click to select the Hidden objects check box, and then click OK.

Note The DELETE query now appears for the hidden objects selection in the Documenter dialog box.

=== Method 3

Access 2007 ===

In Access 2007, you can show the hidden objects to make the DELETE query appear in the Documenter dialog box. To do this, follow these steps:
 * 1) In Access 2007, open the database that you want to document.
 * 2) Right-click Navigation Pane, and then click Navigation Options.
 * 3) In the Navigation Options window, click to select the Show Hidden Objects check box under Display Options, and then click OK.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

<div class="moreinformation_section">

MORE INFORMATION
For more information about using Documenter, click Microsoft Office Access Help on the Help menu, type database documenter in the Search for box in the Assistance pane, and then click Start searching to view the topic.

Additional query words: acc2000 acc2002 acc2003 acc2007

Keywords: kbreport kbdatabase kbdesign kbtshoot kbprb KB888636

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.