Microsoft KB Archive/122724

-

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 71067 How to Set Tab Stops in a Visual Basic List Box                 5 Q 104339 PRB: TableDefs Not Updated When SQL Statement Creates Table    1 Q 105539 How to Use VB Control Property or Variable in SQL Statement    2 Q 105540 PRB: Error or GP Fault When Pass Data Control as Control       1 Q 105766 PRB: Invalid Property Value When Binding Masked Edit Control   4

Q 106270 PRB: Illegal to Use Find Method with Table Object Variable     2 Q 106492 How to Call SQL Stored Procedures from Visual Basic            2 Q 106493 PRB: Invalid Database Object after Rollback without BeginTrans 2 Q 106494 PRB: No Current Record Error In VB When Database is Empty      3 Q 106535 How VB Can Determine If Table Is Locked By Other Processes     2

Q 107074 How to Change Read-Only Access of a Data Control at Run Time   3 Q 107362 BUG: Name Not Found in This Collection When Deleting Member    2 Q 107363 BUG: Incorrect VB Error When Delete Index on Open Table        3 Q 107748 How to Create a Parameter Query in Visual Basic for Windows    3 Q 107871 Microsoft Access Database RAM Cache Is Faster Data File Method 2

Q 108145 VISDATA Example of Every Data Access Function in VB Prof 3.0   3 Q 108146 How to Create a Microsoft Access Database using VB Prof 3.0    2 Q 108147 How to Copy Table from One Database to Another in VB Prof 3.0  3 Q 108148 How to Delete a Field from a Populated Table                   7 Q 108149 Comparison of Seek Versus Find Methods, for VB Data Access     3

Q 108150 How to Count Rows Affected Before Query in VB Prof ver 3.0     1 Q 108235 DOC: Revised Index Property (Data Access)                      2 Q 108379 LONG: Overview of Data Access in Visual Basic Version 3.0      6 Q 108380 PRB: Find Methods Don't Use Indexes to Speed Up VB Data Access 2 Q 108423 How to Attach an External Database Table to a VB 3.0 Database  3

Q 108467 How to Request Exclusive Use of a Table in VB Prof 3.0         2 Q 109053 PRB: Using RecordCount with VB Dynasets, Snapshots, and Tables 3 Q 109136 Basic Cannot Get Description Shown in Access Table Design View 1 Q 109219 How to List the Fields in a Table & the Tables in a Database   4 Q 109563 How to Use SQL Outer Join to Find All Table B Records Not in A 1

Q 109995 PRB: Dynaset Loses Contents After Transaction Rollback         2 Q 110497 How to Use Seek and MoveNext to Find a Group/Range of Records  2 Q 110588 How to Copy a Record from One Table to Another in VB           1 Q 110618 PRB: Object Variable Not Set When Referencing Data Control     1 Q 110722 PRB: Commit or Rollback without BeginTrans Error and VB Forms  3

Q 110723 Documentation and Features for Visual Basic's Data Manager     2 Q 110732 PRB: Error: Couldn't Lock File SHARE.EXE Hasn't Been Loaded    1 Q 110752 How to Use SQL SELECT Statement Without Field Syntax Error     2 Q 110753 Create Database with Data Manager & View w/ Text/Data Control  2 Q 110959 How to Delete a Table from a Database Using Visual Basic       2

Q 111286 PRB: Novell Btrieve Unexpected Error from External DB Driver   1 Q 111304 PRB: VB Record Too Large When Add or Update Record > 2K        3 Q 113335 How to Create Nested Queries in Visual Basic 3.0 Prof Edition  5 Q 113437 BUG: SQL Server GetDate Function Error: Record is deleted    3 Q 113701 How to Access Multiple Databases in an SQL Query               4

Q 113949 PRB: GetChunk & AppendChunk Not Allowed on Non-Memo Fields     2 Q 113953 How to Use the Three Levels of Database Locking in VB 3.0      7 Q 114592 How to Construct a Self-Join Query in Visual Basic 3.0         2 Q 115237 How to Use Temporary Tables in SQL Server from Visual Basic    7 Q 115712 How to Fill a List Box from a Snapshot Generically             3

Q 115986 How to Avoid Common Database Programming Mistakes in VB        2 Q 120073 How to Rotate a Pen Windows Application                        6 Q 120172 Summary of Tips to Improve Data Access Speed in VB version 3.0 3 Q 130646 PRB: DAO References Not Enabled When Porting an Older VB App   1 Q 137025 FAQ: Most Frequently Asked Questions About VB 3.0 SQL Queries  5

End of listing. Additional query words: DSKBGuide 3.00 kblist kbtlc

Keywords         : kbref Version          : 3.00 Platform         : WINDOWS Issue type       : Last Reviewed: June 9, 1999