Microsoft KB Archive/122723

-

The information in this article applies to:


 * FastTips for Microsoft Visual Basic for Windows, version 3.0

-

INSTRUCTION
Microsoft FastTips is available 24 hours a day, 7 days a week, from a touch-tone telephone. To order items from this catalog, first select the items you want to receive, noting the five- to six-digit number of the Item ID shown below for each item, and then:


 * Dial the toll-free FastTips number (800) 936-4300.
 * When prompted, select Microsoft Visual Basic.
 * Press one (1) on your phone keypad to select Express Order Service.
 * When prompted, select the delivery method, fax.
 * When prompted, enter your three-digit area code and seven-digit fax number on your phone keypad.
 * When prompted, enter the number of the Item ID and press #, for up to five items.

When finished, simply hang up. If you have problems receiving a fax, please call (425) 635-3199.

ARTICLE LISTING
ITEM ID ARTICLE TITLE                                               PAGES -- Q 97181 How to Keep the Current Record the Same After Using Refresh     2 Q 97413 How to Copy Current Database Record into a Record Variable      4 Q 97414 How to Use Data Control to Scroll Up and Down in a Recordset    3 Q 99704 How to Implement the DLookup Function in Visual Basic           3 Q 101553 BUG: Bad Result If Multiple Aggregate Functions in SQL Stmt    2

Q 102479 BUG: Domain Functions Available Only Within SQL Statement      2 Q 102481 UPD: New Access Engine MSAJT110.DLL Available                  1 Q 102681 PRB: Error When Updating Fields in Dynaset That Has 2+ Tables  2 Q 103442 Differences Between the Object Variables in VB Version 3.0     4 Q 103702 UPD: DOC: Data Access Guide Index -- A through Me              15

Q 103703 UPD: DOC: Data Access Guide Index -- Mo through Z              16 Q 103807 How to Convert a Text File into a New Access Database          4 Q 103808 Limitations of the Data Control in Visual Basic Version 3.0    2 Q 104155 Examples Show How to Query BIBLIO.MDB Database                 4 Q 104459 PRB: Error 3219 When Updating Record Set Created w/ Distinct   2

Q 104875 How to Encrypt a Microsoft Access Database in Visual Basic     2 Q 104983 Referential Integrity Enforced for DBs Created in Access       2 Q 105171 PRB: Error 13 (Type Mismatch) & Error 3061 w/ SQL Queries      2

Q 105990 How Visual Basic Handles Security Set by Microsoft Access      7

Q 107751 LONG: PERFORM.TXT - Performance Tuning Tips for VB and Access  7 Q 109830 How to Speed Up Data Access by Using BeginTrans & CommitTrans  2 Q 110069 How to Use Wildcards in SQL Query to Make Dynasets & Snapshots 3 Q 112195 How to Read Database Fields Into and Out of a List Box         2 Q 112767 How to Perform Microsoft Access Macro Action Via DDE from VB   1

Q 113332 BUG: AddNew Method Gives Error: Illegal Function Call          2 Q 113390 How to Delete All Records from MDB Database Table In VB 3.0    3 Q 113436 How to Drag Data from a Grid to a List Box in VB 3.0           3 Q 113589 How to Highlight an Entire Row of Cells in the Grid Control    1 Q 113592 How to Perform a Union Query in Visual Basic Version 3.0       2

Q 113594 Updated ACC2COMP.TXT for Jet 2.0/VB 3.0 Compatibility Layer    7 Q 113684 Install Issues Microsoft Jet 2.0/VB 3.0 Compatibility Layer    2 Q 113685 Files Included in Jet 2.0/ VB 3.0 Compatibility Layer          2 Q 113687 BUG: Field Name Same as Reserved Word Can Cause GP Fault       2 Q 113899 How to Convert a Database Table into an Excel Spreadsheet      2

Q 113901 How to Query for Literal Special Characters in a Where Clause  3 Q 113903 DOCERR: More Info & Doc Fixes for FindFirst & Seek Methods     3 Q 113951 How to Obtain & Distribute the Compatibility Layer             2 Q 113955 How to Use FindFirst with Strings that Have Apostrophe in VB   4 Q 113956 How to Use TOP N Query from Microsoft Access 2.0 in VB 3.0     2

Q 113957 How to View Photos from the NWIND.MDB Database in VB 3.0       4 Q 114080 How to Create and Use Multiple-Field Index in Visual Basic 3.0 3 Q 114344 How to Perform SubQuery on Microsoft Access 2.0 DB in VB 3.0   3 Q 114771 BUG: Disk or Network Error with Data Access Objects            2 Q 115779 BUG: Compacted 1.1 DB Becomes 2.0 DB w/ Compatibility Layer    2

Q 115833 How to Use the New MS Access 2.0 DDL Additions in VB 3.0       5 Q 115976 How to Modify VISDATA Sample to Work with Compatibility Layer  4 Q 116034 PRB: Compatibility Layer Error: Can't open any more tables     2 Q 118647 PRB: No Tables Listed in RecordSource of Data Control          2 Q 119112 PRB: GPF in MSAJT200.DLL Viewing SQL Prop. of Pass-Thru Query  2

Q 119244 BUG: No Error Produced when Data Changed in DataControl        2 Q 119732 ComLyr Files Needed when Distributing VB Applications          2 Q 119733 BUG: Error with Edit Method After Rollback of Previous Edit    2 Q 119738 How to Quickly Search a List Box                               2 Q 124709 UPD: Out of Memory Error w/ AddNew/Update on Dynaset or Table  3

Q 129882 How to Optimize SQL Queries in Visual Basic 3.0 and 4.0        2

End of listing.

Keywords         : kbref kbVBp300 Version          : 3.00 Platform         : WINDOWS Issue type       : kbinfo Last Reviewed: June 2, 1999