Computer Learning Zone CLZ Access Excel Word Windows

You can not become a scientist if you require that every question has an answer because its the very questions that have no answer that attract you to a laboratory every single day.

-Neil deGrasse Tyson
 
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
 
 
 
Courses - Microsoft Visual Basic 201
Description: Intermediate Microsoft Visual Basic
Running Time: 83 minutes
Pre-Requisites: Visual Basic 107 strongly recommended
Versions: We use Microsoft Visual Basic 6.0, but lessons are valid for most earlier versions of VB, including 4 and 5. If you have VB.NET or VB 2005, the Visual Basic code we use is similar, but the programming interface has changed. These VB courses do NOT cover VBA (Visual Basic for Applications) which is what you need for Microsoft Office programming. For VBA, see the individual Office applications (Word, Excel, Access, etc.) Click here for more information on VB.NET courses.


Order Now: $19.99

 

 

 Click here for the Teacher's Outline
 
Notice: this course covers the older Visual Basic 6.0 programming application. Microsoft no longer sells VB6. If you want to learn VB6, you'll have to find a used copy somewhere like eBay or Craigslist. We will be updating this course for use with Visual Basic 2013 soon. If you've purchased this course within the last year, you'll get a free upgrade when it's released.

This course follows VB107. We'll cover one of the most important topics yet: reading and writing text files. We'll start out learning how to write a text file. We'll learn about the Open, For Output As, Print #1, Close #1, and FreeFile commands.



We'll keep the first example easy - enter a customer's name
and a filename, and save the data to the file.
 

Now that we know how to save data to a file, we'll learn how to read it back in. We'll learn about the Open For Input command, Line Input, creating our own subroutine, and the Shell command.



Our program has gotten more sophisticated. We can save the
data to a file, load it back in, and View it with the Notepad application
using the Shell command to launch a program. The program also
saves the size of the form too - so the next time it loads to the same size
 

Next we'll learn how to save multiple items. We'll load up a bunch of customers into a ListBox and then save all of those items to a file.



Now we can type in a customer, add him to the listbox, and then
save the entire contents of the listbox at once.
 

In this lesson we'll also learn about the TabIndex property which is how you control your Tab Order - the order in which you move between fields when you press the TAB key on your keyboard.

Next, we need to learn how to read this list of customers back in when the program starts, so we'll learn how to fill the listbox back up from our saved records.

This means we will need to learn how to break up a delimited string into its individual parts. We'll learn about the InStr function and EOF marker. We'll learn the With keyword, and how to send a parameter to a sub.



Breaking down comma-delimited strings is easy once you know InStr
 

I know the screenshots from this class don't look exciting, but we cover a lot of great material in this class. Learning how to read and write information to disk is extremely important, and is a fundamental method of making your programs work.


 

 Click here for the Teacher's Outline
 


Try a FREE Demo Lesson

 
 
 

 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 3/28/2024 8:30:52 AM. PLT: 0s