Access 97 Articles Available by Fax or E-Mail: Modules & Macros

• Microsoft Access 97

SUMMARY

This article shows you how to obtain support information from the Microsoft Knowledge Base by e-mail or by fax. 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 Modules, Macros, and Expressions in Microsoft Access 97. Use the instructions in the "Ordering an Article by E-Mail or by Fax" section of this article to order items from this list.

Note that because Microsoft Technical Support 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 Technical Support on the Web is located at the following address on the World Wide Web:

   http://support.microsoft.com/support/default.asp

ORDERING AN ARTICLE BY E-MAIL OR BY FAX

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

   mshelp@microsoft.com

Ordering an Article over the Phone and Having It Sent to a Fax Machine

To have an article sent to a fax machine, use the Microsoft FastTips System. Microsoft FastTips is available 24 hours a day, 7 days a week, from a touch-tone telephone. To order items from this article list, first note the five- to six-digit number of the Article ID shown for each item, and then follow these steps:

1. Dial the toll-free FastTips number:

         (800) 936-4100
   

2. When prompted, select the appropriate number for the product you are using (for example, for Microsoft Word, select 2).

3. When prompted, select the version of the product that you are using.

4. From the "FastTips Main Menu," select 1 to place a FastTips catalog order.

5. At the "to order items from your catalog" prompt, select 1.

6. When prompted with the "at the tone, enter the item ID number followed by the pound key" message, enter the Article ID number from the following list and press # (use the numbers following "Q," but do not include "Q").

         NOTE: You can order up to five items at a time.
   

7. When prompted, select the fax option and enter your three-digit area code and seven-digit fax number.

8. When you're finished ordering, hang up.

ARTICLE LISTING

 ITEM ID  ARTICLE TITLE                                               PAGES
 --------------------------------------------------------------------------

 Q88657  ACC: Functions for Calculating and Displaying Date/Time Values   7
 Q89610  ACC: Tips on How to Troubleshoot Microsoft Access Macros         2
 Q95608  ACC: How to Parse Comma-Separated Text into Multiple Fields      4
 Q97524  ACC: Round or Truncate Values to Desired Number of Decimals      4
 Q115915 ACC: Sample Expressions to Extract Portion of Text String        2

 Q129304 ACC: Using OLE Automation to Transfer Data to Microsoft Excel    6
 Q131583 ACC: Sending the Current Record to Word 97 with Automation       4
 Q132101 ACC: How to Get the Fiscal Year/Month of a Particular Date       3
 Q136062 ACC: Query by Form (QBF) Using Dynamic QueryDef (95/97)          5
 Q136122 ACC: DLookup() Usage, Examples, and Troubleshooting (95/97)      8

 Q140464 ACC: Form and Report Modules Are Public by Default (95/97)       3
 Q142476 ACC: Automation to Create and Manipulate an Excel Workbook       3
 Q142999 ACC: Tips for Debugging Visual Basic for Applications Code       7
 Q147816 ACC: Using Microsoft Access as an Automation Server             18
 Q153311 ACC: Using OLE Automation to Send a Microsoft Exchange Message   4

 Q154600 ACC: How to Parse Titles Beginning with "A," "An," or "The"      2
 Q155696 ACC: Rounding a Number Up or Down by a Desired Increment         3
 Q158941 ACC: How to Load OLE Objects from a Folder into a Table          3
 Q159692 ACC97: How to Create Command Bars Using Visual Basic Code        7
 Q159827 ACC97: Using Lightweight Objects in Microsoft Access 97          3

 Q160007 ACC97: Introduction to Stand-Alone Class Module Programming      7
 Q160011 ACC97: Cannot View Class Module in a Referenced Database Library 4
 Q160012 ACC97: How to Use Collections to Manage Class Objects in VBA     6
 Q160293 ACC97: How to Dim Menu Items or Disable Toolbar Buttons in Code  3
 Q160502 ACC: Using Automation to Add Appointments to Microsoft Outlook   4

 Q160870 ACC: VBA Functions Break in Database with Missing References     3
 Q161012 ACC: Using Automation to Run Microsoft Outlook                   3
 Q161014 ACC97: How to Animate the Office Assistant                       3
 Q161088 ACC97: Using Automation to Send a Microsoft Outlook Message      4
 Q161174 ACC97: Sample Procedure to Attach a Microsoft Outlook Folder     3

 Q161253 ACC: Automation Object Disappears When Code Finishes Executing   4
 Q161758 ACC97: Debug Window Is Not Displayed After Using Echo Method     3
 Q162074 ACC97: Macro to VBA Uses Unexpected Syntax with Form References  4
 Q163842 ACC: Compile Error After Converting Form Macros to VBA           4
 Q165056 ACC97: Compile Error Using Derived Math Functions in Help        2

 Q167061 ACC97: "Convert Macros to Visual Basic" Converts Incorrectly     4
 Q167066 ACC97: Compile Error with Converted Macro with RunSQL Stmt       3
 Q167222 ACC97: Form_MyForm Referencing Breaks After Converting from 95   6
 Q167765 ACC97: Custom Menu Macro Named "Menu Bar" Creates Duplicate Menu 3
 Q168311 ACC97: RunCommand Constants Truncated After 25 Characters        3

 Q168313 ACC97: DAO Property Retrieval Slow with Linked Table Objects     6
 Q168882 ACC97: Changing Project Name Doesn't Enable Compile Menu Command 2
 Q170532 ACC97: Cannot Call Class Module Methods from MS Access Objects   6
 Q170696 ACC97: "Can't Read" Error, Trying to Open MDE Containing Module  4
 Q175218 ACC97: New Module in Microsoft Access 97 Not Saved If Empty      3

 Q176012 ACC97: Add-ins, Wizards and Builders Need Read\Write Permissions 4
 Q177972 ACC97: Neatcd97.mdb Available on MSL                             2