WX1237: Advanced Topics Questions and Answers (7.0)

• Microsoft Access version 7.0

Moderate: Requires basic macro, coding, and interoperability skills.

The "Advanced Topics Questions and Answers" (WX1237) Application Note contains questions and answers about advanced topics in Microsoft Access version 7.0.

You can obtain this Application Note from the following sources:

• Microsoft FastTips Technical Library
• Microsoft Product Support Services

THE TEXT OF WX1237

  Microsoft(R) Product Support Services Application Note (Text File)
             WX1237: ADVANCED TOPICS QUESTIONS AND ANSWERS

                                                   Revision Date: 9/95
                                                      No Disk Included

 INFORMATION PROVIDED IN THIS DOCUMENT AND ANY SOFTWARE THAT MAY
 ACCOMPANY THIS DOCUMENT (collectively referred to as an Application
 Note) IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER
 EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE IMPLIED
 WARRANTIES OF MERCHANTABILITY AND/OR FITNESS FOR A PARTICULAR
 PURPOSE. The user assumes the entire risk as to the accuracy and
 the use of this Application Note. This Application Note may be
 copied and distributed subject to the following conditions:  1) All
 text must be copied without modification and all pages must be
 included;  2) If software is included, all files on the disk(s)
 must be copied without modification (the MS-DOS(R)  utility
 diskcopy is appropriate for this purpose);  3) All components of
 this Application Note must be distributed together;  and  4) This
 Application Note may not be distributed for profit.

 Copyright (C) 1995 Microsoft Corporation.  All Rights Reserved.
 Microsoft, MS-DOS, and Windows are registered trademarks of
 Microsoft Corporation.

1. Q. How can I create an expression to extract a portion of a text
      field?

   A. To extract a portion of a text field, use expressions that
      contain the Left(), Right(), InStr(), and Mid() functions.
      These expressions are commonly used in the Update To line of an
      update query to place a portion of a larger field into a new
      field.

      For example, to extract the name "John" from a field containing
      the name "John Doe," use the following expression:

          Left([FullName],InStr(1,[FullName]," ")-1)

      and to extract the name "Doe" from the name "John Doe," use the
      following expression:

          Right(Trim([FullName]),Len(Trim([FullName]))-
          InStr(1,[FullName]," "))

      For additional information about parsing character strings,
      order item number Q115915 by selecting the FastTips Technical
      Library option from the FastTips Main Menu.

2. Q. How can I create an expression to return a value from a table
      or query using the DLookup() function?

   A. With the DLookup() function, you can return a value from a
      specified set of records, such as a table or query. The syntax
      of the Dlookup() function is as follows:

          DLookup(<expression>, <domain> [, <criteria>] )

      The function has the following three arguments:

       - <Expression>: Identifies the field that contains the data in
         the domain that you want returned

       - <Domain>: Identifies the table or query that contains the
         data you want returned

       - <Criteria>: An optional string expression, similar to a WHERE
         clause in an SQL statement, that restricts the range of data
         used in the function

      The DLookup() function returns one value from a single field
      even if more than one record satisfies the criteria. If no
      record satisfies the criteria or if the domain contains no
      records, the DLookup() function returns a null.

      For additional information about using the DLookup() function,
      order item number Q136122 by selecting the FastTips Technical
      Library option from the FastTips Main Menu.

3. Q. How can I calculate date/time data to display specific dates or
      elapsed time?

   A. Microsoft Access stores the Date/Time data type as a double-
      precision, floating-point number (up to 15 decimal places). The
      integer portion of the double-precision number represents the
      date; the decimal portion represents the time. Because a
      date/time value is stored as a double-precision number, you may
      receive incorrect formatting results when you try to display
      specific dates or calculate elapsed time greater than 24 hours.

      For additional information about calculating date/time data,
      order item number Q88657 by selecting the FastTips Technical
      Library option from the FastTips Main Menu.

4. Q. How do I create synchronized combo boxes?

   A. With synchronized combo boxes, you can make a selection in
      combo box 1, which then filters combo box 2 to list only items
      related to the selection in combo box 1. For a detailed example
      of creating synchronized combo boxes, order item number Q98660
      by selecting the FastTips Technical Library option from the
      FastTips Main Menu.

5. Q. Can I open multiple copies of the same form?

   A. Yes, in Microsoft Access for Windows 95, you can open multiple
      instances of the same form. Opening multiple instances of a
      form gives you the flexibility to work on more than one record
      at once. For example, in an Order Entry program, you can start
      taking an order, pause and take a second order, and then return
      to the first order without losing any data.

      For additional information about opening multiple instances of
      a form, order item number Q135369 by selecting the FastTips
      Technical Library option from the FastTips Main Menu.

TO OBTAIN THIS APPLICATION NOTE

• You can have this Application Note mailed or faxed to you from the automated Microsoft FastTips Technical Library, which you can call 24 hours a day, 7 days a week at (800) 936-4100. NOTE: The FastTips Technical Library is available only to customers within the U.S. and Canada.
• If you are unable to access the source(s) listed above, you can have this Application Note mailed or faxed to you by calling Microsoft Product Support Services Monday through Friday, 6:00 A.M. to 6:00 P.M. Pacific time at (425) 635-7050. If you are outside the United States, contact the Microsoft subsidiary for your area. To locate your subsidiary, please see the Microsoft World Wide Offices Web Site at:

        http://www.microsoft.com/worldwide/default.htm
  

Keywords          : Fstqa Softlib kbappnote kbfile kbfasttip
Version           : 7.0
Platform          : WINDOWS
Hardware          : x86
Issue type        : kbinfo