Microsoft KB Archive/162065

{|
 * width="100%"|

Microsoft Access 97 Articles Available by E-Mail: Queries

 * }

Q162065

-

The information in this article applies to:


 * Microsoft Access 97

-

SUMMARY
This article shows you how to obtain support information from the Microsoft Knowledge Base by e-mail. If you are currently viewing this article on the World Wide Web, this information may not pertain to you.

MORE INFORMATION
The "Article Listing" section of this article includes a subset of Knowledge Base articles about Queries in Microsoft Access 97. Use the instructions in the "Ordering an Article by E-Mail" section of this article to order items from this list.

Note that because Microsoft Product Support Services is constantly adding new information to the Knowledge Base, not all articles are listed here. For this reason, you may want to look on the Web to find the information you are looking for. Microsoft Product Support Services on the Web is located at the following address on the World Wide Web:

http://www.microsoft.com/support

Ordering an Article by E-Mail
To have an article from the list sent to you in e-mail, send a message to "mshelp@microsoft.com" (without the quotation marks), and use the Article ID in the subject line of the message, as in the following example:

TO: mshelp@microsoft.com

SUBJECT: Q119591

For more information about how to order an article by e-mail, send an e-mail message to the following e-mail address:

  mshelp@microsoft.com

ARTICLE LISTING
ITEM ID ARTICLE TITLE PAGES

--

Q90809 ACC: How to Use a Query to Filter Unique Data 2

Q91710 ACC: "Can't Bind Name '[XXX]'" Error with Crosstab Query 3

Q93690 ACC: How to Update a Table Based on Values in a Second Table 2

Q95608 ACC: How to Parse Comma-Separated Text into Multiple Fields 4

Q95931 ACC: How to Use the Query-by-Form (QBF) Technique 4

Q98664 ACC: Deleting Duplicate Records from Two Tables 3

Q99321 ACC: Tips for Optimizing Queries on Attached SQL Tables 3

Q100135 ACC: How to Search for Characters or Strings in Records 4

Q101081 ACC: Referring to a Field in the Previous or Next Record 6

Q103269 ACC: Updating a Table from a Second Table Using an Expression 2

Q109329 ACC: How to Delete Duplicate Records from a Table 2

Q112108 ACC: How to Create an SQL Pass-Through Query in Code 3

Q112112 ACC: How to Optimize Queries in MS Access v. 2.0, 95, and 97 7

Q131534 ACC: How to Simulate Parameters in an SQL Pass-Through Query 4

Q136062 ACC: Query by Form (QBF) Using Dynamic QueryDef (95/97) 5

Q138911 ACC: How to Create Running Totals in a Query (95/97) 5

Q154600 ACC: How to Parse Titles Beginning with "A," "An," or "The" 2

Q159731 ACC97: Why a Calculated Control Is Blank 1

Q161329 ACC97: Error: "There Isn't Enough Disk Space or Memory" 5

Q161861 ACC97: "Can't Represent the Join Expression" in Query Design 5

Q162977 ACC97: ASP Query Cannot Be Used with the LIKE Predicate 5

Q163443 ACC97: Action Queries Cannot Be Exported to HTML, IDC, or ASP 5

Q163536 ACC97: Doc Error: Cannot Export Queries or Macros from 97 to 95 2

Q163703 ACC: RecordsAffected Property Incorrect for SQL Pass-Through 4

Q163943 ACC97: IPF in Msjet35.dll Running Update Against Attached Table 5

Q164239 ACC97: InputBox Error: "Function Isn't Available in Expressions" 4

Q164481 ACC97: Tips for Converting Applications to Using ODBCDirect 10

Q165035 ACC: Combo Box Wizard Doesn't Display Third Option w/SQL Stmt 2

Q165272 ACC: Error Message "Can't open any more tables" 3

Q165823 ACC: Database Grows Rapidly When You Modify SQL Statements 4

Q166634 ACC97: Filter-by-Form Example for Run-Time Apps Available in Download Center 2

Q167851 ACC97: Canceling Parameter Prompt Stops Publish To Web Wizard 3

Q168438 ACC97: Changes with DISTINCTROW in Microsoft Access 97 4

Q168870 ACC97: Can't Export If File Name Is More Than 60 Characters 3

Q168874 ACC97: Publish to the Web Wizard Fails on SQL Specific Query 3

Q170218 ACC97: SQL Memo Fields Truncated to 255 in Update Query 3

Q174341 ACC97: Failed Append Query Causes Bloat in Multi-User Database 4

Additional query words: article list

Keywords :

Issue type :

Technology : kbAccessSearch