Visual Basic Online Course - MS Access 2003 Database Structure

Visual Basic 6 By
Visual Basic Online Course
MS Access 2003 Database Structure

These are 2 methods on how to work with MS-Access 2003 Database components directly like (Tables & Queries) without opening your Data-Base file using ADO 2.8 .
1) Using OpenSchema
- Create new MS-Access 2003 DB (MyDb.mdb)
- Create VB6 Project
- Database (Fname Text 50,Lname Text 50, Nphone Text 50, Xemail Text 50)
- Place both in the same directory of course.
- Open your VB6 Project, from menu choose
(Project, References, Microsoft Ado 2.8 and Microsoft ADOx)
click to enlarge

- Visual Basic Code Snippets :


Source Code - MediaFire.com Link
visual basic 6, vb6 source code,vb6 tutorials
My name is Ahmed Samir, I work as an Internal Auditor in a Gov. major co. My passion is in programming and blogging.

Comments

Post a Comment

visual basic 6 source code says (Hi)

VB6 Popular Posts

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

18 comments Visual Basic 6 By
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 6.0

Visual Basic Online Course - Temperature convector

81 comments Visual Basic 6 By
Image
Visual Basic Online Course Temperature Convertor - Using Scroll Bars  Scroll Bar control is a very handy tool for Visual Basic programmers. It is used in many tricks like (sizing, scrolling texts .... etc) Visual Basic ScrollBar example Temperature Convector Desktop application source code project is a good example for Visual Basic beginners to start studying ScrollBars and how handy they are for a programmer as a tool on the form. Scrollbars in Visual Basic 6.0 is free to use, easy to place on a form (Horizontally or Vertically) according to your need in the design-time (IDE), in our example we will place one Scrollbar on the form and some labels, TextBoxes and CommandButtons as in the photo below . Temperature Convector VB6 Source Code What is Celsius and Fahrenheit ? - Celsius is a scale and unit of measurement for temperature. It is named after the Swedish astronomer Anders Celsius (1701–1744), who developed a similar temperature scale. The degree...
Visual Basic 6.0

VB 0.6 TreeView Control Lesson Part2

Visual Basic 6 By
Image
بسم الله الرحمن الرحيم Micr osoft Visual Basic 6.0 TreeView Control توقفنا فى الجزء الاول عند انشاء الـ Nodes   اليوم نتحدث عن الجزء الثانى من TreeView Control فى بيئة الـ Visual Basic 0.6 و هو : أولا : TreeView LineStyles Property أو خاصية أشكال رسمة الـخط - نعرف الان كل TreeView لها ImageList عباره عن الاشكال من الأيقونات و الخطوط التى تظهر فى أداة الـ TreeView و منها الخطوط التى تربط الـ Nodes ببععضها و تمثل شكل العلاقه بين الـ Nodes كما بالصورة رقم (1) . LineStyles - كود تحديد شكل الخط : Object.LineStyle = number - حيث : Object هو : عادة يكون الـ TreeView number هو : رقم أو ثابت يدل على نوع شكل الخط كما سيوضح فى الاعدادات Settings الاتيه - الاعدادات Settings : الثابت القيمة الوصف tvwTreeLines 0 الشكل الافتراضى. يظهر بشكل خطوط بين الـ Nodes فى نفس المستوى Siblings و ابائها فى مستوى أعلى tvwRootLines 1 رسم خطوط تمثل العلاقه بين الـ Nodes فى نفس المستوى و بين الـ Nodes فى مستوى أعلى و ايضا رسم خطوط تمثل العلاقه بين الـ Node...
Visual Basic 6.0