Display Records from Dictionary to Form

Best Microsoft Access Programmer Portland OR

Display Records from Dictionary to Form

We will do a similar exercise that we did for Collection Object, for displaying Table Records retrieved from Collection Object on Form, based on the Key value selection from a Combo-box on the Form.

We will add Employee Records to Dictionary Object, with Last Name as Key.  Design a sample Form with a Combo box on the Header Section of the Form and few Text Boxes in the Detail Section, to display the employee information from Dictionary Object, when the Last Name Key … Read More

Add Class Objects as Dictionary Items

Best Microsoft Access Programmer Portland OR

We have learned the fundamentals of Dictionary Object, done trial runs for sorting simple items and displayed Access Table records through Dictionary Object to Ms-Access Form.

Now, let us learn how to add Ms-Access Class Objects to Dictionary and how to retrieve each item and display it’s Property Values and Method output in Debug Window.

If you would like to go back and take a look at earlier related Articles then the links are given below.

Read More

Update Class Object Dictionary Item through Form

Best Microsoft Access Programmer Portland OR

Update Class Object Dictionary Item through Form

Last week we have done a trial run for adding/retrieving Class Objects into/from Dictionary Object Items.  One important point we have highlighted there was that each Class Object Item added to the Dictionary Object must be a new instance of the Class Object, every time.  

This is not peculiar to Class Object or Dictionary Object alone.  This  method must be followed to avoid inadvertent loss of important data, while adding Objects to Collection, Dictionary or to the Array of an Object itself.  As … Read More

WithEvents Ms-Access Class Module Tutorial

Best Microsoft Access Programmer Portland OR

WithEvents Ms-Access Class Module Tutorial

There are Class Modules on Forms and Reports.  Almost all Controls on Form, like Command Buttons, Text Boxes, Combo Boxes, List Boxes and others  have Event s Coding features that makes Ms-Access a powerful Database Management System.

Text Box have GotFocus, LostFocus, BeforeUpdate, AfterUpdate  and other Events and we write VBA Code in them to do various tasks, like data entry control, validation checks or calculations on entered data and so on. 

The OnClick Event Procedure of Command Button launches Forms or Reports … Read More

Winging it to the San Juan Islands with Access

Best Microsoft Access Programmer Portland OR

Recently, the Access product team paid a visit to Jason Douglass, the owner of San Juan Airlines, based in Bellingham, WA. Jason runs scheduled and charter flights in Washington and British Columbia to and from the lovely San Juan islands. Jason has a varied background in the Ceramics, Aerospace Electronics, Data Storage, and Software Industries.Read More

Smart City PDX prepares information privacy guidelines to support next generation of digital services for city government operations

Best Microsoft Access Programmer Portland OR

Smart City PDX, in collaboration with Mayor Ted Wheeler’s office and the Office of Equity and Human Rights, is taking a new set of guidelines to Portland City Council to help protect private and sensitive data managed by the City of Portland. These privacy and information protection principles emerged from the need that local governments must prioritize and plan for emergent information technologies used in government services. Together, we are building the next generation of digital public services and we want all Portlanders to … Read More

WithEvents and Defining your own Events

Best Microsoft Access Programmer Portland OR

WithEvents and Defining your own Events

Hope that you have gone through last week’s WithEvents, Event, RaiseEvent introduction, tried out the sample Forms and understood as how both Form based VBA Code relates each other.  We will try out the same example differently here, with one Form and a Class Module and see what change required in Class Modules to capture Events from Form Module.

From here on we will be using Form and Class Module combination for capturing built-in Events from Form and execute required code in Class Module.… Read More

Page 842 of 849
1 840 841 842 843 844 849