03 – The USysRibbons Table
In this post I will be introducing the Access Ribbon. Featured Videos: 03 – The Ribbon Table Featured Downloads AccessRibbon03
James Satori-Brunet
02 – Explanation of the Code
In this post, we will be briefly explaining the code for this Ribbon: You fill first need to create a table called USysRibbons that contains a ID(AutoNumber), RibbonName(Text) and RibbonXML(Memo) fields.
08 – Recordsets
In this post I will be explaining Recordsets. Featured Videos: References Opening A RecordSet Simple Recordsets Featured Files: Access VBA Fundamentals – Level 5
07 – Loops
In this post I will be demonstrating the For…Each, For…Next and While…Wend loops. Featured Videos: For…Each For…Next Step While…Wend Featured Files: Access VBA Fundamentals – Level 5
04 – Opening A Form
In this post I will be explaining how to open a form and discussing some of the events associated with it. Featured Videos: Opening A Form Events Associated With Opening A Form Featured Files: Access VBA Fundamentals – Level 2
06 – Arrays
In these 3 videos I will explain how arrays work and the ReDim and ReDim Preserve statements. Featured Videos: Arrays ReDim ReDim Preserve Featured Files: Access VBA Fundamentals – Level 4
05 – Conditionals and Branching
In this post I will be discussing the If Statement and Select Case statements in VBA. Featured Videos: The If…Then Statement The If…Then…Else Statement The If…Then…ElseIf Statement Select Case Select Case In Action Featured Files: Access VBA Fundamentals – Level…
03 – Functions
In this post I will be explaining how Database functions work and teaching you to create your own custom functions. Featured Videos: Database Functions Custom Functions Featured Files: Access VBA Fundamentals – Level 3
02 – Objects, Properties and Methods
In this post I will be discussing objects, properties and methods and how to reference them from a form. Featured Videos: Objects, Properties and Methods Referencing Properties Featured Files: Access VBA Fundamentals – Level 1
05 – The Code Explained
In this post I will be explaining how the code for the Word module works. Create a module called modWelcomeLetter in Access. Add this code:
What is Microsoft Access?
So, what is MS Access? MS Access is a tool designed for effective data management. It is used by millions the world over and is an effective substitute for Excel when the quantity of data gets too large to control effectively. MS…
Normalization
Normalization is the process of rearranging the fields and tables of a relational database to reduce data redundancy and dependency. Normalization typically consists of splitting up big tables into smaller sized (and fewer redundant) tables along with characterizing relationships between them. The objective would be to separate data to ensure that additions, deletions and alterations to a field can be made in only one table and then propagated throughout the remainder of the database through defined…
02/28 – Generating SQL
Click here to go to the downloads page. Please select: VBAIntermediate02
28/28 – HyperLinks
Click here to go to the downloads page. Please select: VBAIntermediate28
27/28 – Writing Lots Of Code Quickly!
Click here to go to the downloads page. Please select: VBAIntermediate05
26/28 – Referencing Active Controls
Click here to go to the downloads page. Please select: VBAIntermediate26
25/28 – Tag Property
Click here to go to the downloads page. Please select: VBAIntermediate25
24/28 – Dynamically Creating Variable Names
Click here to go to the downloads page. Please select: VBAIntermediate24
23/28 – Comments
Click here to go to the downloads page. Please select: VBAIntermediate23
22/28 – Do While
Click here to go to the downloads page. Please select: VBAIntermediate22
21/28 – BOF and EOF
Click here to go to the downloads page. Please select: VBAIntermediate21
20/28 – RecordCount Property
Click here to go to the downloads page. Please select: VBAIntermediate20
19/28 – Filtering A Recordset
Click here to go to the downloads page. Please select: VBAIntermediate19
18/28 – Opening A Query As A Recordset
Click here to go to the downloads page. Please select: VBAIntermediate05
17/28 – Month Function
Click here to go to the downloads page. Please select: VBAIntermediate16
16/28 – For Loops And Arrays
Click here to go to the downloads page. Please select: VBAIntermediate16
15/28 – Multi-Dimensional Array
Click here to go to the downloads page. Please select: VBAIntermediate15
14/28 – Function To Return Days In Month
Click here to go to the downloads page. Please select: VBAIntermediate14
13/28 – DateDiff Function
Click here to go to the downloads page. Please select: VBAIntermediate13
12/28 – DateAdd Function
Click here to go to the downloads page. Please select: VBAIntermediate12
