18. (Advanced Programming In Access 2013) Managing Subform Interactions With VBA

[@swapnilwankhede3440]

Hi Steve Excellent Tutorials, Thanks a lot Steve for uploading this videos, it’s really helpful, never found such good videos.

[@bumpersmith]

As always you hit on the challenges that others do not take the time to tackle like the #Name situation when no data is supplied

[@artsafari8157]

Thank you! Clear, concise, and thorough - a running theme in your videos!

[@markwilliams9771]

Yes, I especially liked this video because it gave me the answer to a problem I had with my project. I wasn't using subforms, but this works the same if you have a combo box and checkbox on the header of a form and the data loads in the details section.

[@ProgrammingMadeEZ]

+Mark Williams Indeed, it is the same method for subforms as it would be for comboboxes or listboxes, but you want to set the rowsource instead of the recordsource.

[@ProgrammingMadeEZ]

Shakeel Kashif, I am unable to reply to your comment directly due to KZbin lameness, but essentially you want charts. I will go over charts later in this advanced series.

[@SanteFrezza]

thank you. Very helpful

[@renejamis2149]

Hi Steve, My question is somewhat related to the video. Form: frmNavS -> NavigationControl0 -> NavBtnIP loads NavInPogressS whose RecordSource is a Query that has the Count function. The form is a Datasheet view & one of the fields is a Hyperlink that opens a form to allow the user to apply a checkmark to the selected row. Once the checkmark is applied, I have a Save button that saves then closes the form returning the user to the previous form which had not been closed to begin with, so the row the user clicks on still shows the [ReAssign] checkbox not checked. I have tried a few variations of the VBA Forms method to requery the form they are returned to, but can't seem to work it out. These are the 2 I thought would make the most sense but did try at least 2 other variations. I also tried using the Requery Macro on the "On Data Change", "On Activate" and "Got Focus" events for the "NavInProgressS" form but no dice. [Forms]![frmnavs].Requery [Forms]![frmnavs].[Form]![NavigationControl0].Requery More than a little bit stuck here, thoughts? Thanks in advance.

[@venkatyalamati3285]

Sir, thanks for the video.. how do I make the subform current highlighted record as the main userform current record?

[@tmhmttrmh]

Great videos! Thanks so much for offering them up on KZbin! In video #18 at about 4:50 there's mention of an option to disable the subform and not display it when the parent form loads. Using the On Load event. I'm curious what code would you use in the event procedure to cause the subform not to load?

[@kadnacer7571]

hi steve 1-if we want to filter using two combobox or more, how do we do?. 2-if we want to filter using comboboxes with checkboxes or listboxes, how do we proceed?

[@angeldsouza5712]

Great video's. Q: Can we add subform record into a new table?

[@jimstauble9375]

Doesn't the RecordSource property automatically do the Requery when it is set?

[@HarveyFrench]

Add a vbCRLF between each SQL line, when building SQL statements, they become much easier to read in a text editor (or the SQL editor). I use the function below. Dim a as string a= "" aa a, " SELECT *" aa a, " FROM Tab1" aa a, " WHERE 1=2" Public Sub aa(ByRef str1 As String, ByVal str2 As String) ' This routine is very useful when creating SQL statements as they become much easier to read and debug (it has been written as a sub NOT a function as this makes it easier to use) str1 = str1 & vbCrLf & str2 End Sub Very good videos. Good pace and well considered.

[@ProgrammingMadeEZ]

Harvey French Indeed this is a good tip. Something I don't usually do but would help when trying to read the SQL.

[@HarveyFrench]

Thanks.

[@iskra1974]

Just a question. With linked table you can execute query based on value in linked table? So when you update value in sql table it is directly cpoied in linked tAble?

[@nymakara9965]

Good video! but Can you help me? I want to know how do we clear data on textbox or cbobox in Subform by one button in Main form?

[@MonicaSacanle]

Sir i am a first timer when it comes to access programming and for now i need to make a Human Resource Information System using access and i watch your videos as my guide. do I need to assign different table for Personal Info , Family background and educational Background because there's so many field for each one of them . Thank you Sir in advance . I hope you will guide me anyway .

[@rafiullah-zz1lf]

Is it possible to do this with more fields

[@mahmoudafify1387]

hello dear iam so thankful for all the information which you giving to us please help me , i have a query and i want to show message if the result of the query is nothing thx,

[@SAK30395]

HI Steve Sir, I am Student and working on one project to make BI dashboard ,where data is stored in SQL .I need your help how can i make KPIs dashborad ,may around 12 charts in one page and filtered by different KPIs. Many Thanks

[@imusmanmustafa]

hello sir! I want to know that how we can show all ov the records when our combo box empty. you showed that how to show the empty subfrom, but what would be the case if we want to show all of the records?

[@ProgrammingMadeEZ]

As I mentioned, you set the "rowsource" for a listbox or combobox.

[@alharamedu7708]

Sir, Just solve it👇 I want to enter multiple enteries in sub form using unbounded boxes can you tell me how can i do this..?