Visual Basic Classic

163K

Solutions

58K

Contributors

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Share tech news, updates, or what's on your mind.

Sign up to Post

The Email Laundry
A company’s greatest vulnerability is their email.

CEO fraud, ransomware and spear phishing attacks are the no1 threat to a company’s security. Cybercrime is responsible for the largest loss of money to companies today with losses projected to reach $2 trillion by 2019.

When a company’s email is down, business is down.

To prevent your company from cyber crime, email security is the only solution.


The Email Laundry keeps you safe from the threats organisations face every day with cutting edge CEO Algorithms, Phishing Sensors, URL Scanners and Threat Intelligence.

The Email Laundry’s comprehensive service barricades your organisation from all incoming threats which allows you to focus comfortably on your company's interests.

The Email Laundry are trusted worldwide by secured multinational companies in the healthcare financial, oil and gas industries.

We are also the highest rated email security company by IT professionals on Spiceworks.

The Email Laundry guarantees to keep your company safe!
0
Free Tool: Port Scanner
LVL 11
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Basic Error Handling code for VBA and Microsoft Office
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code.

This lesson, Part 1, is the basics.  Whether you are writing VBA for Excel, Access, Word, or another Microsoft Office application,  basic error handling is the same.

01. Set up the error handler


   At the top of the code for your procedure, the error handler is set up using     On Error GoTo Proc_Err

02. Exit Code


   After whatever your procedure does, a line label for the exit code (such as Proc_Exit: ) is used to signify what happens at the end of the procedure. This can be code to cleanup object variables, or simply code to gracefully exit.

03. Error Handling Code


   After the exit code, a line label for the error handling code (such as Proc_Err: ) is used to begin what happens if there is an error.
Books_START_ErrorHandling_CopyDownB.xlsm
Books_ErrorHandling_CopyDownBlanks_.xlsm
3
 

Expert Comment

by:chris pike
For someone who is trying to wrap their brain around VB for the first time, this video is starting to shed light on the subject.
Well done video, very helpful.

Thanks so much.
I will definitely look out for more videos from crystal (strive4peace).
0
 
LVL 23
thank you, Chris and you're welcome  ~ if you have any questions about basic error handling, please post them here.
0
Using a Criteria Form with an Access Report
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that appears when the user runs the report.

1. The video provides two examples of reports that load forms on the reports' open events.

2. The code both in the reports and the criteria forms is explained so that the viewer can understand all of the steps involved in capturing report criteria on a form.

5
Creating and Using an Access Class Module
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from a less-experienced developer.

1. The video begins by walking the viewer through the process of creating a class module.

2. We then add properties and methods to the custom class that we create.

3. Finally we write code to instatiate the class, set the values of the custom properties, and execute a method of the class.

1
Executing a Windows API Function from Access
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). Using the Windows API, you can extend the functionality of Microsoft Access.

1. To call Windows API functions, you must first declare the functions and required type structures.

2. This video covers the steps necessary to declare Windows API functions

3. Declare the related type structures and variables

4. Then call the functions from a module.

6
 
LVL 34

Expert Comment

by:Mike Eghtebas
Hi TechMommy,

I am one of your remote students from 1990's and had purchased your Access 2.0 videos (I guess it was published by key-stone). This is my first opportunity to thank you the wonderful work you had done on those videos.

Back to this "Windows API" project. Is it possible to have the code files to save time typing them?

Thank you,

Mike
0

Visual Basic Classic

163K

Solutions

58K

Contributors

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.