Control Records Displayed in a Subform

Control Records Displayed in Subform Control Records Displayed in a Subform Video 1 (5:18) Klingest Asked — What I want to do is, that when you select a record in the subform showing “tblCalculation”, the related values from “tblSubCalculation” shall be displayed in the other subform.  How can I do that? In this video I answer … Read moreControl Records Displayed in a Subform

Option Group Label Color Change

Option Group Label Color Change Option Group Label Color Change Video 1 (7:17) This video demonstrates a code module which allows you to change the colour of the selected option group label, and optionally collect the caption of the selected label. The code module is generic, it will work for any option group containing any number … Read moreOption Group Label Color Change

Open one Form from Another and transfer Data

Form Load, Activate, Open, Issue  Form Load, Activate, Open, Issue  Video 1  (3:58) Video 1  (3:58) More Info on Form Load, Activate, Open:- Not Available … … Form Values passed to Controls  Form Values passed to Controls  Video 2 (1:22) Video 2  (1:22) More Info on Form Values passed to Controls Not Available … … … Read moreOpen one Form from Another and transfer Data

Import CSV

  Import one CSV into two Tables Import CSV Video 1 (2:15) Import the Comma Separated Value file (CSV )into a staging table. Then run two queries against the staging table. One query to extract “H” into a new table, the other to extract “R” into a new table. Video 1 (2:15) More Info on Import CSV:- … Read moreImport CSV

Control Wizard (Access 2007)

  Control Wizard Control Wizard Video 1 (2:09) Demonstrate how to use the MS Access (2007) command button wizard to open another form and filter it to display the same record on the second form as you were looking at in the first form. Video 1 (2:09) More Info on Control Wizard :- Not Available … …