26/28 – Referencing Active Controls

Click here to go to the downloads page.
Please select: VBAIntermediate26

Related Posts

01/28 – Creating A Calendar
02/28 – Generating SQL
03/28 – Manipulating Combo Boxes
04/28 – Calling Sub Procedures
05/28 – Variable Scope
06/28 – OnLoad Event
07/28 – Break On All Errors
08/28 – Option Explicit
09/28 – Initialising Variables
10/28 – DateSerial Function
11/28 – Weekday Function
12/28 – DateAdd Function
13/28 – DateDiff Function
14/28 – Function To Return Days In Month
15/28 – Multi-Dimensional Array
16/28 – For Loops And Arrays
17/28 – Month Function
18/28 – Opening A Query As A Recordset
19/28 – Filtering A Recordset
20/28 – RecordCount Property
21/28 – BOF and EOF
22/28 – Do While
23/28 – Comments
24/28 – Dynamically Creating Variable Names
25/28 – Tag Property
27/28 – Writing Lots Of Code Quickly!
28/28 – HyperLinks

As always, a site wouldn't be anything without its users so please feel free to comment! We welcome any comments you have on the material and any suggestions you may have for future content.

In our humble opinion, it is worth commenting just so you can play with Fun Captcha below!

1 Comment

  • Garry Smith says:

    Do you have a video that uses a generic routine that controls the user as far as allowing adding records, editing records and deleting records in a form with a multi record sub form. I want the user to start out in the form being able to only view the records and must click on a button or some kind of control before adding or editing a record so they are aware of what is going to happen instead of possibly changing data by mistake?
    Also since Access puts a default value in a currency control automatically the user must erase the value in order to fill the control with the real data can you show how to automatically select the default value so that if the user just starts typing the default value will be erased automatically? I do not want to set this option to do this automatically in the database options.