Posts

Showing posts from November, 2012

Visual Basic Online Course - Run-time error '3021' : Either BOF or EOF is True, or the current record has been deleted.

Image
Visual Basic Online Course Run-time error '3021' : Either BOF or EOF is True, or the current record has been deleted. C ase : In Visual Basic 6.0 project with Database (e.g: MS-Access 2003) table, while trying to navigate through records you get the following error message. E rror No. : 3012 E rror description : Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record Solution : ♥ V isual B asic 6.0 Course Online : Automate MS-Access Database in Visual Basic 6.0 though a net work Visual Basic 6.0 Analog Clock Vi sual Basic 6.0 Temperature Convertor Visual Basic 6.0 , MS-Access 2003 and Crystal Reports - Phone book Visual Basic 6.0 , MS-Access 2003 Database and DataGridView Visual Basic 6 .0  FTP full application source code Visual Basic 6.0 Color Picker tool source code Visual Basic 6.0 TreeView Control lesson ( Part1 - Part 2 - Part3 - Part4 - Part5 ) Arabic. Visual Basic 6.

Visual Basic Online Course - Retrieve Structure of a Database Tables and Views

 Visual Basic Online Course  OpenSchema O penSchema M ethod How do I list all Views only, from within my Database ?  - Retrieve all the Queries/Views only from MS-Access 2003 Database into VB6 using the code. Using OpenSchema Method Example Code : - If you wish to list all the tables only, then change this line : If RS!TABLE_TYPE.Value = " VIEW " Then To If RS!TABLE_TYPE.Value = " Table " Then - If you wish to list all Tables and Views. Simply remove the "If , Else" Statement. Regards, Evry1falls ♥ V isual B asic 6.0 Course Online : Automate MS-Access Database in Visual Basic 6.0 though a net work Visual Basic 6.0 Analog Clock Vi sual Basic 6.0 Temperature Convertor Visual Basic 6.0 , MS-Access 2003 and Crystal Reports - Phone book Visual Basic 6.0 , MS-Access 2003 Database and DataGridView Visual Basic 6 .0  FTP full application source code Visual Basic 6.0 Color Picker tool source code Visua