VBA Beginner

VBA Beginner

Command Button

Command Button

Video 1 (5:47)

In this video, the first of a set of 12 I demonstrate how to create your first VBA code. First, create a Form, then a Command Button. Use the Command Button to open a Message Box and display “Hello World”

Video 1 (5:47)

… …

Setup the Northwind dB

Northwind dB

Video 2 (1:19)

In this video I demonstrate how to find and load a Microsoft Access Demo Database, in particular the Northwind Sample. I show how to set up the Navigation Pane, how to set Compact on Close and how to set it up to use Tabbed Documents. I also explain how to Display a Particular Form when the database Loads up…

Video 2 (1:19)

… …

Import From a dB

Import From a dB

Video 3 (1:20)

In this video I demonstrate how to import external data. In particular how to Import Objects from another MS Access Database.

Video 3 (1:20)

… …

Creating Macros

Creating Macros

Video 4 (4:54)

Demonstration of how to use the Command Button Wizard to generate Macros. Demonstrates how to Convert the Macros into VBA Code. A nice and gentle way of getting a foothold in the VBA world

Video 4 (4:54)

… …

Opening a Query

Opening a Query

Video 5 (9:53)

Demonstration of how to use the Command Button Wizard to generate Macros. Demonstrates how to Convert the Macros into VBA Code. A nice and gentle way of getting a foothold in the VBA world

Video 5 (9:53)

… …

Opening Another Query

Opening Another Query

Video 6 (6:42)

Here, I how how to create an “AND” and an “OR” Query in the Query Designer grid. I show how to Create and setup an Option Group I present the values Returned by an Option Group in a Message Box I demonstrate how to Open two Queries with one Button:- Using an If Statement and using a Select Case Statement. I emphasize the importance of using an “Else” clause in your Case Statement

Video 6 (6:42)

… …

Searching For Answers

Searching For Answers

Video 7 (1:27)

Link for Searching Access World Forums:-  

Video 7 (1:27)

… …

Events

Events

Video 8 (4:11)

Video 8 (4:11)

… …

Queries on a Form

Queries on a Form

Video 9 (6:25)

Video 9 (6:25)

… …

Queries on a Form - Recap

Queries on a Form - Recap

Video 10 (4:03)

Video 10 (4:03)

… …

VBA Queries - P1

VBA Queries - P1

Video 11 (7:13)

Avoid having lots of queries, lots of forms. Adopt an approach where you have one Form and modify it with VBA for different use.

2:20 Demonstrate how to swap forms in and out of a sub Form Window.

1:40 Explanation of a subform/subreport control. The name of this control (subform/subreport control) is unwieldy and unclear as to its use. A much better name for it would have been subform window (In your Code write “”subFrmWin””) and that’s what I call it! It tells you exactly what it does.

3:08 Demonstrate how to change the source object property of a sub form window with VBA.

3:27 Demonstrate how to transfer the text from a query into a form module so that the query can be manipulated by VBA code.

4:18 Demonstrate how to easily remove the reference to the table from a simple SQL statement.

5:30 Demonstrate how NOT TO create string variables!

Video 11 (7:13)

… …

VBA Queries - P2

VBA Queries - P2

Video 12 (8:36)

MS Access VBA formats the text wrongly, turns an Asterix into a multiplication sign. The query is outside of the form, if the form is closed the query doesn’t work properly. The query needs a loaded form but the form was closed, so it didn’t work. SQL view of a query. Like * (“”Star””) in query criteria. You can’t have the same type of speech marks within a string (surrounded by speech marks). Find a Form in a Subform window and read or write to the Record Source, changing the subject of a subform window (Subform/Subreport Control). You now have the ability to manipulate queries with VBA

Download the sample database this video is based on here:-

Video 12 (8:36)

… …

Rank with VBA

Rank with VBA Heading HERE… Video 1 (7:06) This 1st video follows along from the presentation below. The presentation goes over the basic idea, then the

Read More »

Value

Use “Value” or Not? I’ve noticed a couple of minor glitches caused by the default of a ‘textbox’, the value; not being assigned explicitly. It’s

Read More »

More Useful Stuff HERE:-